Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    57

    Unanswered: odd CREATE VIEW problem.

    that's odd. here is what happens. when i do this:

    SQL> CREATE VIEW
    2 "MY_ADDSTUDENTTARGET" ("DEMOGRAPHICID","ETHNICITYID","REFERRERID","DEMOG RAPHICSTUDENTID","ACADE
    MICYEARID","DOB","EMAIL","FNAME","HOMEADDRESS1","H OMEADDRESS2","HOMECITY","HOMECOUNTRY")
    3 AS
    4 SELECT DEMOGRAPHIC.DEMOGRAPHICID, DEMOGRAPHIC.ETHNICITYID, DEMOGRAPHIC.REFERRERID, DEMOGRAPHIC.
    STUDENTID, STUDENT.ACADEMICYEARID, STUDENT.DOB, STUDENT.EMAIL, STUDENT.FNAME, STUDENT.HOMEADDRESS1,S
    TUDENT.HOMEADDRESS2, STUDENT.HOMECITY, STUDENT.HOMECOUNTRY
    5 FROM DEMOGRAPHIC, STUDENT;

    it works fine without any problems. However, if i add just one more column, like this:

    SQL> CREATE VIEW"MY_ADDSTUDENTTARGET" ("DEMOGRAPHICID","ETHNICITYID","REFERRERID","DEMOG RAPHICSTUDEN
    TID","ACADEMICYEARID","DOB","EMAIL","FNAME","HOMEA DDRESS1","HOMEADDRESS2","HOMECITY","HOMECOUNTRY","
    HOMEPOST")
    2 AS
    3 SELECT DEMOGRAPHIC.DEMOGRAPHICID, DEMOGRAPHIC.ETHNICITYID, DEMOGRAPHIC.REFERRERID, DEMOGRAPHIC.
    STUDENTID, STUDENT.ACADEMICYEARID, STUDENT.DOB, STUDENT.EMAIL, STUDENT.FNAME, STUDENT.HOMEADDRESS1,S
    TUDENT.HOMEADDRESS2, STUDENT.HOMECITY, STUDENT.HOMECOUNTRY, STUDENT.HOMEPOST
    4 FROM DEMOGRAPHIC, STUDENT;

    i get this error:

    SELECT DEMOGRAPHIC.DEMOGRAPHICID, DEMOGRAPHIC.ETHNICITYID, DEMOGRAPHIC.REFERRERID, DEMOGRAPHIC.STUDE

    ERROR at line 4:
    ORA-00904: invalid column name

    The field HOMEPOST is a valid field in the table STUDENT. When i do a DESCRIBE on the table, i can clearly see the field HOMEPOST there and it has valid data in it. Is there some sort of a restriction on the number of columns you could have per view (i thought it was a 1000) or the length of the CREATE VIEW string? Any ideas?

    thanks.

  2. #2
    Join Date
    Oct 2003
    Posts
    57
    never mind, i figured it out. apparently, there is a command line string limit in pl/sql. you learn something new every day i guess.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •