Skip to Content

JDBC sender adapter - Execute stored procedure in Update SQL Statement parameter

hi folk,

Is it posible to execute an stored procedured from sender jdbc adapter under

Update SQL Statement parameter?

based on the link below

https://help.sap.com/saphelp_nw73/helpdata/en/7E/5DF96381EC72468A00815DD80F8B63/frameset.htm

the only alternative is define a SQL statement type INSERT, UPDATE, or DELETE statement.

regards

Rodrigo

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 17 at 09:52 PM

    Hi Alejandro!

    According to the document you've provided, you can use EXEC SQL statement as query string to execute stored procedure containing one SELECT statement. In such case you should use <TEST> as update query string.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

    • As far as I understand it is posible, but when i set the value: execute <stored procedure name>

      the channel ended with error:

      Database-level error reported by JDBC driver while executing statement 'EXECUTE opessa.actualizar_articulos_2bmc'. The JDBC driver returned the following error message: 'java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement '. For details, contact your database server vendor.

      ------------------------------------------------------------------------------------

      In case the execute command is not being used the error obtained is the next one:

      Database-level error reported by JDBC driver while executing statement 'actualizar_articulos_2bmc'. The JDBC driver returned the following error message: 'java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement
      '. For details, contact your database server vendor

      Best Regards

  • Jan 18 at 12:19 PM

    as far as I know it is posible,

    but when i set the Update query like:

    EXECUTE opessa.actualizar_articulos_2bmc

    I get the next error:

    Database-level error reported by JDBC driver while executing statement 'EXECUTE opessa.actualizar_articulos_2bmc'. The JDBC driver returned the following error message: 'java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement
    '. For details, contact your database server vendor

    ---------------------------------------------------------------------------------------------------------

    now if I define the next value for Update Query(without execute command) just the SP name

    opessa.actualizar_articulos_2bmc

    I get the next error:

    Database-level error reported by JDBC driver while executing statement 'opessa.actualizar_articulos_2bmc'. The JDBC driver returned the following error message: 'java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement
    '. For details, contact your database server vendor

    best regards

    Add comment
    10|10000 characters needed characters exceeded