Callable Statements with Java
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Callable Statements with Java

  1. #1
    Join Date
    Feb 2001
    Location
    Master Control
    Posts
    86

    Callable Statements with Java

    Does anyone know how to pass data to a pl/sql function/proc which accepts a cursor as an input using a CallableStatement?

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  3. #3
    Join Date
    Feb 2001
    Location
    Master Control
    Posts
    86
    i undestand this...i am trying to pass a datatype from java to oracle...the oracle proc/func must accept a cursor as input. therefore my problem is to find what kind of java object to define as a cursor? i really don't know if this is even possible, but i figured it would be worth a stab. the example about has .getObject where I would want something like .setObject

    i have looked at the CallableStatement Interface and i think that there is a way to do some sort of .setObject...if anyone has an example it would be a great help...if not thanks for looking anyway

Posting Permissions

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



Click Here to Expand Forum to Full Width