I want to transfer to the procedure a string with a query for the cursor. I try to do it like this:

DECLARE TYPE t_client_cursor IS REF CURSOR RETURN CLIENTS%ROWTYPE; v_client_cursor t_client_cursor; v_client CLIENTS%ROWTYPE; v_query_text VARCHAR2(100) := 'SELECT * FROM CLIENTS C WHERE ROWNUM < 4 ORDER BY C.CLNT_ID'; BEGIN OPEN v_client_cursor FOR exec (v_query_text); .... END; /

Swears

 ORA-06550: Трока 8, столбец 6; PLS-00455: курсор 'V_CLIENT_CURSOR' нельзя использовать в команде OPEN dynamic SQL ORA-06550: Строка 8, столбец 1: PL/SQL: Statement ignored

But somehow it should be possible to determine the cursor from the line?

1 answer 1

I understand you need something like this:

 declare v_client_cursor sys_refcursor; v_query_text VARCHAR2(100) := 'SELECT * FROM CLIENTS C WHERE ROWNUM < 4 ORDER BY C.CLNT_ID'; begin open v_client_cursor for v_query_text; ... close v_client_cursor; end; /