"OCI no data" in OracleException.Message when procedure raises "no_data_found" exception

"OCI no data" in OracleException.Message when procedure raises "no_data_found" exception

Postby Denis » 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;
Denis
 
Posts: 3
Joined: Thu 19 Apr 2007 04:26

Postby Alexey » Thu 19 Jul 2007 12:03

We are investigating this behaviour.
You will be notified on results as soon as possible.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Alexey » Tue 24 Jul 2007 07:26

Oracle returns different errors in these two cases.
We will try to return same messages.
Look forward to the next build.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle