How to call Database procedure in Forms [message #136273] |
Wed, 07 September 2005 04:41 |
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 |
|
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
|
|
|