testing a created procedure
From: Bojie Cecilio <ececilio_at_nospam.idirect.com>
Date: Thu, 9 Jul 1998 22:12:16 -0400
Message-ID: <35a578ed.0_at_nemo.idirect.com>
I am a new user of Oracle. I wanted to know how to test on how a procedure runs.
Date: Thu, 9 Jul 1998 22:12:16 -0400
Message-ID: <35a578ed.0_at_nemo.idirect.com>
I am a new user of Oracle. I wanted to know how to test on how a procedure runs.
I know for a function, I could use "select function(input) from dual;" and would show me the results. How can I do the same for a procedure.
say I have,
create or replace procedure proctest(a in integer, b out integer)
as
begin
b:=a+1;
end;
How can I test the above procedure? Received on Fri Jul 10 1998 - 04:12:16 CEST