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: 4509
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: Create and Open Directories or folders on windows
Next Topic: where can i found forms & reports 6i best books
Goto Forum:

Current Time: Thu Jun 22 20:57:14 CDT 2017

Total time taken to generate the page: 0.16880 seconds