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!

Report message to a moderator

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 !

Report message to a moderator

Previous Topic: create user
Next Topic: Re: package problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 20 21:12:26 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.