PL/SQL (MOSC)

MOSC Banner

Syntax conversion of STORED PROCEDURE

edited Oct 24, 2011 7:07AM in PL/SQL (MOSC) 5 comments
A couple of years ago I wrote a program which transfers n SQL UNLOAD file (in Centura/Gupta, now Unify) syntax into PL/SQL and transfers these statements (including the INSERTS etc.) via OCI into an Oracle database. It's a huge hack of Lex and Yacc, but it works fine, despite of the fact that the developers at my customers' site now decided to introduce  stored procedures. And thus I have to cope with these too. Either by skipping (at the moment the editor is used to eliminate the portions of SQL that cannot be understood by my translator).
I would like to translate these STORED PROCEDURES into the corresponding Oracle syntax and therefor I need some help, perhaps from you experts here.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center