Home » Developer & Programmer » Forms » Database procedure or Forms procedure
Database procedure or Forms procedure [message #257712] Thu, 09 August 2007 01:21 Go to next message
swapnajojo
Messages: 40
Registered: June 2007
Location: India
Member

Hi Team,

Which procedure get fired first
Database procedure or Forms procedure

Thanks In Advance
Swapna
Re: Database procedure or Forms procedure [message #257716 is a reply to message #257712] Thu, 09 August 2007 01:26 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
A Forms procedure of the same name as a procedure in the database will be fired. The same named procedure in the database will NEVER be fired.

David
Re: Database procedure or Forms procedure [message #257718 is a reply to message #257716] Thu, 09 August 2007 01:29 Go to previous messageGo to next message
swapnajojo
Messages: 40
Registered: June 2007
Location: India
Member
Could you be more clear on this
Re: Database procedure or Forms procedure [message #257764 is a reply to message #257718] Thu, 09 August 2007 02:32 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
IF you have a forms procedure 'read_data' and a database procedure 'read_data'. Only the forms procedure will be accessable from that form. Except if you use the 'owner.read_data' form of the call at which point you should get the database copy.

David
Re: Database procedure or Forms procedure [message #257779 is a reply to message #257764] Thu, 09 August 2007 02:53 Go to previous messageGo to next message
swapnajojo
Messages: 40
Registered: June 2007
Location: India
Member
Thanks for your prompt response
Re: Database procedure or Forms procedure [message #257827 is a reply to message #257712] Thu, 09 August 2007 05:09 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Well this depends on the event.
Re: Database procedure or Forms procedure [message #258024 is a reply to message #257827] Thu, 09 August 2007 18:47 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
@azamkhan

What do you mean by 'event'? Are you saying that you can access the 'same named' database procedure from a form without using the 'owner_id'?

David
Re: Database procedure or Forms procedure [message #258094 is a reply to message #258024] Fri, 10 August 2007 03:16 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
My Dear Friend David no I m not saying that all I meant was that which trigger fires first depend on the event.
Re: Database procedure or Forms procedure [message #258134 is a reply to message #258094] Fri, 10 August 2007 06:28 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm afraid you are the first one who ever mentioned triggers in this topic. In other words, you've missed the point.
Re: Database procedure or Forms procedure [message #258310 is a reply to message #258134] Fri, 10 August 2007 23:58 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
I said from the point of view that when you execute a procedure there must be an event that will trigger a code whether it is forms or database.

But you meant to say if you want to check the performance of a database and forms procedure then it is obvious that it is the database procedure which will execute fast then a form procedure. But again it depends on the contension on the server.

As you know that when ever you execute any statement or database procedure or function it is placed in the buffer cache so that it can be reused if that same piece of code is executed again but if to many procedure are called at database level then this might cause the buffer cache tobe flashed and this may raise the issue of reducing the performance of Oracle database server.

But simply saying to your question it is database procedure or function or statement that give you best performance then form.

But this doesnt mean that we should try to keep all code on database to get optimize performance.

Regards,
Azam Khan
Re: Database procedure or Forms procedure [message #258502 is a reply to message #258310] Sun, 12 August 2007 19:55 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
The original question is:
Quote:
Which procedure get fired first
Database procedure or Forms procedure
Please note that the key word is 'FIRST' not 'FAST'. The question has nothing to do with speed or performance but order.

David
Re: Database procedure or Forms procedure [message #258576 is a reply to message #258502] Mon, 13 August 2007 01:56 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
I am assuming that the procedure is called on same event through form and database. Again it depends on your piece of code which you are using in your procedure.

I mean if it has SELECT queries or cursor then database procedure will run fast than Form.

But if your procedure has loops, conditions etc I mean no or very few select then of course if will run fast on Forms.
Re: Database procedure or Forms procedure [message #258590 is a reply to message #258502] Mon, 13 August 2007 02:18 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
djmartin
Please note that the key word is 'FIRST' not 'FAST'.

Previous Topic: how to give access to different logins ,on records
Next Topic: HOW 2 use ESC key in FORMS
Goto Forum:
  


Current Time: Wed Dec 07 08:52:06 CST 2016

Total time taken to generate the page: 0.12725 seconds