Dynamic Cursors (1)
uSyntax
declare
v_cur
SYS_REFCURSOR;
v_sql_tx
varchar2(32000):=...
v_rec ...%rowtype; --
or record type
begin
open v_cur for
v_sql_tx;
fetch v_cur into
v_rec;
close v_cur;
end;
uMost common use:
ØProcessing large datasets with unknown structure
