Stored Procedure : java.sql.SQLSyntaxErrorException: ORA-00900: No valid SQL statement

1
0
-1

The connector is my code ( oracle database 11g ); where it is called a StoredProcedure , which account number is entered and this brings me the balance, my code entered in the wizard:

import groovy.sql.*; def sql = BonitaSql.newInstance("jdbc:oracle:thin:@...", "user", "password", new oracle.jdbc.driver.OracleDriver()); def mont = 0.00; def rs = sql.call("{ call SP_SLD_DISP(?,?) }", [4011101621,Sql.out(Sql.DECIMAL.type)]) { sald -> mont = sald; } sql.close(); return mont.toString();

Execute returns: java.sql.SQLSyntaxErrorException: ORA-00900: No valid SQL statement The log :

10/02/2015 09:33:58 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log GRAVE: THREAD_ID=1330 | HOSTNAME=P_Javier | TENANT_ID=1 | The work [ExecuteConnectorOfActivity: flowNodeInstanceId = 4, connectorDefinitionName = PRB2] failed. The failure will be handled. 10/02/2015 09:33:58 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log GRAVE: THREAD_ID=1330 | HOSTNAME=P_Javier | TENANT_ID=1 | org.bonitasoft.engine.core.connector.exception.SConnectorException : "PROCESS_DEFINITION_ID=8597959316215215780 | PROCESS_NAME=Gestión Solicitud | PROCESS_VERSION=1.0 | PROCESS_INSTANCE_ID=2 | ROOT_PROCESS_INSTANCE_ID=2 | FLOW_NODE_DEFINITION_ID=-8472458160073252901 | FLOW_NODE_INSTANCE_ID=4 | FLOW_NODE_NAME=Traer Información | CONNECTOR_DEFINITION_IMPLEMENTATION_CLASS_NAME=PRUEBA2 | CONNECTOR_INSTANCE_ID=2 | org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.sql.SQLSyntaxErrorException: ORA-00900: sentencia SQL no válida " org.bonitasoft.engine.core.connector.exception.SConnectorException: PROCESS_DEFINITION_ID=8597959316215215780 | PROCESS_NAME=Gestión Solicitud | PROCESS_VERSION=1.0 | PROCESS_INSTANCE_ID=2 | ROOT_PROCESS_INSTANCE_ID=2 | FLOW_NODE_DEFINITION_ID=-8472458160073252901 | FLOW_NODE_INSTANCE_ID=4 | FLOW_NODE_NAME=Traer Información | CONNECTOR_DEFINITION_IMPLEMENTATION_CLASS_NAME=PRUEBA2 | CONNECTOR_INSTANCE_ID=2 | org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.sql.SQLSyntaxErrorException: ORA-00900: No valid SQL statement

at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnectorInClassloader(ConnectorServiceImpl.java:332)
at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnector(ConnectorServiceImpl.java:150)
at org.bonitasoft.engine.connector.ConnectorServiceDecorator.executeConnector(ConnectorServiceDecorator.java:111)
at org.bonitasoft.engine.execution.work.ExecuteConnectorWork.work(ExecuteConnectorWork.java:125)
at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42)
at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42)
at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42)
at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42)
at org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork.work(FailureHandlingBonitaWork.java:70)
at org.bonitasoft.engine.work.BonitaWork.run(BonitaWork.java:56)
at org.bonitasoft.engine.work.SequenceRunnableExecutor.innerRun(SequenceRunnableExecutor.java:47)
at org.bonitasoft.engine.work.BonitaRunnable.run(BonitaRunnable.java:35)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)

Caused by: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.sql.SQLSyntaxErrorException: ORA-00900: No valid SQL statement

at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.execute(ConnectorExecutorImpl.java:119)
at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnectorInClassloader(ConnectorServiceImpl.java:324)
... 14 more

Caused by: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.sql.SQLSyntaxErrorException: ORA-00900: No valid SQL statement

at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
at java.util.concurrent.FutureTask.get(FutureTask.java:83)
at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.getValue(ConnectorExecutorImpl.java:143)
at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.execute(ConnectorExecutorImpl.java:113)
... 15 more

Caused by: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.sql.SQLSyntaxErrorException: ORA-00900: No valid SQL statement

at org.bonitasoft.engine.core.connector.impl.SConnectorAdapter.execute(SConnectorAdapter.java:72)
at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:188)
at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:170)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
... 3 more

Caused by: org.bonitasoft.engine.connector.ConnectorException: java.sql.SQLSyntaxErrorException: ORA-00900: No valid SQL statement

at org.bonitasoft.connectors.database.Database.executeCommand(Database.java:77)
at org.bonitasoft.connectors.database.jdbc.JdbcConnector.executeSingleQuery(JdbcConnector.java:188)
at org.bonitasoft.connectors.database.jdbc.JdbcConnector.execute(JdbcConnector.java:94)
at org.bonitasoft.engine.core.connector.impl.SConnectorAdapter.execute(SConnectorAdapter.java:70)
... 7 more

Caused by: java.sql.SQLSyntaxErrorException: ORA-00900: No valid SQL statement

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4680)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4825)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1913)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
at org.bonitasoft.connectors.database.Database.executeCommand(Database.java:75)
... 10 more

10/02/2015 09:34:30 PM org.apache.catalina.core.ApplicationDispatcher doForward FINA: Disabling the response for futher output

the code entered in the wizard solution resultset.next(); resultset.getObject(0);

assigned to a string variable

someone help me

No answers yet.
Notifications