Re: Converting PL/SQL to Java or SQL?

From: Steve Long <steven.long_at_erols.com>
Date: Mon, 25 Sep 2000 23:23:52 -0400
Message-ID: <8qp4m0$muf$1@bob.news.rcn.net>

since SQL is a functional language and PL/SQL is a procedural language, it is not possibe to convert PL/SQL into SQL. should someone create the tool it would be more likely to convert PL/SQL into Java...but i am not aware of any such tool. however, this hint might help. PL/SQL is a derivative of Ada. If you can find Ada tools, they most likely will also work on all of your PL/SQL...

"Matias Pelenur" <matiasp_at_email.com> wrote in message news:8qof57$gel$1_at_nnrp1.deja.com...
> Hi,
> This is probably kind of hopeless, but I was wondering if anyone knows
> of any tools ("magic wand" might be more appropriate) to translate
> PL/SQL procedures into SQLJ or SQL or other more standard and supported
> standards. The story is as usual, we have a bunch of PL/SQL stored
> procedures and we'd like to be able to run our database on other
> servers (MSSQL, etc), so we need to somehow convert our stored
> procedures in the most painless way possible.
>
> Thanks in advance,
> Matias
>
> If possible please copy responses to my email, matiasp_at_email.com.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Sep 25 2000 - 22:23:52 CDT