Skip site navigation (1) Skip section navigation (2)

Re: Stored procedures doubts

From: Jie Liang <jie(at)stbernard(dot)com>
To: 'Senthil' <senthil(dot)kandaswamy(at)mobax(dot)com>,pgsql-admin(at)postgresql(dot)org
Subject: Re: Stored procedures doubts
Date: 2002-12-31 19:35:16
Message-ID: E7E213858379814A9AE48CA6754F5ECB1E1981@mail01.stbernard.com (view raw or flat)
Thread:
Lists: pgsql-admin
read docs 19.11. porting from oracle pl/sql coming with tarball or
 
http://www.postgresql.org/idocs/index.php?plpgsql-porting.html
<http://www.postgresql.org/idocs/index.php?plpgsql-porting.html> 
 
it's section 23.11.
 
 
Jie Liang
 

-----Original Message-----
From: Senthil [mailto:senthil(dot)kandaswamy(at)mobax(dot)com]
Sent: Monday, December 30, 2002 9:11 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Stored procedures doubts


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


         1) What is the equivalent of Oracle ROWNUM in Postgresql?  If there
is no such equivalent, can U give me an idea about                 that?
         2) How to replace stored procedures with many OUT parameters?  I
want 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
examples.
 
                HOW to handle the values returned by the Oracle OUT
parameters, in Postgresql?
                i.e, how to return the Oracle OUT parameters'  values to the
calling Java code, in postgresql.
                If anybody knows, please explain with suitable examples with
plpgsql code and also the Calling Java code.

         3) Can default values be assigned to postgresql function
parameters?  If yes, how? 
 
 
Thanks in advance.
Senthil.

Responses

pgsql-admin by date

Next:From: CoLDate: 2002-12-31 19:52:02
Subject: Re: Is there any eqvivalent or alternative to UPDATE(column) or COLUMNS_UPDATED()
Previous:From: Jie LiangDate: 2002-12-31 19:25:34
Subject: Re: postmaster failing to shut down

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group