Experts,
I am working on Oracle 11.2.0.2.I have created a Procedure and log table for a batch process. Once the batch process started then it should update the log table with status as "P" ( means Processing), if completed successfully it should update the status as "C" if the process failed then update the status as "F". But it's not updating the status as "F". Please find the attached Procedure and the Table structure and how its getting loaded ( have given few rows of Data) and have given the code( how am testing). Can you please have a look and help to resolve the issue.
Thanks
Amy
SRC_CD.txt (13.11 KB)