Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    Denver, Colorado
    Posts
    2

    Question Unanswered: ORA-00904: --Invalid Column..

    Anyone Please help!

    I am having a ploblem -- an error (ORA-00904: --Invalid Column..)when I query individual fields from a view [ i.e. "SELECT field1, field2,... FROM theviewname"]. However, the query runs as expected when I use the "SELECT * FROM theviewname". Could anyone tell me what might be the problem here, and any possible workaround to resolve this issue. The database server is an 8.17version.

    Thanks in advance,

    Paul Manega

  2. #2
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    It sounds as if the column names might be in the improper case.
    try using double quotes around the column names.

    ex:
    select "column_name" from table_name;

  3. #3
    Join Date
    Dec 2003
    Location
    Denver, Colorado
    Posts
    2
    Originally posted by tlael
    It sounds as if the column names might be in the improper case.
    try using double quotes around the column names.

    ex:
    select "column_name" from table_name;
    Thanks, it worked. I forgot that I created mixed-case field names in my view. I appreciate your help.

Posting Permissions

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