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

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

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
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:00:29
Message-ID: 410BD02D.1040104@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers

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.
>  
>


It appears you can have multiple exceptions in a single handler, but 
that the separator is 'OR' rather than ','.

See 
http://www.cise.ufl.edu/help/database/oracle-docs/appdev.920/a96624/13_elems17.htm

The page also gives a link to a list of the predefined exceptions. 
PL/SQL allows users to define and raise their own exceptions too.

cheers

andrew


In response to

Responses

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2004-07-31 17:13:25
Subject: Re: Anybody have an Oracle PL/SQL reference at hand?
Previous:From: Peter EisentrautDate: 2004-07-31 16:33:00
Subject: Re: Compile failure on nl_langinfo

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