Raj wrote:
> Hello Daniel,
>
> I will apply the patch as suggested by you.
>
> When I execute the query (transaction) with sqlplus it is very fast but
> with forms it is very slow.
>
> Any pointers ??
>
> Thanks, Rajeev

First pointer is don't top post. Scroll to the bottom before replying.

Given that it is a Forms issue and not a database issue which version of
Forms? Running client-server or in a web browser? Which one?

Are all forms slow or just this one?

Are all actions in this form slow or just this one?

Which triggers are fired when you take the slow action?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org