set transaction read only;
select * from aa where name='aaa';
commit;
以上命令执行成功,但不知为什么以下这句就不能执行
set transaction;
insert into aa values('bbb','ccc');
commit;
错误提示:执行set transaction时说是,无效sql语句.
请问那位高手知道请指教,多谢!!!!!!!!
...全文
524打赏收藏
部分oracle事务处理总是提示错误
set transaction read only; select * from aa where name='aaa'; commit; 以上命令执行成功,但不知为什么以下这句就不能执行 set transaction; insert into aa values('bbb','ccc'); commit; 错误提示:执行set transaction时说是,无效sql语句. 请问那位高手知道请指教,多谢!!!!!!!!
12:08:23 jlanzpa817>insert into aa values('bbb','ccc');
insert into aa values('bbb','ccc')
*
ERROR 位于第 1 行:
ORA-01456: 不可以在 READ ONLY 事务处理中执行插入/删除/更新操作
Transaction control statements manage the
changes made by the DML statements,
whether to save them or discard them. The
COMMIT, ROLLBACK, SAVEPOINT, and SET
TRANSACTION commands are all transaction
control statements.
set transaction加条件