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!

ORA-01001 Invalid cursor error with table functions

571901Apr 13 2007 — edited Apr 13 2007

I have a cursor querying a table function in the main procedure of the package. I have no compile errors, but, when I try to execute, I get ORA-01001 Invalid cursor error.

I stripped the code out to an anonymous block and it works fine. I copy the code back to the package procedure and it fails.

Any ideas?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 11 2007

Added on Apr 13 2007

8 comments

1,099 views