Home » Developer & Programmer » Forms » HOW TO CALL DATABASE PROCEDURE FROM FORM
HOW TO CALL DATABASE PROCEDURE FROM FORM [message #85416] Wed, 23 June 2004 22:26 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 07 22:15:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.