Executing Oracle Stored Procedure failed with ORA-00900: invalid SQL statement

input {
   jdbc {
        jdbc_connection_string => "###"
        jdbc_user => "###"
        jdbc_password => "###"
        jdbc_driver_library => "/home/ojdbc6.jar"
        jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
        statement => "call skeleton(TIMESTAMP '2019-01-01 00:00:00')"

I've set above logstash config and it returns with error:

[2019-05-13T09:31:50,766][INFO ][logstash.agent           ] Successfully started Logstash API endpoint {:port=>9600}
[2019-05-13T09:31:52,779][INFO ][logstash.inputs.jdbc     ] (1.087859s) call skeleton(TIMESTAMP '2019-04-01 09:26:50.12')
[2019-05-13T09:31:52,817][WARN ][logstash.inputs.jdbc     ] Exception when executing JDBC query {:exception=>#<Sequel::DatabaseError: Java::JavaSql::SQLSyntaxErrorException: ORA-00900: invalid SQL statement

The stored procedure can be executed in Oracle SQL developer tool. Can anyone help with this issue?

The version of Logstash is 6.5.1

Did you try enclosing the query in {}? : "{call.....}"?

Yes, I've tried. Still got such error

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.