Re: error: unable to issue savepoint command

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:<bbk217$l11$1_at_babylon.agtel.net>...
> "KULJEET" <kuljeet_twtpl_at_hotmail.com> wrote in message
> news:febbed51.0306032033.3b447df5_at_posting.google.com...
> > Cause: While attempting to call a new form or to commit, the issued
> > SAVEPOINT command failed. This generally means that the module has
> > run out of savepoints.
> >
> > You might be able to increase the maximum number of savepoints in the
> > INIT.ORA file.
> > i don't know how to perform this task.
> > i am using oracle personal edition.
> > but in init.ora file
> > we can't see any entry for savepoints.
> > so how we can increase it.
> > and i don't know what are max no for savepoints
> > and how they will work and effect oracle performance.
>
> You can't do that since Oracle7 - there's no init.ora parameters controlling
> savepoints since this release. This error message is a bit misguiding - you
> need to check error details (with Next, SHOW ERROR or anything like that)
> and look for ORA- error code(s), then fix those errors. You may need to
> switch off savepoint mode for your form with a code like this:
>
> Set_Form_Property(form_id, SAVEPOINT_MODE, PROPERTY_FALSE);

thanks a lot for your help
i am using forms on web environment
so this problem occurs very few times.
i will follow your instruction.
if i will find any problem then i will reply you.

thanks. Received on Wed Jun 04 2003 - 13:22:02 CEST