Re: [sqr-users] Changing Oracle within an SQR

["George Jansen" <GJANSEN@aflcio.org>]

This isn't really an SQR problem. I'm guessing that the link is broken by 
something else: can you

SELECT whatever
FROM thatguy.thattab@remotedb
WHERE rownum <= 5

?

I bet not. As for SQR, if you link against 8i libraries--set your 

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

for some 8i Oracle Home, and relink SQR, you should be ok for 9i and 8i at 
least.

But are you sure you're not running into that blasted String2em problem?, the 
one for which you must

SET EVENT="10499 trace name context forever, level 1"?

>>> Jeff.Hill@cedarcrestone.com 09/22/05 7:41 AM >>>
Gang -

At my client, we have an SQR that uses a database link from an Oracle 9i to 
Oracle 7 to retrieve information.  We recently upgraded to 9i and determined 
that the link is no longer functional.  Is there a way, within SQR, to change 
the path of the Oracle bin directories to Oracle 8 or Oracle 7?

THANKS.

Jeff Hill
HRCM Consultant
CedarCrestone, Inc.

_______________________________________________
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