Message-Id: <10676.121822@fatcity.com> From: "Ajay K" Date: Fri, 10 Nov 2000 18:36:48 -0600 Subject: Re: Very Very Urgent : Java with Oracle This is a multi-part message in MIME format. ------=_NextPart_000_0F26_01C04B45.2F9897D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I faced this problem someday back.Now i m leaving for home.Will write u = on monday. ajay ----- Original Message -----=20 From: Sanjay Kumar=20 To: Multiple recipients of list ORACLE-L=20 Sent: Friday, November 10, 2000 8:32 PM Subject: Very Very Urgent : Java with Oracle 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_0F26_01C04B45.2F9897D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I faced this problem someday back.Now i = m leaving=20 for home.Will write u on monday.
ajay
----- Original Message -----
From:=20 Sanjay=20 Kumar
To: Multiple recipients of list ORACLE-L =
Sent: Friday, November 10, 2000 = 8:32=20 PM
Subject: Very Very Urgent : = Java with=20 Oracle

Hi,

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

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

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

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

Any=20 suggestions, please = help.


Raj