Re: Error Message in SQR

[Jerry Coleman <colemanj@WASHPOST.COM>]

I wonder if there could be another binary value that's not being captured
in your replace statements.  Maybe isblank() would capture it.  You might
also inspect the data with an editor in hex mode.





                    Michael Prodor
                    <mprodor@QUALC        To:     SQR-USERS@list.iex.net
                    OMM.COM>              cc:
                    Sent by:              Subject:     Error Message in SQR
                    "Discussion of
                    SQR, Brio
                    Technology's
                    database
                    reporting
                    language"
                    <SQR-USERS@lis
                    t.iex.net>


                    07/07/00 12:38
                    PM
                    Please respond
                    to sqr-users






Hello SQRers. I am getting an error message in an SQR when I try to insert
a char value into a table.

The table column that causes the problem is defined as Varchar2(47) and the
data I am trying to place into it is a string.

Here is the error message:

(SQR 5528) ORACLE OEXEC error -1461 in cursor 3:
   ORA-01461: can bind a LONG value only for insert into a LONG column

Error on line 94:
   (SQR 3735) Could not execute SQL.


Here is the statement:

    94        begin-sql
    95        insert into qc_acc_cf values (
    96  !Add name and replace funky values  - MLP
    97  !               nvl($nmc_acct_id,0) ,NULL, nvl
($nmc_srvc_provider,0),
    98                 nvl($nmc_acct_id,0),replace(replace(replace(rtrim
($nmc_name),chr(9),''),chr(10),''),chr(13),''),
    99                 nvl($nmc_srvc_provider,0), $region, $state
,to_number(nvl($super_acct,0)) , $clean_yymm )
   100       end-sql
   101        show (10, 2 ) 'Record: ' #rec_count
   102            !--  nvl($nmc_name,' ')
   103    end-if


and  here is the data that causes the problem (obviously not a long):

SECURITY CONSULTANTS GRP1 (SYS4)

Finally, here is the statement where we assign a value to the variable
(from a read buffer):

let $nmc_name = ltrim( rtrim( substr( $readbuf, 14,43),' '),' ')

The statement works fine when I insert NULL. Initially I was receiving the
error and I thought it was due to embedded tabs / returns, so I am using
the REPLACE statement on the value.


Any help would be greatly appreciated.


--
Michael Prodor
<mprodor@qualcomm.com>

Qualcomm - QWBS Info Systems