存储过程测试

--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;