Re: error: unable to issue savepoint command

[Quoted] "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);

-- 
Vladimir Zakharychev (bob_at_dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.