• 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
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

OUT as Table in StoreProcedure

 
Ranch Hand
Posts: 57
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I have an oracle store procedure which return TABLE RECORD
here is procedure



I want to know how to read OUT of above procedure.

Thanks


 
Bartender
Posts: 2662
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Do you want to know how to read this OUT parameter in Java, with JDBC?
 
Prashant Saraf
Ranch Hand
Posts: 57
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Jan Cumps wrote:Do you want to know how to read this OUT parameter in Java, with JDBC?



I do know how to read OUT for Procedure. I want to know how to read the OUT of RECORD TABLE type?
 
Prashant Saraf
Ranch Hand
Posts: 57
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Jan Cumps wrote:Prashant,

my excuses, but I still don't understand it.
Where do you want to read the OUT parameter?

  • In a pl/sql program?
  • In a java program?
  • Somewhere else?


  • Can you post the piece of code where you are trying to read the OUT parameter?



    Sorry Jan, I am using JDBC to read the OUT Parameter.

    Java Code is




    I want to know what Type to use in registerOutParameter method.

    Thanks
    Prashant
     
    Jan Cumps
    Bartender
    Posts: 2662
    19
    Netbeans IDE C++ Linux
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    The procedure has 2 parameters and is called getChildRelationsByInstanceId , and the JDBC code shows three parameters (question marks) and is called proc3.
     
    Prashant Saraf
    Ranch Hand
    Posts: 57
    Eclipse IDE Java Linux
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    hi
    here is my code



    On cstmt.execute(); it throws following exception.

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



    my procedure returns TABLE of RECORD.

    Please help
     
    What do you have in that there bucket? It wouldn't be a tiny ad by any chance ...
    Smokeless wood heat with a rocket mass heater
    https://woodheat.net
    reply
      Bookmark Topic Watch Topic
    • New Topic