Home » Developer & Programmer » Forms » procedure  () 1 Vote
procedure [message #291699] Sun, 06 January 2008 02:08 Go to next message
aparna_ora
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...

Report message to a moderator

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: 4596
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.

Report message to a moderator

Re: procedure [message #292401 is a reply to message #291701] Tue, 08 January 2008 21:31 Go to previous message
djmartin
Messages: 10181
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.

David

Report message to a moderator

Previous Topic: Create and Open Directories or folders on windows
Next Topic: where can i found forms & reports 6i best books
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 07 00:08:37 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.