SQL ERROR 20904

General discussion forum about all databases other than SqlBase.
kumarravik

SQL ERROR 20904

Post by kumarravik » 23 Jan 2014, 16:23

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

Re: SQL ERROR 20904

Post by VEspinal » 23 Jan 2014, 19:12

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

Re: SQL ERROR 20904

Post by kumarravik » 24 Jan 2014, 12:13

many thanks ..:-) have a great weekend

VEspinal

Re: SQL ERROR 20904

Post by VEspinal » 24 Jan 2014, 18:07

No worries.

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

Cheers,
Victor

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest