-- Created on 2021/7/6 by YUBL declare sql_cmd varchar2(2000); out_number number(4); begin sql_cmd:=' declare BEGIN select :num+1 into :out_num from dual; END;' ; execute immediate sql_cmd using 10,out out_number; dbms_output.put_line(out_number); end;
output 结果:
11