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-08103 object no longer exists

420445Aug 8 2005 — edited Aug 8 2005

Hi,
I have written one pl/sql block in which have some i/p parameters at the same time i have one output ref cursor. I am using 8 to 10 global temporary tables for this procedure. The procedure runs successfully without any error but when i am trying to print this ref cursor i get a error message as

ORA-08103 object no longer exists

no rows selected

even if the table still exists in the database.

Thanks in advance!!!!!!!!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 5 2005

Added on Aug 8 2005

1 comment

531 views