SQL ERROR 20904

[kumarravik]

Hi Team,

i am using gupta team developer 4.2 and we have developed our business applications on that, connected with ORACLE 11G.

while performing one of application function, i am getting an SQL error 20904.

please let me know what kind of error is this and where to look to fix this.

Thanks
Ravi

[VEspinal]

Hi:

If errornumber >= 20.000 subtract 20.000 then you get Oracle-error-number.
20904 = ORA-00904: ORA-00904: invalid column name, string: invalid identifier Cause: The column name entered is either missing or invalid.

You tried to execute a SQL statement that included an invalid column name or the column name is missing.

Rewrite your SQL to include a valid column name. To be a valid column name the following criteria must be met:
•The column name must begin with a letter.
•The column name can not be longer than 30 characters.
•The column name must be made up of alphanumeric characters or the following special characters: $, _, and #. If the column name uses any other characters, it must be enclosed in double quotation marks.
•The column name can not be a reserved word.

HTH

Regards,
Victor Espinal

[kumarravik]

many thanks .. have a great weekend

[VEspinal]

No worries.

You are welcome, you too. Have a great weekend.

Cheers,
Victor