File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Nested table output is coming as Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Nested table output is coming as "???" in Java" Watch "Nested table output is coming as "???" in Java" New topic
Author

Nested table output is coming as "???" in Java

nedumangad chandra
Greenhorn

Joined: Dec 09, 2009
Posts: 4
Hi,
I am having a procedure which outputs one nested table having some varchar data.I can access that "String" values from java using the code (this is not full code..only part of it)

This code works perfectly in "Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Prod"
But when I connected to a different database(database objects are same),but version is different.i.e,
"Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod"...I am getting "???" as string values.
Why these question marks are coming instead of proper string values.Please help...
Tim McGuire
Ranch Hand

Joined: Apr 30, 2003
Posts: 820

Can you post more of your code?
nedumangad chandra
Greenhorn

Joined: Dec 09, 2009
Posts: 4
Tim McGuire wrote:Can you post more of your code?

I am getting connection using the code below

the database credentials are set in the server.xml in my tomcat server.I have installed the client oracle version in my system.But what is the significance of that info ? I can get string values in proper format in my Toad .
I am taking the nested table values using java.sql.SQLData.Please see the code below.

argZero.readString() is giving "???".Please reply.
Deepak Bala
Bartender

Joined: Feb 24, 2006
Posts: 6657
    
    5

What is the charset that the DB uses ?


SCJP 6 articles - SCJP 5/6 mock exams - More SCJP Mocks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Nested table output is coming as "???" in Java
 
Similar Threads
JDBC call to PLSQL block having Oracle type object parameter
Reading data from database table that contains control characters.
SQLXML type
XMLType usage
Error when calling stored function using xml table in oracle