oracle存储过程测试
oracle存储过程测试
Sql代码 www.zzzyk.com
--SQL STATEMENT:
declare
i_result NUMBER;
s_accountnumber VARCHAR2(64);
s_batchno VARCHAR2(20);
s_sequence VARCHAR2(22);
begin
p_e_pin(i_result, s_accountnumber, s_batchno, s_sequence)
DBMS_OUTPUT.PUT_LINE(i_result);
DBMS_OUTPUT.PUT_LINE(s_accountnumber);
DBMS_OUTPUT.PUT_LINE(s_batchno);
DBMS_OUTPUT.PUT_LINE(s_sequence);
END;
/
--SQL COMMAND LINE:
var i_result NUMBER;
var s_accountnumber VARCHAR2(64);
var s_batchno VARCHAR2(20);
var s_sequence VARCHAR2(22);
exec p_e_pin(:i_result, :s_accountnumber, :s_batchno, :s_sequence);
print i_result;