Home » Developer & Programmer » Forms » procedure  () 1 Vote
procedure [message #291699] Sun, 06 January 2008 02:08 Go to next message
Messages: 14
Registered: September 2005
Junior Member
hi all

One common interview question is

when we write procedure for forms , which one is better method .. write procedure in database and call that in form or write procedure in program units of forms?

I think write procedure in forms is better way coz we need not to complie that procedure every time..

plz suggest me...
Re: procedure [message #291701 is a reply to message #291699] Sun, 06 January 2008 02:29 Go to previous messageGo to next message
Frank Naude
Messages: 4525
Registered: April 1998
Senior Member
A better answer might have been:

It all depends. For client side processing (non database stuff), put it in forms. For data intensive processing, put it in the DB. It's important to think about the amount of data transferred between the database and a form.
Re: procedure [message #292401 is a reply to message #291701] Tue, 08 January 2008 21:31 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
If the procedure only contains PL/SQL and no Forms commands I recommend putting it in the database.

Obviously if it contains ANY Forms command it can't go into the database but it might be a candidate for putting into a PLL.

Previous Topic: Go_item is not working
Next Topic: how to populate one column from database to list item
Goto Forum:

Current Time: Thu Aug 24 00:10:36 CDT 2017

Total time taken to generate the page: 0.02805 seconds