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

> Well the first thing I'd suggest is patch to 8.1.7.4.
>
> Then I'd suggest trying the exact same transaction using SQL*Plus and
> see if it is similarly slow.
>
> Are all forms slow or just one? In general I would expect sub-second saves.
> --
> Daniel A. Morgan
> University of Washington
> damorgan@x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org