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!

PLS-00221: <function> is not a procedure or is undefined

422557Sep 3 2004 — edited Sep 3 2004
Howdy all.

I am having a problem with executing a function. I have created a function, and I can view it in Enterprise Manager. I can do a DESC on it in SQL*Plus.

However, when I attempt to execute the function in SQL*Plus or in my VB front end, I am getting the error below:

PLS-00221: <function> is not a procedure or is undefined

I am using the same user that created the function to try to execute it. I tried creating a PUBLIC synonym for the function and executing it. I tried executing it with the SCHEMA.function sytax. ALL with no success.

Is there something outstandingly simple that I am missing that anybody has seen with an issue like this before?

wally
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2004
Added on Sep 3 2004
3 comments
14,729 views