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!

PL/SQL Anonymous Block - Trying to Call Function within Cursor

cmit0227Jan 7 2009 — edited Apr 25 2013
Hello -

I need to create an anonymous block that contains a cursor and a function. I want to call the function from within the cursor, and the function will basically take an ID as its IN parameter, and will return a comma separated list of values.

However, when I try to do this I get the error " function 'GET_PAYMENT_DATES' may not be used in SQL".

Does anyone know of a workaround? I'm trying to avoid having to store this function.

Thanks,
Christine
This post has been answered by Keith Jamieson on Jan 8 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2013
Added on Jan 7 2009
18 comments
10,208 views