Hi,
Thank you for your reply. One more question,
When a define schema execption was throwed, will the transaction be switch back to auto commit mode, or you should care to switch back by writing the roll back code.
I think, if you are in local transaction mode and get an exception, you should end the transaction with rollback.