PL/SQL under Pro*Fortran

From: WASHIDE_at_DELPHI.COM <(WASHIDE_at_DELPHI.COM)>
Date: 18 Jan 1994 14:30:21 -0500
Message-ID: <2hhdcd$9ee_at_news.delphi.com>


I'm currently in the process of changing some OLD Fortran code from using multiple SQL calls to using a single PL/SQL block. Unfortunately , I'm not the biggest Pro*Fortran expert and I'm running into trouble during the precompile. I also don't have a Pro*Fortran Supplement to the Precompilers.

The code:

        EXEC SQL EXECUTE
         DECLARE

           ...blah, blah, blah

The error I get during the precompile is a PCC-003 - Invalid SQL identifier at column 22 in line 205 of file "scanid.pfo".

The precomiler seems to not like the EXECUTE in that first line. Is Pro*Fortran different from Pro*C when declaring a PL/SQL block? If anyone can help with this please reply to WASHIDE_at_delphi.com. Any help will be much appreciated.

Doug Washington
Whirlpool Corporation Received on Tue Jan 18 1994 - 20:30:21 CET

Original text of this message