Re: converting to java stored procs

From: Michael Weir <mweir_at_transres.com>
Date: Tue, 24 Jun 2003 11:16:00 -0400
Message-ID: <YWZJa.144$oD6.4857_at_news.on.tac.net>


Thanks for the advice.

What we're actually doing is building something that has to run on MS SQL Server; Oracle, and DB2. I'd like to find a way of maintaining a single set of source code that can be used to generate stored procs for each of these platforms.

"Rauf Sarwar" <member31517_at_dbforums.com> wrote in message news:3027385.1056145927_at_dbforums.com...
>
> Originally posted by Michael Weir
> > Is there a tool that generates java stored procs from regular
> > stored procs?
> > Thanks.
>
>
> Just want to put this out, as mentioned here frequently, to give you
> second thoughts on whatever I assume you are trying to do...
>
> 1) If you can do it in SQL then do it in SQL.
> 2) If you can't do it in SQL then do it in PL/SQL
> 3) If you can't do it in PL/SQL, Only then do it in Java
>
> Regards
> /Rauf Sarwar
>
> --
> Posted via http://dbforums.com
Received on Tue Jun 24 2003 - 17:16:00 CEST

Original text of this message