Re: How to test run a procedure at SQL plus mode

"C Chang" <cschang_at_maxinter.net> wrote in message news:3BD0F6BA.7FFA_at_maxinter.net...
> I have writen a procedure as
> Create or replace procedure my_test ( p_A IN varchar2,
> p_B IN number,
> p_err OUT number,
> p_errText OUT varchar2)
> As
> ...
>
> I want to test this procedure at SQL plus mode. How do I test my_test
> procedure? at
> SQL> execute my_test( A, B, ???)
> What I should put for p_err or p_errText?
>
> C Chang

doesn't work with execute

you need
declare
p_err_num number;
p_err_text varchar2(1000);
begin
my_test(1,'bbb',p_err_num, p_err_text);
end;

or alternatively, depending on version (WHY IS THAT SO DIFFICULT TO INCLUDE?) you can define them
as VARIABLE p_err_num number;
etc
and use the execute call
and PRINT them afterwards

Hth
Sybrand Bakker
Senior Oracle DBA Received on Sat Oct 20 2001 - 00:19:21 CDT