Skip to Content
0

Data type for Oracle CLOB in ABAP

Aug 22, 2017 at 12:51 PM

47

avatar image
Former Member

I have a requirement to pass long XML input to the below sample oracle stored procedure,

CREATE OR REPLACE PROCEDURE procedure_name(long_xml IN CLOB)
 IS
BEGIN

END;

here is the call from ABAP

  EXEC SQL.
    execute procedure procedure_name(IN :long_xml )
  ENDEXEC. 

long_xml holds more than 20000 character, I have defined long_xml as:

data: long_xml  type string.
data: long_xml(32000).

but both are not working, the procedure call ends with CX_SY_NO_HANDLER, CX_SY_NATIVE_SQL_ERROR exception, the same question have been asked before on Data type for Oracle 8 CLOB in ABAP? but the answer were not provided there,

here i have attached the exception log:

Regards.

untitled.png (60.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Prithviraj Rajpurohit Aug 22, 2017 at 02:15 PM
1

Hi

Please check sap note

https://launchpad.support.sap.com/#/notes/1846516

if that helps here.

Regards,

Prithviraj

Share
10 |10000 characters needed characters left characters exceeded