Oracle Database Dynamic SQL Execute anonymous block
Example
You can execute anonymous block. This example shows also how to return value from dynamic SQL:
declare
query_text varchar2(1000) := 'begin :P_OUT := cos(:P_IN); end;';
in_value number := 0;
out_value number;
begin
execute immediate query_text using out out_value, in in_value;
dbms_output.put_line('Result of anonymous block: ' || to_char(out_value));
end;
/
