I am looking for tools that automate, or help , the conversion of
Oracle's PRO*C to Oracle PL/SQL.Information on any such tools and
experiences are very welcome. Thanks.

On May 11, 12:44 am, Selvaren... (AT) gmail (DOT) com wrote:
This request is unclear. Do you want
to call PLSQL from ProC?
then read the manuals.

to take a given ProC program source code and thru some filter make a
PL/SQL package automatically?
I know of no such tool. It would be very difficult to do given the
differences between ProC and PL/SQL. It seems akin to taking assembler
and comverting back to a high level language like PASCAL or COBOL.

to extract the embedded SQL from the ProC program?
Seems like a text editor should be able to do this nicely keying off
the EXEC lines.

If I was to rewrite a ProC program in PL/SQL, then that's what I'd do:
rewrite it. The embedded SQL comes free but the processing code will
be much different in PL/SQL than it is in C. It may be better to go
back to the Business Requirements document to drive the rewrite.

HTH,
ed