OraFAQ Forum: Server Utilities » AutoCommit after DBMS

Home » RDBMS Server » Server Utilities » AutoCommit after DBMS_DATAPUMP.open (Oracle Database 10g Release 10.2.0.1.0 - Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

AutoCommit after DBMS_DATAPUMP.open [message #354315]

Fri, 17 October 2008 11:26

ondrag
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');

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 07 05:27:21 CDT 2024