Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

PLS-00324: cursor attribute may not be applied to non-cursor 'string'

1 Answers  


ORA-38955: Source platform string not cross platform compliant

1 Answers  


ORA-35076: (QFHEAD04) CAUTION: The textual data in EIF file string is encoded in a character set that is not recognized by this version of string.

1 Answers  


ORA-14286: cannot COALESCE the only subpartition of this table partition

1 Answers  


PCB-00205: Cannot use PIC N or PIC G variable in PL/SQL when NLS_LOCAL=YES

1 Answers  






ORA-01219: database not open: queries allowed on fixed tables/views only

1 Answers  


ORA-04032: pga_aggregate_target must be set before switching to auto mode

1 Answers  


IMP-00069: Could not convert to environment national character set's handle

1 Answers  


ORA-07708: sksaprs: tape label name buffer too small

1 Answers  


DRG-10845: column string is not indexed

1 Answers  


How to Select 38th row details in table without using rownum ?

12 Answers   ProKarma, Sapient, Wipro,


ORA-28119: policy group does not exist

1 Answers  






Categories