We need to dynamically set autocommit on and off from our application program. We are trying to write a small procedure to set it on and off.

Within the procedure, if I put SET AUTOCOMMIT ON, it is giving error.

Do I need to do some setting to avoid this error?