OraFAQ Forum: Forms » Database procedure or Forms procedure

Home » Developer & Programmer » Forms » Database procedure or Forms procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database procedure or Forms procedure [message #257712]

Thu, 09 August 2007 01:21

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

Report message to a moderator

Re: Database procedure or Forms procedure [message #257716 is a reply to message #257712]

Thu, 09 August 2007 01:26

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: Database procedure or Forms procedure [message #257718 is a reply to message #257716]

Thu, 09 August 2007 01:29

swapnajojo
Messages: 40
Registered: June 2007
Location: India

Member

Could you be more clear on this

Report message to a moderator

Re: Database procedure or Forms procedure [message #257764 is a reply to message #257718]

Thu, 09 August 2007 02:32

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: Database procedure or Forms procedure [message #257779 is a reply to message #257764]

Thu, 09 August 2007 02:53

swapnajojo
Messages: 40
Registered: June 2007
Location: India

Member

Thanks for your prompt response

Report message to a moderator

Re: Database procedure or Forms procedure [message #257827 is a reply to message #257712]

Thu, 09 August 2007 05:09

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Well this depends on the event.

Report message to a moderator

Re: Database procedure or Forms procedure [message #258024 is a reply to message #257827]

Thu, 09 August 2007 18:47

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: Database procedure or Forms procedure [message #258094 is a reply to message #258024]

Fri, 10 August 2007 03:16

azamkhan
Messages: 557
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.

Report message to a moderator

Re: Database procedure or Forms procedure [message #258134 is a reply to message #258094]

Fri, 10 August 2007 06:28

Littlefoot
Messages: 21818
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.

Report message to a moderator

Re: Database procedure or Forms procedure [message #258310 is a reply to message #258134]

Fri, 10 August 2007 23:58

azamkhan
Messages: 557
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

Report message to a moderator

Re: Database procedure or Forms procedure [message #258502 is a reply to message #258310]

Sun, 12 August 2007 19:55

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: Database procedure or Forms procedure [message #258576 is a reply to message #258502]

Mon, 13 August 2007 01:56

azamkhan
Messages: 557
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.

Report message to a moderator

Re: Database procedure or Forms procedure [message #258590 is a reply to message #258502]

Mon, 13 August 2007 02:18

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

djmartin

Please note that the key word is 'FIRST' not 'FAST'.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 04:21:02 CDT 2024