Home » RDBMS Server » Server Utilities » AutoCommit after DBMS_DATAPUMP.open (Oracle Database 10g Release - Production)
AutoCommit after DBMS_DATAPUMP.open [message #354315] Fri, 17 October 2008 11:26
Messages: 1
Registered: October 2008
Junior Member
Hi, is there any way to avoid autocommit after DBMS_DATAPUMP.open? I want to rollback changes if export fails, but after DBMS_DATAPUMP.open (even if export fails) changes are commited...

plsql code:

INSERT INTO courier(courier_id, fname) VALUES (1001, 'myname');

v_handle := DBMS_DATAPUMP.open(
operation => 'EXPORT',
job_mode => 'TABLE',
remote_link => NULL,
job_name => v_jobname,
version => 'COMPATIBLE');

This is not the code i am using, just easiest way to invoke the problem.

Previous Topic: SQLLoader Unicode from Unix enviroment
Next Topic: Moving 10g to 9i
Goto Forum:

Current Time: Mon May 22 14:32:32 CDT 2017

Total time taken to generate the page: 0.13653 seconds