Home » Developer & Programmer » Forms » Calling procedure from Forms is slow
Calling procedure from Forms is slow [message #198012] Fri, 13 October 2006 15:30 Go to next message
gkirsh
Messages: 2
Registered: October 2006
Location: New York
Junior Member
I have a packaged procedure which contains a merge statement. When I call it from a Forms trigger, it takes 2-3 times as long as when I call it from SQL*Navigator on my desktop. Anybody have any idea why calling a database procedure from Forms should be so much slower?

I'm using Forms 6.0.8.25.2 and db 9.2.0.6.0. The form is a custom Apps 11i form. I've tried rewriting the merge as update/insert, optimizer hints, using rule mode, no matter what I do, calling from Forms is always 2-3 times slower.

Thanks,
Gary

Gary Kirsh
Next Extent Consulting
Re: Calling procedure from Forms is slow [message #198169 is a reply to message #198012] Sun, 15 October 2006 23:38 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Could you post the code please? From which trigger did you call this code?

David
Re: Calling procedure from Forms is slow [message #198302 is a reply to message #198169] Mon, 16 October 2006 09:03 Go to previous messageGo to next message
gkirsh
Messages: 2
Registered: October 2006
Location: New York
Junior Member
David,

I have a when-button-pressed trigger, which calls a forms procedure, which calls a db procedure. The db procedure first had a merge statement, I changed it to a regular update and insert. It doesn't seem to matter what I do to the code, it is always much slower when I call it from Forms. I saw a couple of people complaining of the same problem on Metalink, but no answers!

Thanks,
Gary
Re: Calling procedure from Forms is slow [message #198596 is a reply to message #198302] Tue, 17 October 2006 21:28 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I repeat
Could you post the code please?
That would be the Form code, not the database code.

David
Previous Topic: ora 918 column ambiguously defined
Next Topic: "Start In" path for Builder / Runtime, need feedback ...
Goto Forum:
  


Current Time: Fri Dec 09 06:17:11 CST 2016

Total time taken to generate the page: 0.10093 seconds