Hi DS Gurus,
Have written a routine to execute an update statement in Oracle 9i. SQLPlus utility is called from the routine and it looked the update command was successful when i execute the routine. When i checked the data, the data in the database not at all updated.
Is there any SQLPlus switch available to enable auto commit ON?
Can you someone enlighten me what is causing this issue.
Thanks in advance for your help.
Regards
Saravanan
Routine to execute Update statment
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Hi Sainath,
Thanks for your reply.
How do i set that autocommit is ON for that session? When i execute that statement from that routine that call is considered as a session, so autocommit is to be set to that particular session.
Pls let me know how to set that while running that update command.
Regards
Saravanan
Thanks for your reply.
How do i set that autocommit is ON for that session? When i execute that statement from that routine that call is considered as a session, so autocommit is to be set to that particular session.
Pls let me know how to set that while running that update command.
Regards
Saravanan
-
- Participant
- Posts: 57
- Joined: Wed Jan 26, 2005 10:22 pm
- Location: India
Try this SQL in your routine
Code: Select all
set autocommit on/off
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am