Can you call Oracle (SQL*Plus) from COBOL

[welchdor]

Hi,
I was wondering if anyone knows if it's possible to do a call to an Oracle database, like to execute a SQL command, from a COBOL program. If so, how do you do it? And what do you need to have to be able do it...some API, etc.?

We're talking about COBOL on DB2 calling Oracle on NT...we have the Oracle/DB2 gateway in place for communication between the two databases, and that much does work.

Any info on the subject is greatly appreciated.

 

[StephenJSpiro]

You use the ordinary SQL interface. You embed EXEC SQL statements, terminated with END-EXEC. And you need the Oracle SQL Pre-processor. Talk to your vendor.

Don't know what you mean by "COBOL on DB2 calling Oracle on NT" You can run COBOL and DB2 on NT, you can run Oracle on a mainframe.

Can you be more specific?

Stephen J Spiro