Backup procedure does not stop when stop_job is called
Hi,
I am using datapump to perform the backup of some tables. One of the requirements of the clients, is to know if the backup process ended succesfully, with warnings, or with an error. I have no problems getting the backup process to end succesfully, and to generate a correct backup file.
The problem that I am facing, is that for some reason, when I call dbms_datapump.stop_job while the backup process is happening(to test if the function returns a warning), the function does not return the correct error code, because it basically never finishes(in my sql developer it appears to be running..and in order to stop it I have to press the "Cancel task" button). And I can't seem to figure out why...I want to mention that the backup job is indeed stopped (I check that using select * from dba_datapump_jobs)
I am using datapump to perform the backup of some tables. One of the requirements of the clients, is to know if the backup process ended succesfully, with warnings, or with an error. I have no problems getting the backup process to end succesfully, and to generate a correct backup file.
The problem that I am facing, is that for some reason, when I call dbms_datapump.stop_job while the backup process is happening(to test if the function returns a warning), the function does not return the correct error code, because it basically never finishes(in my sql developer it appears to be running..and in order to stop it I have to press the "Cancel task" button). And I can't seem to figure out why...I want to mention that the backup job is indeed stopped (I check that using select * from dba_datapump_jobs)
0