Syntax conversion of STORED PROCEDURE
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.
I would like to translate these STORED PROCEDURES into the corresponding Oracle syntax and therefor I need some help, perhaps from you experts here.
0