Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why are database errors reported as warnings? When I use the Oracle online checker, why do I get one error and one additional warning from the database?

April 26, 2017additional checker database Error errors online Oracle reported warning warnings

0

10 Posted

Why are database errors reported as warnings? When I use the Oracle online checker, why do I get one error and one additional warning from the database?

1 Answer

0

10 Posted

Errors reported by the database are passed on as warnings by SQLJ. This is because the database reporting may not be fully accurate, resulting in spurious errors. The signature of stored functions and procedures is analyzed directly from the SQLJ client. But these function and procedure invocations are also passed to the database for explicit analysis. This results in duplicate reporting of certain errors or warnings concerning stored procedures and functions.