Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pass a list to Oracle Stored procedure

77346Jun 1 2004 — edited Sep 2 2004
I would like to pass a string as an input parameter to a Oracle procedure.I would then like to use this string as an "IN" clause in my select statement
Eg.select deptno from emp where empno in (ip_parameter)

However if I give the ip_parameter='7,8,9' I get an 'Invalid Number' error.
Can somebody please help----
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 30 2004
Added on Jun 1 2004
13 comments
1,664 views