Error: PL/SQL: ORA-00904: invalid identifier
KdeGraafApr 21 2008 — edited Apr 21 2008Hi 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?