Error Message in SQR

[Michael Prodor <mprodor@QUALCOMM.COM>]

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