| Calling procedure from Forms is slow [message #198012] |
Fri, 13 October 2006 15:30  |
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 #198302 is a reply to message #198169] |
Mon, 16 October 2006 09:03  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
