AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Oracle JDBC problem with ARRAY          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message Wolfgang Ott Guest Posted: Tue May 17, 2005 8:42 am    Post subject: Oracle JDBC problem with ARRAY Hi. I've got an Oracle stored procedure with an 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? Back to top Bjorn Abelli Guest Posted: Tue May 17, 2005 12:40 pm    Post subject: Re: Oracle JDBC problem with ARRAY "Wolfgang Ott" wrote... Quote: Hi. I've got an Oracle stored procedure with an 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? The name of the defined array must be in all upper-case letters. If "my_schema" is the default schema from your connection, I'd suggest that you simply drop the schema-name: cs.registerOutParameter(1, Types.ARRAY, "MY_ARRAY_TYPE"); // Bjorn A Back to top Wolfgang Ott Guest Posted: Tue May 17, 2005 5:09 pm    Post subject: Re: Oracle JDBC problem with ARRAY Hi Bjorn, it works now. The point is, that the schema name (and the type name) has to be written in capital letters, and it must be the schema of the owner of the type. Wolfgang "Bjorn Abelli" <bjorn_abelli (AT) DoNotSpam (DOT) hotmail.com> schrieb im Newsbeitrag news:4289e5cd_1 (AT) x-privat (DOT) org... Quote: "Wolfgang Ott" wrote... Hi. I've got an Oracle stored procedure with an 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? The name of the defined array must be in all upper-case letters. If "my_schema" is the default schema from your connection, I'd suggest that you simply drop the schema-name: cs.registerOutParameter(1, Types.ARRAY, "MY_ARRAY_TYPE"); // Bjorn A Back to top Angus Guest Posted: Wed May 18, 2005 2:47 am    Post subject: Re: Oracle JDBC problem with ARRAY Wolfgang Ott wrote: Quote: Hi Bjorn, it works now. The point is, that the schema name (and the type name) has to be written in capital letters, and it must be the schema of the owner of the type. Wolfgang "Bjorn Abelli" <bjorn_abelli (AT) DoNotSpam (DOT) hotmail.com> schrieb im Newsbeitrag news:4289e5cd_1 (AT) x-privat (DOT) org... "Wolfgang Ott" wrote... Hi. I've got an Oracle stored procedure with an 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? The name of the defined array must be in all upper-case letters. If "my_schema" is the default schema from your connection, I'd suggest that you simply drop the schema-name: cs.registerOutParameter(1, Types.ARRAY, "MY_ARRAY_TYPE"); // Bjorn A Wolfgang, Top-posting and multi-posting. Two things that are frowned upon. I answered this same question you posted to "comp.databases.oracle.misc". Have you seen the following Web pages? http://smjg.port5.com/miniencs/misusenet.html http://catb.org/~esr/faqs/smart-questions.html Good Luck, Avi. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.