Oracle ora-01722 invalid number where clause in update statement. I want to log this error in error log table. How can i log?? Below is my Update statement, here empid is number.
UPDATE SARVESH_TEST_ERR_TB SET empid = empid WHERE empid ='aaa' LOG ERRORS INTO SARVESH_ERR_LOGS_TB ('Error while UPDATE') REJECT LIMIT UNLIMITED;
If we gibe set empid = 'abc' where empid =105 , this error is logging in error log table. But if i am giving a string in where clause it is not logging,
Software/Hardware used: SOftware
Ask a Question
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!