File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Author

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
Bartender

Joined: Dec 20, 2006
Posts: 2541
    
  10

That should work.


OCUP UML fundamental and ITIL foundation
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3717
    
  61

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: http://aspose.com/file-tools
 
subject: operator IN and NUMBER
 
It's not a secret anymore!