Topic: How to learn the present error in stored procedure at start?
Core-was of type:
create or replace mysp (a number, b varchar2) is begin insert into sometable (a, b) values (mysp.a, mysp.b); end;
Then a certain villain changed table structure sometable and now for a command:
$dbh-> do ("execute mysp (1, ' a ')");
DBD:: Oracle:: db do failed: ORA-00900: invalid SQL statement (DBD ERROR: OCIStmtExecute) [for Statement "execute mysp (1, ' a ')"] at mysript.pl
And here if to come in SQL Developer and launches procedure recompilation already we receive the correct errors (a column it is not found, the type does not coincide both and ).
It is asked, it is possible-whether to receive at once at start code of the present errors instead of the general ORA-00900? Or the presents are accessible only at recompilation?