Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle JDBC problem

Oracle JDBC problem

From: Wolfgang Ott <guckma_at_arcor.de>
Date: Tue, 17 May 2005 13:29:00 +0200
Message-ID: <4289d57d$0$14737$9b4e6d93@newsread4.arcor-online.net>


Hi. I've got an Oracle stored procedure with a user defined output parameter my_array_type: describe my_array_type;
  my_array_type TABLE OF VARCHAR2(30)
I want to call the procedure with JDBC.
I register the output parameter with
cs.registerOutParameter(1, Types.ARRAY, "my_schema.MY_ARRAY_TYPE"); Then I get the error
"java.sql.SQLException: Ungültiges Namensmuster". ("illegal name pattern", I don't know the exact text in english.) What can be wrong here? Received on Tue May 17 2005 - 06:29:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US