Skip to Content
0
Jan 19, 2012 at 06:38 PM

EXEC SQL with SELECT long field

75 Views

HI

I have a external oracle table with a type LONG field. I read this table with dblink.

I declared my sap variable type STRING:

DATA v_test TYPE STRING.

EXEC SQL.

SELECT test_long

into :v_test

FROM srvweb.test@mag

where id_name = '0'

ENDEXEC.

Test_long is 39000 characters for example, but my variable v_test is truncated (32000 characters)!

Why? How can I resolve this problem? I can't use TYPE C because it support only from 1 to 65535 characters.

Thank you