[JDBC] How to Register Stored Procedure Out Parameter for ArrayType

From: Chin Hsu <chinhsu_at_at_remove_this_t.com>
Date: Wed, 18 Sep 2002 18:26:43 -0400
Message-ID: <amasnp$s4a6@kcweb01.netnews.att.com>

My configuration is Oracle 9i database server and Oracle JDBC driver that comes with it.

I am trying to register out parameter for a stored procedure defined as follow:

PACKAGE for_my_test AS

       TYPE MyRec IS RECORD (
           ckt   circuit.cktid%TYPE,
           telephone   circuit.telephone%TYPE
       );
       TYPE CktList IS TABLE OF MyRec;

       PROCEDURE getCkt(alist out CktList);
       PROCEDURE mytest;

END for_my_test;

my java code is as follow:

...

stmt.registerOutParameter(i+1, java.sql.Types.ARRAY, "for_my_test.CktList");

...

But the jdbc driver is complaining about the invalid name pattern (see output below). Does anyone know what the valid name pattern should be?

the output:
[java] syntax = {CALL for_my_test.getCkt( ?) }

[java] com.att.dqis.exception.DqisException: Database error
java.sql.SQLException: invalid name pattern: for_my_test.CktList

[java] at StoredProcDAO.execute(StoredProcDAO.java:107)

[java] at TestList.process(TestList.java:34)

[java] at Test.main(Test.java:28)
Received on Wed Sep 18 2002 - 17:26:43 CDT