Hi Gurus

To use the perticular roll back segment for the current session, In sql script we can use the 'set transaction use rollback segement' putting at very first line of the script. Could we put it in Pl/SQL. Block. We have tried it but could not get success.

Any suggesions or solutions ? will be appreciated.

Thanks in Advance


V M A




DISCLAIMER:
This message,including any attachments contains confidential and privileged information for the sole use of the intended recipient(s), and is protected by law. If you are not the intended recipient, please destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful.
Bajaj Auto reserves the right to record, monitor, and inspect all email communications through its internal and external networks. Your messages shall be subject to such lawful supervision as Bajaj Auto deems necessary in order to protect its information, interests and reputation. Bajaj Auto prohibits and takes steps to prevent its information systems from being used to view, store or forward offensive or discriminatory material. If this message contains such material, please report it to [Email address protected]

Oracle LazyDBA home page