Home » SQL & PL/SQL » SQL & PL/SQL » Passing a recordset into a stored procedure from java
Passing a recordset into a stored procedure from java [message #188923] Tue, 22 August 2006 07:37 Go to next message
kieranl
Messages: 6
Registered: May 2005
Junior Member
Does anyone know if there's a simple way to pass in a recordset (ref cursor) into a stored procedure from java?

Re: Passing a recordset into a stored procedure from java [message #189014 is a reply to message #188923] Tue, 22 August 2006 15:14 Go to previous messageGo to next message
tongucy
Messages: 8
Registered: August 2006
Junior Member
this may help;
http://www.oracle.com/technology/sample_code/tech/java/sqlj_jdbc/files/basic/RefcursorSample/Readme.html
Re: Passing a recordset into a stored procedure from java [message #190186 is a reply to message #189014] Tue, 29 August 2006 10:38 Go to previous messageGo to next message
kieranl
Messages: 6
Registered: May 2005
Junior Member
thanks for the reply, but there's plently of info out there for passing a recordset OUT a procedure/function

But i'm looking to know the opposite: how to pass a recordset INTO a procedure/function, and then read and process through it's rows?
Re: Passing a recordset into a stored procedure from java [message #190199 is a reply to message #190186] Tue, 29 August 2006 12:13 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
One way to pass recordsets from the client to the server I have found is by passing arrays. (multiple arrays if multiple columns are needed).

http://asktom.oracle.com/pls/ask/f?p=4950:8:3378078247185819672::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:712625135727"
Previous Topic: how to delete duplicate rows
Next Topic: EASY Q - How to check that import was successful?
Goto Forum:
  


Current Time: Sat Dec 03 09:38:28 CST 2016

Total time taken to generate the page: 0.09325 seconds