Home -> Usenet -> comp.databases.oracle -> [JDBC] How to Register Stored Procedure Out Parameter for Array Type

[JDBC] How to Register Stored Procedure Out Parameter for Array Type

From: Chin Hsu <chinhsu_at_at_remove_this_t.com>
Date: Wed, 18 Sep 2002 18:49:24 -0400
Message-ID: <amau2a$rqi6_at_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] Exception: 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 Thu Sep 19 2002 - 00:49:24 CEST












Original text of this message