Eric,
Then you are still in luck. PostgreSQL comes with a comparable feature to
oracle's PL/SQL, called PL/pgSQL. You can read about the details here:
http://www.postgresql.org/idocs/index.php?plpgsql.html
chris
On Mon, 30 Jul 2001, Eric, Audet wrote:
> Oh ... my database is PostgreSQL (opensource)
>
> Eric
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 30, 2001 2:21 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Query with return value
>
>
> Eric,
>
> PL/SQL (Procedural Language SQL) is an Oracle product. It allows you to make
> a script that combines a lot of rudimentary procedural language stuff with
> sql statements. So you can create variables, arrays, do looping, handle
> exceptions etc. The script is saved in a file and can be run from the
> SQL*PLUS command line with an '@' (eg "@script.sql"). Or you can put one
> inside a DBI cursor and pass it a few parameters and have it execute several
> inserts, updates etc. to different tables without a lot of hassle.
>
> There's probably all sorts of free information and tutorials about PL/SQL on
> the internet. I myself like books better, because I can read them in the
> bathtub. I have "Sams Teach Yourself PL/SQL in 21 Days" and I think it's
> pretty good. Someone else in our office has the O'Reilly book, and those are
> usually very good. You don't need to become an expert at PL/SQL, but if you
> learn the basics you'll be very glad you did.
>
> Sorry if this has gotten a little off topic for this board, but Perl DBI and
> PL/SQL are really good together and more people should know about it!!!
>
> Tim
>
