create or replace procedure proc_ZF_QUERY_DETAIL(
@system_seq number,
@business_code varchar2,
@tran_datetime varchar2,
@psam_num varchar2,
@tmnum varchar2,
@zf_tran_seq varchar2,
@card_no varchar2,
@balance varchar2,
@currency_type varchar2,
@status varchar2,
@rspcode varchar2,
@bank_date varchar2,
@bank_time varchar2)
as
begin
Insert sys.zf_query_detail Values(@system_seq, @business_code, @tran_datetime,
@psam_num,@tmnum ,@zf_tran_seq, @card_no,@balance,@currency_type,@status,@rspcode,@bank_date,@bank_time)
end;
大哥帮帮忙;
create or replace procedure proc_ZF_QUERY_DETAIL(
system_seq number,
business_code varchar2,
tran_datetime varchar2,
psam_num varchar2,
tmnum varchar2,
zf_tran_seq varchar2,
card_no varchar2,
balance varchar2,
currency_type varchar2,
status varchar2,
rspcode varchar2,
bank_date varchar2,
bank_time varchar2)
is
begin
Insert into sys.zf_query_detail
Values(system_seq, business_code, tran_datetime,
psam_num,tmnum ,zf_tran_seq, card_no,balance,
currency_type,status,rspcode,bank_date,bank_time) ;
end proc_ZF_QUERY_DETAIL ;