Procedure Text with error "OCI no data" instead of "ORA-01422: exact fetch ...":
procedure Bad_Exec
is
pId NUMBER(16,0);
begin
Select 1 into pId from all_tables t where t.table_name = 'SSS';
end Bad_Exec;
Procedure Text with normal exception text:
procedure Bad_Exec
is
pId NUMBER(16,0);
begin
Select 1 into pId from all_tables t;
end Bad_Exec;