error: unable to issue savepoint command

[KULJEET]

when we attemp to call new form from d2k (developer 6)
then i received following error

frm-40512 oracle error unable to issue savepoint command.
i think it relates to init.ora setting.

but i don't know how to solve this problem.and what are the reason.
plz help me.
thanks

[Sybrand Bakker]

On 2 Jun 2003 04:34:49 -0700, kuljee...@hotmail.com (KULJEET)
wrote:

>frm-40512 oracle error unable to issue savepoint command.
>i think it relates to init.ora setting.

No, this remark is definitely bogus.
Please post the *complete* error stack

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

[KULJEET]

complete error is

FRM-40512: ORACLE error: unable to issue SAVEPOINT command.

u can see this error on developer help

[Vladimir M. Zakharychev]

"KULJEET" <kuljee...@hotmail.com> wrote in message
news:febbed51.03060...@posting.google.com...

> complete error is
>
> FRM-40512: ORACLE error: unable to issue SAVEPOINT command.
>
> u can see this error on developer help

So did you click on [Display Error] button? What did it show?

--
Vladimir Zakharychev (b...@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.

[KULJEET]

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.

[Vladimir M. Zakharychev]

"KULJEET" <kuljee...@hotmail.com> wrote in message
news:febbed51.03060...@posting.google.com...

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);

[KULJEET]

"Vladimir M. Zakharychev" <b...@dpsp-yes.com> wrote in message news:<bbk217$l11$1...@babylon.agtel.net>...

> "KULJEET" <kuljee...@hotmail.com> wrote in message
> news:febbed51.03060...@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.

[ricardo...@gbsys.com]

hi,

I have the same problem.
You are using the database in rac?