[my_lou]

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.

[my_lou]

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.