Reject on zero delete from Oracle enterprise stage
Posted: Wed Dec 07, 2011 8:03 am
HI ,
Iam looking for some explanation on the behaviour of Oracle enterprise stage .
Iam issuing a delete command to the oracle stage and i also have a reject link out from the oracle stage. When there are no delete happening, the oracle returns - No records or zero records deleted. It is not considered to be a failure. But the oracle stage captures those records which did nto find any matchinig key in the table and passes them through the Reject link.
IS this a known behaviour??
What should i do to make the oracle enterprise stage to consider the zero records deleted reply from the database to consider as success and not as failure.
Any comments / Help is much appreciated.
Thanks Very much
Kamesh
Iam looking for some explanation on the behaviour of Oracle enterprise stage .
Iam issuing a delete command to the oracle stage and i also have a reject link out from the oracle stage. When there are no delete happening, the oracle returns - No records or zero records deleted. It is not considered to be a failure. But the oracle stage captures those records which did nto find any matchinig key in the table and passes them through the Reject link.
IS this a known behaviour??
What should i do to make the oracle enterprise stage to consider the zero records deleted reply from the database to consider as success and not as failure.
Any comments / Help is much appreciated.
Thanks Very much
Kamesh