For Programmers: Free Programming Magazines  


Home > Archive > Cobol > January 2008 > Re: oracle10g SQLBEX giving 114 with Oracle Dynamic SQL Method 4









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: oracle10g SQLBEX giving 114 with Oracle Dynamic SQL Method 4
bine

2008-01-28, 6:56 pm

On 24 Jan., 22:50, "Sergey Kashyrin" <s...@resqnet.com> wrote:
> For Win x64 I had to patch Cobol program after preprocessor this way (sed)=

:
> s/02 =A0SQL-SQLVSN =A0 PIC S9(18)/02 =A0SQL-SQLVSN =A0 PIC S9(9)/
> /02 =A0SQL-DUMMY/d
> s/02 =A0SQL-SQHSTL =A0 PIC S9(18)/02 =A0SQL-SQHSTL =A0 PIC S9(9)/
> s/02 =A0SQL-SQHSTS =A0 PIC S9(18)/02 =A0SQL-SQHSTS =A0 PIC S9(9)/
> s/02 =A0SQL-SQINDS =A0 PIC S9(18)/02 =A0SQL-SQINDS =A0 PIC S9(9)/
> s/02 =A0SQL-SQHARM =A0 PIC S9(18)/02 =A0SQL-SQHARM =A0 PIC S9(9)/


hi Sergey,
you got it!
it seems the oracle-documentation is insufficient because for
10.2.0.3.0 as well as even 11g it only mentiones PIC S9(9) fields but
we got the idea after metalink insisting that we try the sample10 in
the $ORACLE_HOME/precomp/demo first.

On AIX5.3-64bit was an include $ORACLE_HOME/precomp/public/bndsel.cob
which consisted of some PIC S9(18) definitions (plus 2 new fillers :-)
in the BNDDVAR and SELDVAR parts.

we wouldn't have found that solution on SLES9 had we looked there
because sample10 there fails as well (because the include is the old
one from 9.2.0.4.0 32bit)

who would have thought to try all sample*.pco again after having a
successfully running application for some years now ... ;-(

but anyway: I got a solution to our problem and oracle promised to
open
<Bug:6778490> DOC: PRO*COBOL PROGRAMMERS GUIDE SHOWS ONLY SQLDA FOR
32BIT PLATFORMS
and everybody's happy again ;-)
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com