Tuesday, January 11, 2011

Test Oracle Stored procedures

Testing proc with input and output variables.

declare
outVar1 varchar2(20);
outVar2 varchar2(100);
begin
PKG_NAME.PROC_NAME('INPUT1', 'INPUT2', outVar1 , outVar2);
dbms_output.put_line('outVar1-->'||outVar1);
dbms_output.put_line('outVar2-->'||outVar2);
end;
/