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
4008 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

SQL*Loader-00430: NULL nested table element is not allowed

1 Answers

ORA-25010: Invalid nested table column name in nested table clause

1 Answers

ORA-36696: (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation.

1 Answers

RMAN-04001: heap initialization failure

1 Answers

ORA-12725: unmatched parentheses in regular expression

1 Answers

ORA-16781: The status of log transport service for some database is unknown

1 Answers

KUP-03011: OCI error getting database column size.

1 Answers

DRG-12201: section group string already exists

1 Answers

ORA-29824: operator is invalid

1 Answers

ORA-03202: the scan limit specification is invalid

1 Answers

PLS-00626: partitioned/clustered/ordered parameter must be a function argument

1 Answers

IMG-00707: unable to access image data

1 Answers

For more Oracle Errors Interview Questions Click Here