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

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

Question Posted / guest

1 Answers
4087 Views
I also Faced
E-Mail Answers

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

DRG-51203: found doc ids without mappings during get maps

1 Answers

ORA-28022: cannot grant external roles to global user or role

1 Answers

ORA-01228: SET DATABASE option required to install seed database

1 Answers

ORA-07645: sszfsl: $CHANGE_CLASS failure

1 Answers

ORA-31075: invalid string declaration in XML Schema

1 Answers

ORA-07618: $IDTOASC failed translating a secrecy level

1 Answers

NZE-29159: Unable to read library.

1 Answers

ORA-01325: archive log mode must be enabled to build into the logstream

1 Answers

ORA-21301: not initialized in object mode

1 Answers

NZE-28845: No certificate

1 Answers

ORA-12589: TNS:connection not bequeathable

1 Answers

ORA-36200: (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.

1 Answers

For more Oracle Errors Interview Questions Click Here