CREATE OR REPLACE PROCEDURE DEVELOPER.SPGETPORTLETSANDINSTANCES( USERID IN NUMBER, CR_PORTLETS OUT SYS_REFCURSOR , CR_PORTLETINSTANCES OUT SYS_REFCURSOR ) AS BEGIN DEVELOPER.SPGETPORTLETS(CR_PORTLETS); DEVELOPER.SPGETPORTLETINSTANCES(USERID, CR_PORTLETINSTANCES); EXCEPTION WHEN NO_DATA_FOUND THEN NULL; WHEN OTHERS THEN -- Consider logging the error and then re-raise RAISE; END SPGETPORTLETSANDINSTANCES; / When I run this procedure, it gives the following procedure: ORA-00604: error occurred at recursive SQL level 1 ORA-01001: invalid cursor
Can you tell me what the problem with this is?
Otherwise, you will probably have to diagnose the ORA-604 error. I answered this question previously as can be seen here:
Dig Deeper on Oracle database administration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.