Re: Very Very Urgent : Java with Oracle

From: Ajay K <ajay_at_tems.com>
Date: Fri, 10 Nov 2000 18:36:48 -0600
Message-Id: <10676.121822@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3105.105" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I faced this problem someday back.Now i =
m leaving=20
for home.Will write u on monday.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>ajay</FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A href=3D"mailto:ora_user_at_hotmail.com" = title=3Dora_user_at_hotmail.com>Sanjay=20
  Kumar</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, November 10, 2000 = 8:32=20
  PM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Very Very Urgent : = Java with=20
  Oracle</DIV>
  <DIV><BR></DIV>Hi,<BR><BR>I have a situation like this.<BR>There is a = stored=20
  procedure which accepts few arguments. based on these arguments, a SQL =

  statement is framed on the fly.<BR><BR>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.<BR><BR>How would appreciate if = someone=20
  tells me how to do it?<BR><BR>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.<BR><BR>Any=20
  suggestions, please =
help.<BR><BR><BR>Raj<BR></BLOCKQUOTE></BODY></HTML> Received on Fri Nov 10 2000 - 18:36:48 CST