Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 54793475AE5
	for <pgsql-sql@postgresql.org>; Mon, 30 Dec 2002 03:16:43 -0500 (EST)
Received: from mobax.com (mh10.voicegateway.com [64.124.36.200])
	by postgresql.org (Postfix) with ESMTP id 4D71B475AA1
	for <pgsql-sql@postgresql.org>; Mon, 30 Dec 2002 03:16:41 -0500 (EST)
Received: from Earth [203.195.200.5] by mobax.com with ESMTP
	(SMTPD32-7.13) id A1421C1012A; Mon, 30 Dec 2002 00:18:10 -0800
Message-ID: <003301c2afdc$96057080$67cac9c8@mobax.com>
From: "Senthil" <senthil.kandaswamy@mobax.com>
To: <pgsql-sql@postgresql.org>
Subject: Doubts porting from Oracle to postgresql
Date: Mon, 30 Dec 2002 13:52:13 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0030_01C2B00A.A7C8A020"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Declude-Sender: senthil.kandaswamy@mobax.com [203.195.200.5]
X-Declude-Spoolname: D014201c1012a89f8.SMD
X-Note: This E-mail was scanned for outbound spam.
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/7
X-Sequence-Number: 10872

This is a multi-part message in MIME format.

------=_NextPart_000_0030_01C2B00A.A7C8A020
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hai everybody,
=20=20
Hai,=20
   Currently, I'm at the work of converting database from Oracle to Postgre=
sql.
   I have some doubts:

         1) What is the equivalent of Oracle ROWNUM in Postgresql?  If ther=
e is no such equivalent, can U give me an idea about                 that?
         2) How to replace stored procedures with many OUT parameters?  I w=
ant to call the procedure from Java code.
             Please tell me the way to return the values of OUT parameters =
returned previously by Oracle, from the plpgsql code.
              It's very urgent.  Please reply quickly with some code exampl=
es.

                HOW to handle the values returned by the Oracle OUT paramet=
ers, in Postgresql?
                i.e, how to return the Oracle OUT parameters'  values to th=
e calling Java code, in postgresql.
                If anybody knows, please explain with suitable examples wit=
h plpgsql code and also the Calling Java code.

         3) Can default values be assigned to postgresql function parameter=
s?  If yes, how?=20


Thanks in advance.
Senthil.

------=_NextPart_000_0030_01C2B00A.A7C8A020
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 http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2719.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hai everybody,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;=20
<DIV><FONT face=3DArial size=3D2>Hai, <BR>&nbsp;&nbsp; Currently, I'm at th=
e work of=20
converting database from Oracle to Postgresql.<BR>&nbsp;&nbsp; I have some=
=20
doubts:</FONT></DIV><FONT face=3DArial size=3D2>
<DIV><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1) What is the=20
equivalent of Oracle ROWNUM in Postgresql?&nbsp; If there is no such equiva=
lent,=20
can U give me an idea about &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;=20
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;=20
that?<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2) How to replace=
=20
stored procedures with many OUT parameters?&nbsp; I want to call the proced=
ure=20
from Java=20
code.<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;=20
Please tell me the way to return the values of OUT parameters returned=20
previously by Oracle, from the plpgsql=20
code.<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;=20
It's very urgent.&nbsp; Please reply quickly with some code examples.</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;HOW=20
to handle the values returned by the Oracle OUT parameters, in Postgresql?<=
/DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;=20
i.e, how to return the Oracle OUT parameters'&nbsp; values to the calling J=
ava=20
code, in postgresql.</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;=20
If anybody knows, please explain with suitable examples with&nbsp;plpgsql c=
ode=20
and also the Calling Java code.</DIV>
<DIV><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3) Can default va=
lues=20
be assigned to postgresql function parameters?&nbsp; If yes, how? </DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>Thanks in advance.</DIV>
<DIV>Senthil.</FONT></DIV></FONT></DIV></BODY></HTML>

------=_NextPart_000_0030_01C2B00A.A7C8A020--