1. Categories >> ERRORS >> Database Errors >> Oracle Errors
  2. Suggest New Category

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

Question Posted / guest


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

ORA-25020: renaming system triggers is not allowed

1 Answers  

CLSR-00527: OCR operation failed

1 Answers  

ORA-12720: operation requires database is in EXCLUSIVE mode

1 Answers  

ORA-25257: consumer must be specified with a multi-consumer queue

1 Answers  

CLSR-01010: Unable to record PMON pid to string

1 Answers  




ORA-25153: Temporary Tablespace is Empty

1 Answers  

PLS-00960: RPCs cannot use variables with schema level user-defined types in this release

1 Answers  

ORA-38434: could not evaluate expression "string"

1 Answers  

DRG-11614: URL store: communication with host specified in string timed out

1 Answers  

TNS-00224: No more connections available

1 Answers  

KUP-03018: invalid date mask "string" specified for column string

1 Answers  

ORA-30357: this PL/SQL function cannot be supported for query rewrite

1 Answers  

For more Oracle Errors Interview Questions Click Here
Categories