Skip to Content
0

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

Jan 17 at 06:40 PM

53

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Evgeniy Kolmakov Jan 17 at 09:52 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left 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

0
Alejandro Pertierra Jan 18 at 12:19 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

And what happens if you put these statements as select query, not update?

Regards, Evgeniy.

0