存储过程:
create or replace procedure test_procedure
(
idd in varchar,
sta in varchar
)
as
begin
update test_table set state = sta where id = idd;
commit;
end test_procedure;
表结构:
create table test_table {
id varchar,
state varchar
}
insert into test_table values('001','1')
在PL/SQL中调用存储过程:
begin
-- Call the procedure
test_bpms_delete_ru('001', '2');
end;