• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Paul Clapham
  • Jeanne Boyarsky
Sheriffs:
  • Ron McLeod
  • Frank Carver
  • Junilu Lacar
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • fred rosenberger

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

 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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...
 
Ranch Hand
Posts: 820
IntelliJ IDE VI Editor Tomcat Server
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Can you post more of your code?
 
nedumangad chandra
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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.
 
Bartender
Posts: 6663
5
MyEclipse IDE Firefox Browser Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is the charset that the DB uses ?
 
If you settle for what they are giving you, you deserve what you get. Fight for this tiny ad!
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic