ORACLEストレージプロセスplsqlの作成と実行(一)
1935 ワード
create or replace procedure test_xxx(
inputterm in varchar2,
return_value out varchar2) is
begin
return_value:='yes';
execute immediate 'truncate table a' ;
--delete from a
insert into a (
id --
)
select id_b
from b
commit;
exception
when others then
return_value:=substr(sqlerrm,1,300);
rollback;
end test_xxx;
b)
declare
v_city varchar2(100);
begin
test_xxx('a',v_city);
--dbms_output.put(v_city);
dbms_output.put_line(v_city);--
end;