ORA-12831: Must COMMIT or ROLLBACK after executing INSERT
with APPEND hint



ORA-12831: Must COMMIT or ROLLBACK after executing INSERT with APPEND hint..

Answer / guest

Cause: After executing an INSERT statement with an APPEND
hint, a command other than COMMIT or ROLLBACK was issued.

Action: Execute COMMIT or ROLLBACK before issuing another
SQL command.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

IMG-00002: unrecoverable error

1 Answers  


LPX-00227: entity "~S" is not a parsed entity

1 Answers  


QSM-02146: see the reason why REFRESH_FAST_AFTER_INSERT is disabled

1 Answers  


NNO-00627: cancelling auto-refresh of name "string", type "string"

1 Answers  


ORA-26011: Cannot load type string into column string in table string

1 Answers  






ORA-06140: NETTCP: no such user

1 Answers  


ORA-16205: DDL skipped due to skip setting

1 Answers  


ORA-24399: invalid number of connections specified

1 Answers  


PLS-01400: Use of '||' token

1 Answers  


ORA-15011: failure group "string" contains no members

1 Answers  


ORA-01307: no LogMiner session is currently active

1 Answers  


ORA-06523: Maximum number of arguments exceeded

1 Answers  


Categories