Skip to Content
avatar image
Former Member

Data type for Oracle CLOB in ABAP

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 22, 2017 at 02:15 PM

    Hi

    Please check sap note

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

    if that helps here.

    Regards,

    Prithviraj

    Add comment
    10|10000 characters needed characters exceeded