Abt Stored Procedure in Forms 6i [message #20662] |
Wed, 12 June 2002 01:28 |
Sukhoi
Messages: 4 Registered: June 2002
|
Junior Member |
|
|
hello expert,
I am a very new to Forms. so plz can u guide me with step by step procedure to my problem which i have mentioned.
I want to execute the stored procedure from the form 6i. I have already compiled stored procedure in oracle.the problem for me now is to call the procedure by passing any value and capturings its out parameter.
BASICALLY :: HOW TO EXECUTE A PROCEDURE FROM FORMS 6i.
thanks to u in advance.
|
|
|
Re: Abt Stored Procedure in Forms 6i [message #20664 is a reply to message #20662] |
Wed, 12 June 2002 02:19 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
you create a trigger in Forms which calls the procedure and accepts the out parameter.
In case of a button btn_1, you could create a when-button-pressed trigger that looks like this
DECLARE
v_out NUMBER;
BEGIN
-- Call the procedure (looks like proc$my_procedure(param_out OUT NUMBER);
proc$my_procedure(v_out);
...
-- further processing
...
END;
HTH,
MHE
|
|
|