"ORA-01461: can bind a LONG value.." error during INSERT with abap exec

[patty_1982]

Hi,

I have a problem with sap ecc 6.0 with UNICODE.

I have:

DATA: BEGIN OF mytable OCCURS 0 ,

my_var(4000),

end OF mytable.

EXEC SQL.

INSERT INTO TABLE@IFSAP

(EVENT_CODE)

VALUES

(:TO_SINGLE_BYTE(:mytable-my_var))

ENDEXEC.

Help ME!

[Former Member]

ORA-01461: can bind a LONG value only for insert into a LONG column

You can not insert a value which is of length more than 4000 into a LONG column of a table. But, you can get fetch the LONG column from the table and store it into a variable of type LONG. That is why you are getting the error.

Hope this helps... !

[patty_1982]

Can't I convert mytable-my_var(4000)? The to_single_byte function returns a character value with all of the multibyte characters converted to single-byte characters. Why it does not work?

Thank you very much