Pro*C and PL/SQL interaction questions

I'm converting a program from using Flat Files as a database to using Oracle as a database and then converting the application to a GUI front-end. The client wants all the interactions with Oracle from the Applications to use PL/SQL packaged procedures. Unfortunately, there is an encryption/decryption function in the origianl C which relies heavily on pointer arithmetic and static variables.

Thus, I have these questions:

1. In PL/SQL, is there a way to call a C-Program and pass data to it?
2. In Pro*C, is there a way to pass a 'struct' datatype into PL/SQL as a parameter?
3. In Pro*C, is there a way to define a C datatype that is equivalent to the %ROWTYPE structure of a table or cursor?

If the answer is Yes to any of these questions, could you point me to a code example of the solution?

Thank you for your help.

-Louise Rogow Howard Received on Thu Feb 13 1997 - 00:00:00 CST