File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes operator IN and NUMBER Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "operator IN and NUMBER" Watch "operator IN and NUMBER" New topic

operator IN and NUMBER

Grace Green
Ranch Hand

Joined: Nov 08, 2010
Posts: 79
Is it allowed to run a query like

select * from table_name where table_name.col1 IN (1, 5, 18, 36);

It throws the ORA-00920 when in a PL/SQL procedure.
Jan Cumps

Joined: Dec 20, 2006
Posts: 2541

That should work.

OCUP UML fundamental and ITIL foundation
Martin Vajsar

Joined: Aug 22, 2010
Posts: 3717

Post the whole of your procedure.

Note that plain select * is not supported in a procedure, but that should trigger the P.LS-00428 error.
I agree. Here's the link:
subject: operator IN and NUMBER
It's not a secret anymore!