Home » SQL & PL/SQL » SQL & PL/SQL » use DCL commands in pl/sql
use DCL commands in pl/sql [message #36940] Sat, 05 January 2002 16:43 Go to next message
shanfei
Messages: 1
Registered: January 2002
Junior Member
How can I use DCL commands in pl/sql
thanks!
Re: use DCL commands in pl/sql [message #36947 is a reply to message #36940] Mon, 07 January 2002 03:55 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
Be careful , you can't use DCL commands in PL/SQL if you are using MTS(Microst Transaction procedure ) else you can use it as per your requirement . like if you need to commit only if all the commads execute successsfully else rollback ..
got it !
Previous Topic: create user
Next Topic: Re: package problem
Goto Forum:
  


Current Time: Tue Aug 11 11:18:51 CDT 2020