Error Native SQL with Unicode

Former Member — Fri, 24 Sep 2010 15:18:40 GMT

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.

Re: Error Native SQL with Unicode

Former Member — Fri, 24 Sep 2010 16:01:42 GMT

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

Re: Error Native SQL with Unicode

Former Member — Mon, 27 Sep 2010 13:28:43 GMT

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.

topic Re: Error Native SQL with Unicode in Application Development and Automation Discussions

Error Native SQL with Unicode

Re: Error Native SQL with Unicode

Re: Error Native SQL with Unicode