fortran and oracle pl/sql

[di camillo]

Excuse me for my english but I'm italian.
I have to call (exec) a little oracle pl/sql procedure from a fortran program and I don't know haw I can. I wrote pl/sql procedure to extract some field from an oracle database and I have to write the fortran program to merge some other calls. I work under unix SO.
Thanks very much, I need so much an answer.

[R. Allan Hicks · Accepted solution]

That's ok, your english is much better than my Italian.

I not really sure what you are doing, but you may want to check out pro*FORTRAN. I think Oracle may still support it. It allows you to put pl/sql statements in your FORTRAN code.

Another option:
Oracle has some routines in a set of libraries called OCI (Oracle Call Interface). They are designed to be used with C. If you are good with C you could write some "wrappers" (a slang term for C routines that translate the calling squence to and from FORTRAN).

Yet another option:
Spawn the pl/sql process with wait.

Use the dbms_output package to write your pl/sql data to a text file.

When the child completes, read the text file with the FORTRAN process.