Getting error : java.sql.SQLException: ORA-21700: object does not exist or
716679Aug 16 2011 — edited Aug 16 2011CREATE 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.