create or replace procedure proInWithdraw(accountNo varchar2,amounts Withdraw1416.withdrawSum%type,
tran_time date,result out number)
is
insert_oper exception;
pragma exception_init(insert_oper,-1);
begin
insert into Withdraw1416 values(accountNo,amounts,tran_time);
commit;
result:=0;
exception
when insert_oper then
result:=1;
end ;
/
declare
No Withdraw1416.accountNo1416%type;
total Withdraw1416.withdrawSum%type;
ti date;
n number;
begin
No := '170361';
total := 1500;
ti := to_date('1998-01-02','yyyy-mm-dd');
proInWithdraw(No,total,ti,n);
dbms_output.put_line('n的值为'||n);end;
过程没问题,但是红色部分为无效!请帮帮忙,谢谢!
tran_time date,result out number)
is
insert_oper exception;
pragma exception_init(insert_oper,-1);
begin
insert into Withdraw1416 values(accountNo,amounts,tran_time);
commit;
result:=0;
exception
when insert_oper then
result:=1;
end ;
/
declare
No Withdraw1416.accountNo1416%type;
total Withdraw1416.withdrawSum%type;
ti date;
n number;
begin
No := '170361';
total := 1500;
ti := to_date('1998-01-02','yyyy-mm-dd');
proInWithdraw(No,total,ti,n);
dbms_output.put_line('n的值为'||n);end;
过程没问题,但是红色部分为无效!请帮帮忙,谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货