Two Laptop Bag*
The moose likes JDBC and the fly likes Problem with stored procedure table parameter Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem with stored procedure table parameter" Watch "Problem with stored procedure table parameter" New topic
Author

Problem with stored procedure table parameter

Rafal Mrozik
Greenhorn

Joined: Jan 24, 2008
Posts: 10
Hello, I have the problem with stored procedure with paramater which is table type.

I have defined my own type


and i have stored procedure like this



Now...

When I run this class on my local machine the result is OK nad looks like
1: 'ONE'
2: 'TWO'
3: 'THREE'

But when I copy this class on the server and run it, the result is wrong
1: '???'
2: '???'
3: '???'

Here is my environment:

on local machine
eclipse 3.3.1
java 1.5 (java version compiler in eclipse is 1.4)

on server (WAS 5)
oracle 9.2.0.6.0
java 1.4.2_08

Result from table parameters are always 3 question marks :|
What is the problem?
Rafal Mrozik
Greenhorn

Joined: Jan 24, 2008
Posts: 10
Hmm I think i found the solution: nls_charset12.jar from page
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc9201.html
I have copied this jar to WAS lib directory and it works fine
Raghavan Muthu
Ranch Hand

Joined: Apr 20, 2006
Posts: 3344

Thats great Rafal Mrozik. :thumb:

Welcome to JavaRanch


Everything has got its own deadline including one's EGO!
[CodeBarn] [Java Concepts-easily] [Corey's articles] [SCJP-SUN] [Servlet Examples] [Java Beginners FAQ] [Sun-Java Tutorials] [Java Coding Guidelines]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem with stored procedure table parameter
 
Similar Threads
Complex data object returned from oracle
Passing array of Oracle colection objects from java to PL SQL
Passing NULL to the database
COBOL-DB2 SQLCODE handling vs Java Query
PL/SQL and JDBC