Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2007
    Posts
    17

    Exclamation Unanswered: returning oracle ref cursor to java

    Hi,
    I'm returning a ref cursor as an out parameter of my procedure. When I try to capture the ref cursor through java I get a DB Exception:

    java.sql.SQLException: ORA-03115: unsupported network datatype or representation

    The proc works fine when I execute it through SQLPLUS.

    Any idea how I should rectify this??


    Thanks...

    -Sajita

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    This is what Oracle says about it:
    ORA-03115 unsupported network datatype or representation


    Cause: A user bind or define, or an Oracle function, is not supported by this heterogeneous Net8 connection.

    Action: Upgrade the older version of Oracle and try again.

  3. #3
    Join Date
    Jun 2007
    Posts
    17
    Thanks...
    I figured that out myself...
    My question was how to rectify it... thanks anywayz for the effort...

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    How to upgrade? Insert-a-CD-and-double-click-setup.exe ... or one of its variations. How to obtain a new version? Contact your Oracle Sales Representative. Patches are available at Metalink (if you find out that this might help). I, honestly, wouldn't know what to do as you didn't post your Oracle version.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    My guess/suggestion is to consider upgrading the Java; since it works in SQL*Plus.

    What kind of Connection (JDBC thin?) is Java making into the DB?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Jun 2007
    Posts
    17

    Smile

    Quote Originally Posted by anacedent
    My guess/suggestion is to consider upgrading the Java; since it works in SQL*Plus.

    What kind of Connection (JDBC thin?) is Java making into the DB?

    Thanks... upgraded the JAR files and it worked...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •