Skip to main content
Solved

Oracle errors

  • January 29, 2025
  • 3 replies
  • 49 views

Forum|alt.badge.img+7

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).

Best answer by madhu subbegowda

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.

3 replies

madhu subbegowda
Most Valuable Pathfinder
Forum|alt.badge.img+12
  • Most Valuable Pathfinder
  • January 29, 2025

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


Forum|alt.badge.img+17
  • Most Valuable Pathfinder
  • January 29, 2025

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


madhu subbegowda
Most Valuable Pathfinder
Forum|alt.badge.img+12
  • Most Valuable Pathfinder
  • Answer
  • January 29, 2025

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.