Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to test run a procedure at SQL plus mode

How to test run a procedure at SQL plus mode

From: C Chang <cschang_at_maxinter.net>
Date: Fri, 19 Oct 2001 23:59:54 -0400
Message-ID: <3BD0F6BA.7FFA@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 Received on Fri Oct 19 2001 - 22:59:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US