Larry Weatherly wrote:

>>What are you trying to do in SP's that is not
>
> working?
>
> I want to port some Oracle code. I'm not talking
> about little snippets of code, 1000's and 1000's of
> lines of stored procs.

OK - that is a different problem :)

You don't need a debugger, but a translator would be useful.

Porting MySQL and the likes has been easy - sort of, but I
would suspect that once the relevant tables and views have
been addressed, the rest should not be too difficult with
Oracle.

The Commercial Copy of the Clay tools will actually handle
Oracle 9.2 modelling, and I think that you will have to pay
money for tools that can handle Oracle to Firebird
conversion, but hand processing the scripts using find and
replace is free.

The TikiWiki SQL script I converted is 6000 line, and only
took a few hours with the tools I listed.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services