Home » Developer & Programmer » Forms » How to call Database procedure in Forms
How to call Database procedure in Forms [message #136273] Wed, 07 September 2005 04:41 Go to next message
mrpranab
Messages: 32
Registered: March 2005
Member
Hi,

I have developed one form and in the program units
i have created procedure.The same name procedure
i have created in the database level also.Now when
i call this procedure the form level procedure will
call first.Can I call the database level procedure
first instead of form level procedure.How can i do it?
Pls let me know?

Regards,
Pranab

Re: How to call Database procedure in Forms [message #136390 is a reply to message #136273] Wed, 07 September 2005 20:51 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Easy answer, change the name of the procedure in your form to something else. Hard answer, try putting the user on the call to the database, but this is VERY bad coding style. Eg change '... from dual' to '... from sys.dual'.

David
Previous Topic: ....Default tool bar and other option ..... & ....Default Toolbar
Next Topic: new oracle developer
Goto Forum:
  


Current Time: Fri Sep 20 00:54:57 CDT 2024