Re: Converting PL/SQL to PL/PGSQL

On Thu, May 10, 2001 at 03:33:27PM +0200, Klaus Reger wrote:
> Hi all!
>
> I have to convert functions and procedures from Oracle to PostgreSQL. I
> looked at all the stuff of the Pg-Homepage and I ask me if there are any
> tools, that support the conversion.

That help you in the conversion, no.
Have you looked at the "Porting From Oracle PL/SQL" chapter of the
PostgreSQL Programmer's Guide? I am expanding that guide to include more
things, like queries. The goas is for it to become a "Porting From
Oracle" guide.

> Writing PS/PGSQL tools seems to be a bit hard, because of the existing
> tool-infrastructure on linux. Are there are tools I have overseen?

Heh? What do you mean by this? There are zillions of editors, both
console and graphical, where you can do this.
I have found pgaccess to be vey useful in testing. In the OpenACS
project (www.openacs.org) we port thousands of lines of Oracle code to
PostgreSQL, mostly using vim or Emacs.
For testing, I use pgaccess because it lets me drop/recreate a
function easily, plus it escapes quotes. One thing I don't like about it
is that it's hard to keep things indented.

> - A WWWdb-Application for editing and testing of SQL-Procedures over a
> WEB-frontend

Cool. Anywhere we can see this in action?

> - A perl-script, that does basic conversions between PL/SQL <-> XML <->
> PL/PGSQL (The Procedure-definition is converted completely, the code-block
> a little bit)

Hmmm. *Very* interesting. Link? Source for this anywhere? We could
probably use this at OpenACS.

-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Developer
(D)inner not ready: (A)bort (R)etry (P)izza