Message-Id: <10676.121819@fatcity.com> From: "Sanjay Kumar" Date: Fri, 10 Nov 2000 17:57:49 -0800 Subject: Very Very Urgent : Java with Oracle This is a multi-part message in MIME format. ------=_NextPart_000_000F_01C04B3F.BD3F9EE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I have a situation like this. There is a stored procedure which accepts few arguments. based on these = arguments, a SQL statement is framed on the fly. When this procedure is called from Java, the statement that is framed on = the fly is executed and has to give resultset to the Java Calling = program. How would appreciate if someone tells me how to do it? I tried using Open For and Execute Immediate inside the procedure, but = then the questions arises as to how the resultset is given to the = calling java program because for every fetch the records have to stored = somewhere. One way I could think of is PLSQL Array but parallely a = question arises as to how will a PLSQL array be returned to a Java = program and how will Java understand PLSQL array type. Any suggestions, please help. Raj ------=_NextPart_000_000F_01C04B3F.BD3F9EE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

I have a situation like = this.

There is a stored procedure which = accepts few=20 arguments. based on these arguments, a SQL statement is framed on the=20 fly.

When this procedure is called from = Java, the=20 statement that is framed on the fly is executed and has to give = resultset to the=20 Java Calling program.

How would appreciate if someone tells = me how to do=20 it?

I tried using Open For = and=20 Execute Immediate inside the procedure, but then the = questions=20 arises as to how the resultset is given to the calling java program = because for=20 every fetch the records have to stored somewhere. One way I could think = of is=20 PLSQL Array but parallely a question arises as to how will a PLSQL array = be=20 returned to a Java program and how will Java understand PLSQL = array=20 type.

Any suggestions, please = help.

Raj