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'"
Printable View
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