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!

Getting error : java.sql.SQLException: ORA-21700: object does not exist or

716679Aug 16 2011 — edited Aug 16 2011
CREATE or REPLACE PROCEDURE First(
firstName_Entity OUT Second.RefCsr
)
AS
CURSOR c1
IS
SELECT first_name FROM employee;

firstName pkg_type_def.output;

BEGIN

OPEN c1;
FETCH c1 BULK COLLECT INTO firstName;
CLOSE c1;
open firstName_Entity for select * from table(firstName); --at this line i am getting error.
END;
/

CREATE OR REPLACE PACKAGE pkg_type_def
AS
TYPE output IS TABLE OF employee.first_name%TYPE;
END;
/


Searched then found
ORA-21700: object does not exist or is marked for delete

Cause: User attempted to perform an inappropriate operation to an object that is non-existent or marked for delete. Operations such as pinning, deleting and updating cannot be applied to an object that is non-existent or marked for delete.

Action: User needs to re-initialize the reference to reference an existent object or the user needs to unmark the object.

I dont know where i am going wrong,still i am not able to fix it.
when i execute .sql file then i got message "Procedure created.". then i accessed this from java, i got above mentioned error.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 13 2011
Added on Aug 16 2011
3 comments
494 views