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

ORA-00724: ALTER DATABASE CONVERT command has been de-supported

1 Answers

ORA-10616: Operation not allowed on this tablespace

1 Answers

ORA-30935: XML maxoccurs value (string) exceeded

1 Answers

DRG-10761: procedure string does not exist

1 Answers

ORA-26705: cannot downgrade capture process after Streams data dictionary has been upgraded

1 Answers

DRG-10703: invalid framework object string

1 Answers

ORA-19758: failed to enable/disable block change tracking: out of SGA memory

1 Answers

ORA-13141: invalid RANGE window definition

1 Answers

ORA-00343: too many errors, log member closed

1 Answers

ORA-08193: Flashback Table operation is not allowed on temporary tables

1 Answers

ORA-30765: cannot modify scope for an unscoped REF column

1 Answers

DGM-16911: Warning:

1 Answers

For more Oracle Errors Interview Questions Click Here