savepoint command

[lemmor]

Hello everybody !!!

Can anybody tell me on how to solve a savepoint command error. This happens when i save a record into the form.

Thank you very much

 

[sem]

Could you be more specific? Error code or more detailed text?

 

[lemmor]

The oracle error is Frm:40512 "Unable to issue savepoint command". This error usually happens after saving the 3rd record into the form.

Thanks

 

[sem]

If you work on Oracle 7.3 (directly or via db_link) - try to increase the SAVEPOINTS parameter in the init.ora file.

 

[oracle8]

I'm using ORACLE 8.05, what is the syntax in adding SAVEPOINTS parameter in the init.ora file.

 

[sem]

SAVEPOINTS is not longer used on 7.3+, so the problem is probably in something else. Try to get full message with display_error.

 

[oracle8]

thanks sem

 

[tirumal]

I am using Oracle 8.0.5. Can i know what is the Disconnection time for a user