调用带有参数的存储过程:
create or replace procedure add_user(username in varchar2,password in varchar2,info out varchar2)
is
begin
info := username || ' ' || password;
end;
在 SQL 命令行中:
SQL> var res varchar2(50);
SQL> exec add_user('taoge','我爱你',:res);
SQL> print res;