Does anyone know how to pass data to a pl/sql function/proc which accepts a cursor as an input using a CallableStatement?
Printable View
Does anyone know how to pass data to a pl/sql function/proc which accepts a cursor as an input using a CallableStatement?
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 :)