no error trapping

[vwilhelm]

Hi all,

I have propably found a critical bug in DOA 4.0.7.1 in conjunction with
the oracle standard client 9.2.0.1

I have an Oracle Database Version 9.2.0.6 with an oracle client V. 9.2.0.1
For test purpose I have build a package-function which will always force
an oracle exception ORA-01422.

When I execute the function within a procedure plsql context the error is
reported:

begin
declare x number;
begin
select errortest.error('123') into x from dual;
end;
end;

ORA-01422: exact fetch returns more than requested number of rows

If executed from within a functional context, no error is reported and
the resultset is empty.

select errortest.error('1234') from dual;

The same effect occurs with the doa-based Software TOAD from Quest-Software,
the Trial-Version of PLSQL-Developer from Allroundautomations is behaving the same.

Executed within SQLPlus the error is reported correctly.
Within Netbeans the same statement is executed with the oracle jdbc driver
the error is also reported correctly.

Further tests have shown that this issue doesn't effect the newest oracle client
9.2.0.8

Is something going wrong with the error trapping of the DOA components?
Is this a configuration issue or a client bug ?

Volker Wilhelm
Compu-Orga GmbH

 

[Marco Kalter]

This sounds like an Oracle bug. Did you imply that this problem does not occur on a 9.2.0.8 client?

 

[vwilhelm]

Hi Marco,

With the 9.2.0.8 client the error is trapped correctly. It isn't a simple client error, because I have made a test with Oracle's SQLPLUS on a 9.2.0.1 client, everything ok, the error is reported correctly. It's the combination of 9.2.0.1 and DOA.

This is a very critical error!

 

[vwilhelm]

Hi,

any news on the bug concerning the error trapping?

Could you reproduce the effect or do you need additional information?

Greetings
Volker Wilhelm
Compu-Orga GmbH

 

[Marco Kalter]

No, I cannot reproduce it, and it's not a problem that has been reported before on any Oracle Client version.