Skip to Main Content

SQL & PL/SQL

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!

Error: PL/SQL: ORA-00904: invalid identifier

KdeGraafApr 21 2008 — edited Apr 21 2008
Hi all,

I'm making a procedure that will be stored on several databases, Oracle 11 and Oracle 12.

To be shure it work's on both version I have a check to see if the DB is 11 or 12. And depending on the version a query will be executed. Wich one that is depends on the DB version.

But How can I save a query in a procedure if that query won't work on that version of the database?
Because now I get a ORA-00904 because of a column in the query in that does not exists.

That column does exists on 12 but not 11. How can I prevent getting the ora-904?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2008
Added on Apr 21 2008
7 comments
1,052 views