SQLJ - no error codes.....

From: Steve Haynes <steve_at_rwx777.demon.co.uk>
Date: Tue, 22 Aug 2000 22:36:02 +0100
Message-ID: <1Bya9IACJvo5EwLj_at_rwx777.demon.co.uk>


Hi All,

re: Jdeveloper 3.1 and 8.1.6.0.0
(loadjava classes and create PL/SQL wrapper functions)

Anyone else had a problem with SQLException where, for example, you should get too_many_rows but in your catch SQLException, the error code is always zero?
This seems to have oracle baffled - they have reproduced it.

Also, anyone know how to get println output to work when the class is invoked through a PL/SQL wrapper? I've set serveroutput on and called dbms_java.enable_output(x) -
(I forget the exact function name to do that, now at home).

[Quoted] Also, if I have a variable of type oracle.sql.CHAR, how do I compare it, if equal "Y". I tried getString().

Thanks,
Steve Received on Tue Aug 22 2000 - 23:36:02 CEST

Original text of this message