Re: [sqr-users] SQR 6.2 with Oracle 10g

[Kim Prisk <k.prisk@auckland.ac.nz>]

Ray/Ian,

Are you folks talking about

   1. using the Oracle 10g client with an earlier database
   2. using an earlier Oracle client but accessing a 10g database
   3. both 10g client and db?

We are using sqr6 against a 10g database and a 9i client.

I have had trouble with (and found work-arounds)

union select all - ('string to decimal object conversion errors') - 
ended up performing each select separately and merging the results into 
an array
had to use different names for the same variable if the variable is used 
more than once to fix 'ORA-01008: not all variables bound' errors
string to decimal conversion errors - had to use a nvl around some 
columns that did not require a nvl on an earlier database.

None of the above were a problem with a 9i database.
Not all of the above applies to all sqr reports we have where there are 
union selects etc.
Mostly the reports could be run from sqrw OK, but not as sqrt (compiled) 
where we got the errors.
which means they compiled OK

Cheers
KIM


Ian Mills wrote:
> Ray,
>
> We are having trouble using SQR 8.2 against Oracle 10Gr2. SQR 8.3 & 8.5 
>should work using the Oracle 10.2 ODBC driver. Hyperion doesn't support the 
>provided 3rd party connection software using SQR for Oracle.
>
> Regards,
> Ian
> ORIX Australia Corp Limited
>
>
>   
>>>> rayo@ontko.com 16/12/2006 8:32 am >>>
>>>>         
> Howdy,
>
> Does anyone happen to know if SQR 6.2 works with Oracle 10g?  If I want 
> to use the 10g SQLnet client, do I need to upgrade to a new version of 
> SQR? 8.3? 9.0?
>
> Ray

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