Error Native SQL with Unicode

[Former Member]

Hi people,

I have problem with upgrade ECC 5.0 (non-unicode) to ECC 6.0 (Unicode). The following command is not working in ECC 6.0 :

DATA: BEGIN OF wa_unicode,

codlot(6) type i,

codsis(2) type c,

datger(4) type c,

desint(40) type c,

desref(50) type c,

usuger(15) type c,

usupro(6) type c,

datpro(4) type c,

horpro(3) type c,

stalot(1) type c,

END OF wa_unicode.

********

EXEC SQL.

INSERT INTO R800ILT (CODSIS, CODLOT, DATGER, DESINT, DESREF, USUGER, USUPRO, DATPRO, STALOT)

VALUES

('RON',

:wa_unicode-codlot,

:wa_unicode-datger,

:wa_unicode-desint,

:wa_unicode-desref,

:wa_unicode-usuger,

:wa_unicode-usupro,

:wa_unicode-datpro, 1)

ENDEXEC.

The value of field wa_unicode-desint is 'INTERFACE SAP HR X RONDA ACESSO', but when save in Oracle the value is 'INTERFACE SAP HR', don't save the value completely. The structure table of Oracle is the same of wa_unicode.

But, I insert the value is work

INSERT INTO R800ILT (CODSIS, CODLOT, DATGER, DESINT, DESREF, USUGER, USUPRO, DATPRO, STALOT)

VALUES

('RON',

:wa_unicode-codlot,

:wa_unicode-datger,

'INTERFACE SAP HR X RONDA ACESSO'

:wa_unicode-desref,

:wa_unicode-usuger,

:wa_unicode-usupro,

:wa_unicode-datpro, 1)

Do you know about this problem?

Thanks.

[Former Member]

Well, it doesn't really look like a unicode problem.

Have you verified by debugging that wa_unicode-desint actuall holds the correct value?

Rob

[Former Member]

Hi Rob, By debugging that wa_unicode-desint is with value correct, but in the table of the Oracle only is save one part value.

The strange thing is that the Internal Table SAP e database Oracle have the same structure.