aspose file tools
The moose likes JDBC and Relational Databases 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 Badass: Making Users Awesome this week in the Game Development forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 3370

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