Re: [sqr-users] Linking SQR 4.3 on VMS with no local Oracle 9iDatabase

["Greg Devereaux" <devereaux@hartford.edu>]

Hello,

I finally have SQR version 4.3.5 working on VMS with our SUN 9.2.0.4
databases. After all the effort to put a local database up, we discovered it
didn't fix the problem after all. Knowing the names compilier conflict was
introduced in 9.2.0.4 I thought I would try to link against the 9.2.0.2
version of libclntsh.so.
So I uninstalled the latest version we had after patches (libclntsh.so;3
33525  23-MAR-2004)
copied the first version (libclntsh.so;1 33195  11-MAR-2004 ) to
libclntsh.so;4
I rebooted which installed it and then linked against it. It works with out
stack dumping! I expect we will have to change our SQLNET network service
name to SID.WORLD after error regarding service name But that should be easy
to fix.

libclntsh.so;4         33195  14-APR-2004 16:53:21.67  (RWE,RWED,RE,RE)
libclntsh.so;3         33525  23-MAR-2004 09:15:16.58  (RWE,RWED,RE,RE)
libclntsh.so;2         33493  12-MAR-2004 10:12:08.64  (RWE,RWED,RE,RE)
libclntsh.so;1         33195  11-MAR-2004 21:13:59.25  (RWE,RWED,RE,RE)

So I expect everyone that is working linked their SQR against the 9.2.0.2
version of libclntsh.so.
I expect anyone that links to the latest versions (libclntsh.so;3   33525)
would have problems most likely introduced by the names case problem within
the libclntsh shared object. I think that may even be addressed with LDA_DEF
or perhaps with symbols that equate the new to the old names.

Greg Devereaux.
University of Hartford CT.
----- Original Message ----- 
From: "Greg Devereaux" <devereaux@hartford.edu>
To: "This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions." <sqr-users@sqrug.org>
Sent: Thursday, March 25, 2004 12:38 PM
Subject: Re: [sqr-users] Linking SQR 4.3 on VMS with no local Oracle
9iDatabase


> Well here is an update after working with Oracle and installing a couple
> more patches for our VMS Oracle 9i OCI development environment.
>
>  I have been working on getting SQR version 4.3.2.1 running with Oracle 9i
> on
> VMS 7.3-1. After working with Oracle to get our OCI linking utilities
> patched and
> successfully compiling one of their test programs it appears that we will
be
> unable
> to build SQR using the LNOCIC.COM and LOUTL.com linker scripts from Oracle
> 9i.
> Apparently the object files and symbols referenced have used different
cases
> for
> definitions and/or symbol names that show up as an ident mis-matches.
>
> These can be resolved only through the CC command with the modifier
> /names=(as_is)
> which leaves the case unchanged for definitions and symbol name
resolution.
>
> Some of my co-workers are certain that others are running SQR 4.3 on VMS
7.3
> with Oracle 9i.
>
> If you are using SQR 4.3 on VMS 7.3 with Oracle 9i can you tell us if you
> were able to
> get it to work with the linking utilities (LNOCIC.COM) or by creating own
CC
> command?
>
> I expect the use of the CC command was required to circumvent this
problem,
> could you share your solution with us please?
>
> Here is output information that demonstates the problem.
>
> To demonstrate:
> ===============
> $set def ora_oci_demo
> $cc cdemo1 /include=(ora_root:[rdbms.demo],ora_root:[rdbms.public])
>
> $lnocic cdemo1
>
> - Linking CDEMO1.EXE
>
> $run cdemo1
>
> %SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual
> address=FFFFFFFFFFFF
> FFFF, PC=00000000002634EC, PS=0000001B
> %TRACE-F-TRACEBACK, symbolic stack dump follows
> image module routine line rel PC abs PC
> LIBCLNTSH OCICOB OLOG 171117 000000000000059C 00000000002634EC
> CDEMO1 CDEMO1 main 7239 0000000000000134 0000000000030134
> CDEMO1 CDEMO1 __main 0 0000000000000064 0000000000030064
> PTHREAD$RTL 0 000000000003E4E0 000000007BC5C4E0
> PTHREAD$RTL 0 000000000001C31C 000000007BC3A31C
> 0 FFFFFFFF8028D59C FFFFFFFF8028D59C
>
> $cc
>
cdemo1/include=(ora_root:[rdbms.demo],ora_root:[rdbms.public])/names=(as_is)
>  <<--add this
>
> $lnocic cdemo1
> - Linking CDEMO1.EXE
>
> $run cdemo1
>
> Connected to ORACLE as SCOTT
> Enter employee name (or CR to EXIT): miller
> Enter employee job: clerk
> Enter employee salary: 1300
> Enter employee dept: 10
>
> miller added to the ACCOUNTING department as employee number 7944
>
> Enter employee name (or CR to EXIT):
> Exiting...
>
>
> When we attempt to run an SQR program we have the same type of Access
> violation,
> it is presumed to be due to the symbol names case differences. Error shown
> below...
>
>
> SQR V4.3.2.1
> Copyright (C) SQRIBE Technologies, 1994-98.  All Worldwide Rights
Reserved.
>
> %SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual
> address=FFFFFFFFFFFF
> FFFF, PC=0000000000363928, PS=0000001B
> %TRACE-F-TRACEBACK, symbolic stack dump follows
>   image    module    routine             line      rel PC           abs PC
>  LIBCLNTSH  OCICOB  ORLON              171276 00000000000009D8
> 0000000000363928
>  SQR  DBCALLS  sqr0253                  12186 0000000000000100
> 00000000000435E0
>  SQR  RDPGM  sqr0479                    12464 0000000000000CF8
> 000000000006CED8
>  SQR  SQR  SQR_CommonLogic              14622 0000000000001048
> 0000000000041048
>  SQR  SQR  main                         13896 00000000000002A0
> 00000000000402A0
>  SQR  SQR  __main                           0 00000000000000A8
> 00000000000400A8
>  PTHREAD$RTL                                0 000000000003F0D0
> 000000007BC770D0
>  PTHREAD$RTL                                0 000000000001C31C
> 000000007BC5431C
>                                             0 FFFFFFFF8028B4D4
> FFFFFFFF8028B4D4
>
>
> Thank you for any assistance you can provide,
>
>       Greg Devereaux
>       University of Hartford CT.
>       devereaux@hartford.edu
>
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users