Oracle Exceptions ??

Gurus,

Do you know if there is a way to make the Oracle driver more verbose on errors? Instead of saying "ORA-01722: invalid number", say "ORA-01722: invalid number: PHHCOMPRD.PHHCOM_RETAIL_INVENTORY.PONUM: value "'MyNameIsBillyBob'"

The simple answer is No.

You can achive in PL/SQL by defining your own excpetions as

Code:

---

declare
invalid_num exception;
pragma exception_init(invalid_num, -01722);
......
begin
  numvar := 'MyNameIsBillyBob';
exception
when invalid_num then
      dbms_output.put_line('ORA-01722: PL/SQL: invalid number: variable numvar');
end;

---

Code:

---

declare
invalid_num exception;
pragma exception_init(invalid_num, -01722);
......
begin
  numvar := 'MyNameIsBillyBob';
exception
when invalid_num then
      dbms_output.put_line('ORA-01722: PL/SQL: invalid number: variable '|| numvar);
end;

---

a slight correction