Re: Bus Error in Embedded SQL
From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: 1998/10/21
Message-ID: <70kb72$hsm$1_at_schbbs.mot.com>#1/1
Date: 1998/10/21
Message-ID: <70kb72$hsm$1_at_schbbs.mot.com>#1/1
Don't know about Fortran but in Pro*C you would need a ';' comma to close the EXEC SQL. It couldn't be as simple as that could it?
-- Alan D. Mills Peter Lanore wrote in message <70j430$1jv$1_at_lore.eur.sprynet.com>...Received on Wed Oct 21 1998 - 00:00:00 CEST
>I'm encountering the Bus Error (coredump) when attempting to open an Oracle
>database via a Pro*Fortran called subroutine with embedded SQL.
>
>The error occurs in the following code segment.
>C BEGIN PRO*FORTRAN ADD INS MODE 1
> USRNAME = 'scott'
> PASWORD = 'tiger'
> INSTNCE = 'GZEL'
> EXEC SQL WHENEVER SQLERROR GOTO 110
> EXEC SQL
> - CONNECT :USRNAME
> - IDENTIFIED BY :PASWORD
> - USING :INSTNCE
>
>Oracle Rev is 7.3.3. Operating system is SunSPARC/Solaris. Fortran is
>Fortran90
>
>I prefer email responses but appreciate posted responses as well.
>
>Peter W. LaNore
>
>