| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
