17,377
社区成员
发帖
与我相关
我的任务
分享
declare
num&new int ;
begin
num&new := 123;
dbms_output.put_line('num1' || num&new);
end;
SQL> create or replace procedure pro_num
2 as
3 num_new int;
4 begin
5 num_new :=123;
6 dbms_output.put_line('num_new:'||num_new);
7 end pro_num;
8 /
Procedure created
SQL> set serveroutput on;
SQL> exec pro_num;
num_new:123
PL/SQL procedure successfully completed
--你这只是一个匿名块,它的生存期只是执行期间,执行过后就不可以调用。
--你可以建立一个过程:
create or replace procedure pro_num
declare
num_new int ;
begin
num_new := 123;
dbms_output.put_line('num1:' || num_new);
end;
end pro_num;
set serveroutput on;
exec pro_num;