Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01036 illegal variable name/number

Wander(Brazil)Feb 5 2007 — edited Feb 5 2007
Hi all,

I´m doing the follow select from delphi retrieving rows from oracle 10gR2 (64bits) and is giving the error: ORA-01036 illegal variable name/number

SELECT * FROM <TABLE>;

I saw that there is a field whith timestamp datatype on the table, so when I execute the following select, the same error is displayed.

SELECT <FIELD WITH DATATYPE TIMESTAMP> FROM TABLE;

Now, when i execute this select without the field with datatype timestamp the query is running fine !!!

Does any one knows where is the error ?

Thanks.

Best regards !

Wander(Brazil)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2007
Added on Feb 5 2007
3 comments
487 views