Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to get an OUT parameter from forms_ddl into an edit box from

Status
Not open for further replies.

alexdbora

Programmer
Oct 25, 2004
25
0
0
RO
hi

I want to call a procedure with IN and OUT parameters with FORMS_DDL, something like this.
----
DECLARE
procname char(10);
par1 varchar2(100);
BEGIN
procname:=:block1.name_proc;
par1:=:block1.acord;
forms_ddl('declare rezultat varchar2(200);'||'begin '||procname||'('||''''||par1||''''||',rezultat'||')'||';'||'end;');
:block1.prel_value:=rezultat;
END;

-----

My problem is.
I use this command in a form, on when-button-pressed trigger.
<procname> is a name of a procedure, I get it from :block1.name_proc

I try to capture the out parameter named <rezultat> in an edit box :block1.prel_value from the form, but I can't do that!
The procedure works well, but I can't get the out parameter.

Please tell me how to get this parameter in my form.
Thanks.




 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top