Skip to main content

Is there a way to capture oracle errors? I am inserting records into a table and it fails part way through. I am assuming its a data issue but there is nothing to help diagnose the error (like a numeric value error message for example).

Hey, I'm using this and I know what it is. Connect with me on Madhu.subbegowda@owens-minor.com.  I can explain what is causing the issue


@madhu subbegowda Why would you not answer the question here on the forum, for the benefit of the next person searching on this issue?


There are ASCII special characters that are preventing you from proceeding. You need to use regex or develop a separate solution, but regex is the better approach. You should identify potential hidden elements and build logic accordingly. I implemented this based on my real use case and achieved success.

 

It's entirely up to you how you choose to proceed. I extended my help by even sharing my personal contact, hoping it would be useful. If you prefer, I can share insights here, but I can’t detail every single event over chat. I genuinely thought I could assist with your problem, but at the end of the day, it’s your call.


Reply