Thanks for the question, Ricardo.
Asked: June 10, 2021 - 10:30 am UTC
Last updated: June 11, 2021 - 5:06 pm UTC
Version: 11g
Viewed 1000+ times
declare myvar number := 4; begin select rule into v_stmt from rules where rule_id=1; --v_stmt -> 'begin :a := my_function(my_var, 1), 1); end;' execute immediate v_stmt; end; /
set serveroutput on declare myvar number := 4; begin execute immediate 'begin dbms_output.put_line ( :myvar ); end;' using myvar; end; / 4
Ricardo Oberdan Pereira, June 11, 2021 - 12:00 pm UTC
Check out more PL/SQL tutorials on our LiveSQL tool.
PL/SQL reference manual from the Oracle documentation library