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

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Denis
Posts: 3
Joined: Thu 19 Apr 2007 04:26

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

Post by 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;

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by 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

Post by 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.

Post Reply