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!

Error PLS-00231

32685May 19 2004 — edited Sep 10 2008

Hello

In the select statement of a cursor I need to perform some reasonably complex calculations on a variety of columns. I was hoping to use a set of functions defined in a package to perform the calculations, but I am getting the

PLS-00231 function 'string' may not be used in SQL

Error, is the only way round this to take the functions out of the package and have them as separate functions, or will it work if I simply put them in a separate package from the one that contains the cursor?

Cheers

David

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2008
Added on May 19 2004
8 comments
19,761 views