RE: [sqr-users] Migration SQR6/Oracle to SQR8/ODBC

["franck.masson" <franck.masson2002@laposte.net>]

I have already tested it, but get the same error message from datadirect 



> Message du 28/01/08 18:49
> De : "Rowell, Charles" 
> A : "This list is for discussion about the SQR database reportinglanguage 
>from  Hyperion Solutions." 
> Copie à : 
> Objet : RE: [sqr-users] Migration SQR6/Oracle to SQR8/ODBC
>
> Try this
> Begin-Select 
> nvl(adm.fct_prix('A01112Y01490','00V','DEUR','00V'),0) &toto1 
> from dual 
> end-select 
> 
> -----Original Message-----
> From: sqr-users-bounces+charles.rowell=fmr.com@sqrug.org 
>[mailto:sqr-users-bounces+charles.rowell=fmr.com@sqrug.org] On Behalf Of 
>franck.masson
> Sent: Monday, January 28, 2008 12:40 PM
> To: This list is for discussion about the SQR database reporting languagefrom 
>Hyperion Solutions.
> Subject: [sqr-users] Migration SQR6/Oracle to SQR8/ODBC
> 
> Hi,
> 
> We are in a process to migrate our reports from
> SQR 6/Oracle 8/Unix
> to
> SQR 8.5/ODBC/Windows
> 
> We are using the Oracle/ODBC driver delivred within SQR Server package ( 
>Datadirect)
> 
> This code work correctly in V6
> Begin-Select 
> adm.fct_prix('A01112Y01490','00V','DEUR','00V') &toto1 
> from dual 
> end-select 
> In V8.5 SP2 if the function return a Null value we got this error 
> [DataDirect] [ODBC Oracle Wire Protocol driver] [Oracle] ORA-01006: bind 
>variable does not exist
> 
> Is there any SQR.ini or ODBC setting that we have to define to avoid this 
> or 
> what should be the syntaxe to handle a function that may return a Null value 
> 
> Franck,
> 
> Créez votre adresse électronique prénom.nom@laposte.net 
> 1 Go d'espace de stockage, anti-spam et anti-virus intégrés.
> 
> _______________________________________________
> 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
> 
> 

 Créez votre adresse électronique prénom.nom@laposte.net 
 1 Go d'espace de stockage, anti-spam et anti-virus intégrés.

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