A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Refactoring for Software Design Smells: Managing Technical Debt
this week in the
OO, Patterns, UML and Refactoring
JDBC and Relational Databases
operator IN and NUMBER
Joined: Nov 08, 2010
Jan 07, 2011 12:09:52
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.
Joined: Dec 20, 2006
Jan 07, 2011 12:46:15
That should work.
OCUP UML fundamental and ITIL foundation
Joined: Aug 22, 2010
Jan 11, 2011 09:11:27
Post the whole of your procedure.
Note that plain
is not supported in a procedure, but that should trigger the P.LS-00428 error.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: operator IN and NUMBER
how to catch ORA-00920 in PL/SQL procedure ?
What is wrong with this procedure?
Getting exception while passing List<Long> from hibernate to Stored Procedure
Difference between rowid and rownum in sql query??
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015