SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rollbacking DDL

Vikas KumarJun 3 2008 — edited Jun 3 2008

Hi

I have a stored procedure which creates DB users and assigns DB roles to users.
i want that if at anytime error occurs then my work is rollbacked. i haven't heard of rollbacking DDL statements, is there a way to rollback DDL in a procedure ?

Regards,
Vikas Kumar

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 1 2008

Added on Jun 3 2008

17 comments

743 views