OraFAQ Forum: Forms » HOW TO CALL DATABASE PROCEDURE FROM FORM

Home » Developer & Programmer » Forms » HOW TO CALL DATABASE PROCEDURE FROM FORM

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

HOW TO CALL DATABASE PROCEDURE FROM FORM [message #85416]

Wed, 23 June 2004 22:26

hany
Messages: 40
Registered: May 2004

Member

HI
i have create stored procedure on the database

i want to call this procedure from my form
i did it like:
DOUPL_VALE.DISCONS('BL_BILLING','CUSTOMER_ACCOUNT_ID_FK_C');

BUT form return error: DOUPLE_VALES.DISCONS MUST BE DECLARED

i want to know HOW CAN I CALL STORED PROCEDURE FROM MY FORM.
THANKS
HANY

Report message to a moderator

Re: HOW TO CALL DATABASE PROCEDURE FROM FORM [message #85418 is a reply to message #85416]

Wed, 23 June 2004 22:57

M Ravindra
Messages: 3
Registered: June 2004

Junior Member

Preceede your Stored procedure name with user/schema name
in a Form you can call like this
<Username>.DOUPL_VALE.DISCONS(....);

Report message to a moderator

Previous Topic:	How to Query an LOV Form with UNION query
Next Topic:	Diff. betw. Pre-Form & When-New-Form-Instance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 31 20:45:34 CST 2025