Ora-06502: Oracle scripts and errors

When we are programming and we get an oracle error, we can capture this error in an exception block. Within this block, we could use the variable sqlerrm in order to know its description.
Here it is an example:
declare
tmp varchar2(10);
begin
tmp:=’aaaaaaaaaaaaaa’;
exception
when others then
dbms_output.put_line(sqlcode||’–>’||sqlerrm);
end;
In this example, we have forced an ora-06502 error and we have captured […]