Using DBMS_SQL [message #38357] |
Mon, 15 April 2002 05:01 |
mousie
Messages: 9 Registered: March 2002
|
Junior Member |
|
|
Hi;
I've got a problem with DBMS_SQL; I have a main proc which execute another proc with dbms_sql ; but the problem is that the called proc take a boolean parameter as an IN OUT parameter. How then can I call it within the main proc ?
My code looks like :
create or replace testproc(flag IN OUT BOOLEAN) is
begin
...
end testproc;
the testproc modifies set flag to TRUE or FALSE;
and the main proc is :
create or replace procedure main is
flag BOOLEAN;
str DBMS_SQL.VARCHAR2S;
begin
flag:=FALSE;
...
str(1):='declare';
str(2):='begin';
str(3):='testproc(' => here's the pb : how can i
pass my flag variable as a parameter ?
....
end;
Thank you for any help.
|
|
|
Re: Using DBMS_SQL [message #38403 is a reply to message #38357] |
Tue, 16 April 2002 19:33 |
Dinesh J.V.
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
Hi,
Call the Test_proc passing some input parameter and
get the output in a local or global variable as the case may be,and use this variable in Query of second proc..
test_proc(in_parameter,lv_flag(out parameter)
now in ur main proc.. use
str(3):= use lv_flag as variable.
Hope i am clear.Get back to me for any issues
Dinesh
|
|
|