How to bind a Java type to an OUT parameter of a stored procedure with user-defined type?

From: g.s. <gshi_at_utilicorp.com>
Date: Fri, 21 Dec 2001 09:57:48 -0700
Message-ID: <3C236A0C.6C1A892B_at_utilicorp.com>

Hi, All:

Could you give me any hints on this:

If the OUT parameter is defined in a stored procedure as a composite type,
for instance,

           TYPE TRETURNCODE IS TABLE OF NUMBER(1)
          INDEX BY BINARY_INTEGER;

which is not a SQL primitive type, how to specify the second parameter in
Java side for registerOutParameters(1, ?);

For the second parameter, I have tried:

Types.OTHER,
Types.ARRAY,
Types.STRUT.

None of them worked. Runtime errors are like this java.sql.SQLException: Parameter Type Conflict: sqlType=2003

Thanks! Received on Fri Dec 21 2001 - 17:57:48 CET