Process Query (2)
uDefine a cursor in the dynamic block
u...
uv_process_tx :=
'DECLARE
u v_out_cl CLOB;
u v_row_tx
VARCHAR2(32000);
cursor c1 is '||in_sql_tx||';
TYPE DynamicTable_tt IS TABLE OF c1%rowtype
INDEX BY BINARY_INTEGER;
INDEX BY BINARY_INTEGER;
v_query_tt
DynamicTable_tt;
PROCEDURE p_addline (pi_tx VARCHAR2) IS
BEGIN DBMS_LOB.writeappend(v_out_cl,length(pi_tx),pi_tx);
END;
BEGIN
DBMS_LOB.createtemporary
(v_out_cl, TRUE, DBMS_LOB.CALL);
(v_out_cl, TRUE, DBMS_LOB.CALL);
p_addline(:1);
u...