When I run a query with a bind variable set by a DEFINE statement in SQL Navigator 6.1, I get the error: "ORA-00936 missing expression."
For example:
DEFINE x= (<int1>,<int2>,<int3>,... etc);
SELECT column_id FROM schema.t WHERE column_id in &&x;
column_id is of type INTEGER for this example.
This use to work in SQL Nav 5.5.
WORKAROUND:
Run the query, with the bind variable, without the DEFINE statement and using the convention :x or &x. Then enter the bind variable value at the variable prompt.
STATUS:
Waiting for fix to be released in a future version of SQL Navigator for Oracle.
