Skip to Main Content

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!

Cursor with IN CLAUSE in PACKAGE

505551Apr 28 2006 — edited Apr 28 2006
Hi
Hope someone can help and I'm really not sure why Oracle makes it so difficult.

To simplify, I have a package that takes an associative table - tabStr = {a,b,c}
as input.Based on this, it build a string variable varStr which is of type 'a','b','c'

I need to return a ref cursor
OPEN out_refCur for select * from tab where col in (varStr)

If I hardcode - varStr than out_refCur return data.
But the above does not.

I'm open to using even tabStr but could not find any example.

Any inputs? Please ignore syntax .... since that not the issue.

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2006
Added on Apr 28 2006
3 comments
335 views