"OCI no data" in OracleException.Message when procedure raises "no_data_found" exception
Posted: Thu 19 Jul 2007 11:23
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;
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;