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

Re: Anybody have an Oracle PL/SQL reference at hand?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Anybody have an Oracle PL/SQL reference at hand?
Date: 2004-07-31 17:13:25
Message-ID: 410BD335.9010308@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hello,

 From I can tell from Oracle pl/SQL programming page 130 ;) it is 
identical. However Oracle does have thinkgs like EXCEPTION_INIT.

Here are the name of the Oracle predefined exceptions:

CURSOR_ALREADY_OPEN
DUP_VAL_ON_INDEX
INVALID_CURSOR
INVALID_NUMBER
LOGIN_DENIED
NO_DATA_FOUND
NOT_LOGGED_IN
PROGRAM_ERROR
STORAGE_ERROR
TIMEOUT_ON_RESOURCE
TOO_MANY_ROWS
TRANSACTION_BACKED_OUT
VALUE_ERROR

Sincerely,

Joshua D. Drake




Tom Lane wrote:
> Can anyone check how well the syntax of plpgsql EXCEPTION, as described
> at
> http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
> agrees with what Oracle does?  I did some googling but couldn't find
> anything that seemed authoritative.  I'm wondering in particular if
> Oracle allows multiple condition names per WHEN, along the lines of
> 	WHEN condition [ , condition ... ] THEN
> 		handler_statements
> 
> Also it would be nice to see a complete list of the "condition" names
> that they accept.  I whipped up a quick table based on our ERRCODE
> macro names, see
> http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/pl/plpgsql/src/plerrcodes.h
> but I'm certain that's not what we really want to expose to users
> in the long run.
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend


-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment: jd.vcf
Description: text/x-vcard (640 bytes)

In response to

pgsql-hackers by date

Next:From: Euler Taveira de OliveiraDate: 2004-07-31 17:23:46
Subject: Re: Compile failure on nl_langinfo
Previous:From: Andrew DunstanDate: 2004-07-31 17:00:29
Subject: Re: Anybody have an Oracle PL/SQL reference at hand?

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