Re: Server Express 64bit and Oracle 9i problem (114) on AIX 5.2

From: sprog (sprog.14y2zz_at_mail.codecomments.com)
Date: 04/19/04 

Date: Mon, 19 Apr 2004 04:06:21 GMT

Hi Simon (and anyone else)

Thanks for that. We still seem to be getting a very unusual error with
our compiles in or makes.

A bit of background: we are "upgrading" from Oracle8i, SAS6, Solaris,
MF COBOL 4.5 to AIX 5L, Oracle9i, SAS8 and MF Server Express COBOL.

When we attempt to compile our COBOL it works fine. However if the
COBOL has embedded Oracle SQL our procomp makes try to access ADA. We
do not use ADA. I thought this must have been included by accident; but
can find no flag or install option for it. So can you give us any clues
as to why we are suffering an ADA plague :-))

Wayne

Simon Tobias wrote:
> *Hi Wayne (and Panos)
>
> Apologies if you're aware of some of this already, but I just wanted
> to
> clarify the steps involved in creating and executing a Pro*COBOL
> application
> with Micro Focus Server Express on UNIX.
>
> When installing Pro*COBOL on UNIX (as part of the main Oracle
> installation),
> you need to have your COBOL environment setup, in order for the
> installer to
> relink a COBOL RTS containing the Oracle support libraries
> (rtsora/rtsora32/rtsora64).
>
> The 64-bit edition of Oracle 9i on AIX 5.x creates rtsora -- the
> 64-bit
> version of the run-time -- and rtsora32 -- the 32-bit version of the
> run-time.
>
> It's imperative that you use the correct edition of Server Express,
> i.e.
> 32-bit or 64-bit -- note well, that these are separate products on
> this
> platform -- for the mode in which you wish to use Oracle. In
> addition, you
> need to ensure that LIBPATH is set to point to the correct Oracle
> 'lib'
> directory -- $ORACLE_HOME/lib32 for 32-bit, or $ORACLE_HOME/lib for
> 64-bit
>
> If you wish to recreate those executables, say if you've updated your
> COBOL
> environment since installing Oracle, then from looking at the
> makefiles --
> ins_precomp.mk and env_precomp.mk -- then the effective commands to
> use to
> re-link the run-time correctly are as follows (logged in under your
> Oracle
> user ID) :
>
> either mode:
> <set up COBDIR, ORACLE_HOME, ORACLE_BASE, ORACLE_SID as appropriate
> for your
> installation>
> export PATH=$COBDIR/bin:$ORACLE_HOME/bin:$PATH
>
> 32-bit :
> export LIBPATH=$COBDIR/lib:$ORACLE_HOME/lib32:$LIBPATH
> cd $ORACLE_HOME/precomp/lib
> make LIBDIR=lib32 -f ins_precomp.mk EXE=rtsora32 rtsora32
>
> 64-bit:
> export LIBPATH=$COBDIR/lib:$ORACLE_HOME/lib:$LIBPATH
> cd $ORACLE_HOME/precomp/lib
> make -f ins_precomp.mk rtsora
>
> Regarding precompiling your application, Oracle provide two versions
> of
> Pro*COBOL. Again, you need to use the correct one depending on
> whether
> you're creating a 32-bit or 64-bit application, as the precompiler
> will
> generate different code.
>
> If invoking Pro*COBOL directly, you need to use :
>
> 32-bit : procob32 / procob18_32 , e.g.
> procob32 myapp.pco
> cob -it myapp.cob
> rtsora32 myapp.int
>
> or
> 64-bit : procob / procob18 , e.g.
> procob myapp.pco
> cob -it myapp.cob
> rtsora myapp.int
>
> If you're using Server Express 2.2 SP1 or later, you can also compile
> using
> the Cobsql preprocessor, which will invoke the correct version of
> Pro*COBOL
> under the covers, allowing for a single precompile-compile step,
> e.g.
>
> cob -ik myapp.pco -C "p(cobsql) csqlt==oracle8 endp"
>
> This method also aids debugging, as you will see the original source
> code
> while animating, rather than the output from the precompiler. See the
> Server
> Express Database Access manual. Prior to SX 2.2 SP1, Cobsql only
> supported
> the creation of 32-bit applications.
>
> I hope this helps -- if you're still having problems, please let me
> know.
>
> Regards,
> SimonT. * 

--
sprog
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

Relevant Pages