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

["Bob Stone" <bstone@fastenal.com>]

Yeah - it's an error within the PL Sql, not within SQR.

You should add something to your adm.fct_prix() function so that the return 
variable is never null.


-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org 
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of 
franck.masson
Sent: Monday, January 28, 2008 12:23 PM
To: This list is for discussion about the SQR database reporting language from 
Hyperion Solutions.
Subject: RE: [sqr-users] Migration SQR6/Oracle to SQR8/ODBC

 
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