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.
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.