Return
-
Title
Error using bind variables defined by the Define statement: "ORA-00904: Invalid Identifier" -
Description
When the following code is executed an "ORA-00904: Invalid Identifier" is displayed:
define xdate = to_date('18-jan-2008');
select * from tablename where columnname = &&xdate;
Set Scan ON option is toggled on. Code executed successfully in 5.5.4.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.