OraFAQ Forum: Forms » oracle froms

Home » Developer & Programmer » Forms » oracle froms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle froms [message #85633]

Wed, 14 July 2004 21:08

kal
Messages: 2
Registered: January 2002

Junior Member

hi there,

i need a help, can anybody tell me how to execute a database procedure or functions from the forms.

thanks in advance.

I try to use the execute command but it is doesnot work and in my form user selects the particular procedure and execute which will create a view or function at the backend.

jain

Report message to a moderator

Re: oracle froms [message #85634 is a reply to message #85633]

Wed, 14 July 2004 21:16

Himanshu
Messages: 457
Registered: December 2001

Senior Member

Hi,
Simply call the Procedure from your form with required parameters.

For e.g if you have a Procedure as follows:
Create or replace Procedure Proc1(A Number) is
Var1 Number(10);
Begin
..............
............
Exception
.........
End;

Then if you want to call this procedure from say Ke-commit trigger of your form simple write
Begin
X number(10):=5;
<Schemaname>.Proc1(X);
End;

HTH
Regards
Himanshu

Report message to a moderator