Re: commit inside a cursor oper

From: Ashok Kapur <akapur_at_thomtech.com>
Date: 1995/08/25
Message-ID: <41l295$bku_at_ttis.thomtech.com>#1/1

A COMMIT releases all locks and resets all the rollback segment. You do not want to perform COMMITs when any cursors are open. It may work for a while, but will give you problems later on( Problems like ORA-1555 error!!). Oracle has a bulletin regarding this. You may be able to request them to send you a copy. Ask for the bulletin on ORA-1555.

Ashok Kapur
akapur_at_thomtech.com Received on Fri Aug 25 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Contractor - Yuk Hon : "Re: redo log sequence"
Previous message: Thomas M. Buccelli: "Re: commit inside a cursor oper"
Maybe in reply to: Saad Ahmad: "commit inside a cursor oper"
Next in thread: Contractor - Yuk Hon : "Re: redo log sequence"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message