Home » Developer & Programmer » Precompilers, OCI & OCCI » Executing Oracle procedure from Cobol (batch)
Executing Oracle procedure from Cobol (batch) [message #15991] Fri, 05 November 2004 03:58 Go to next message
Todd Gieryic
Messages: 2
Registered: November 2004
Junior Member
I am trying to exeucte an Oracle procedure from a Cobol program. I have several EXEC SQL statements ahead of this on but I compiler gives me the following message.  The proc is fully quailified with owner/package/proc name.  Any ideas ?

    EXEC SQL                                              

      execute cdr_dev.parse_xml_logic.test                   

AN "EXEC SQL" STATEMENT WAS FOUND, BUT THE "SQL" COMPILER OPTION WAS NOT
IN EFFECT.  THE STATEMENT WAS DISCARDED.                               
                                                                       
    END-EXEC.                                                 
Re: Executing Oracle procedure from Cobol (batch) [message #16020 is a reply to message #15991] Sat, 06 November 2004 10:23 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
Please try this:

EXEC SQL EXECUTE 
         BEGIN 
           cdr_dev.parse_xml_logic.test;              
         END;
END-EXEC. 
Re: Executing Oracle procedure from Cobol (batch) [message #16031 is a reply to message #15991] Sun, 07 November 2004 18:21 Go to previous message
manish choudhary
Messages: 2
Registered: November 2004
Junior Member
Hi friend
use Do_com function to execute the oracle procedure
with thw help of dual table
manish
Previous Topic: Sub-queries and host variables in Pro*Cobol
Next Topic: needs-Free pro*C compiler website
Goto Forum:
  


Current Time: Sat Aug 08 19:07:47 CDT 2020