Stored Procedure error

Dears,

I'm new at Tibco Bussinseworks , and I hope that you help me with this problem.

I have call Store procedure activity to excute a stored produre with input parameters (X number , actionId number) and the output parameters are (Z number , A number , B Number , C Cursor) and the output of the stored procedure depends on the action ID , I mean not in all cases the cursor is opend and has values.

So I'm getting the error in case of the cursor hasn't any values or opened "JDBC error reported: (SQLState = null) - java.sql.SQLException: Cursor is closed." BW-JDBC-100014 ,

I suggested to the DBA in case of the cursor isn't used to fill it with 0 or any String. but I know it isn't logic to open the cursor when it isn't used.

you can find the Stack trace below.

JDBC error reported: (SQLState = null) - java.sql.SQLException: Cursor is closed." at com.tibco.plugin.jdbc.JDBCActivity.eval(JDBCActivity.java:1172) at com.tibco.pe.plugin.Activity.eval(Activity.java:209) at com.tibco.pe.core.TaskImpl.eval(TaskImpl.java:541) at com.tibco.pe.core.Job.a(Job.java:709) at com.tibco.pe.core.Job.k(Job.java:499) at com.tibco.pe.core.JobDispatcher$JobCourier.a(JobDispatcher.java:249) at com.tibco.pe.core.JobDispatcher$JobCourier.run(JobDispatcher.java:200) caused by: java.sql.SQLException: Cursor is closed. at oracle.jdbc.driver.T4CResultSetAccessor.getCursor(T4CResultSetAccessor.java:322) at oracle.jdbc.driver.ResultSetAccessor.getObject(ResultSetAccessor.java:84) at oracle.jdbc.driver.OracleCallableStatement.getObject(OracleCallableStatement.java:1526) at com.tibco.plugin.jdbc.JDBCCallActivity.evalCall(JDBCCallActivity.java:718) at com.tibco.plugin.jdbc.JDBCCallActivity.performDatabaseOperation(JDBCCallActivity.java:540) at com.tibco.plugin.jdbc.JDBCActivity.eval(JDBCActivity.java:1052) at com.tibco.pe.plugin.Activity.eval(Activity.java:209) at com.tibco.pe.core.TaskImpl.eval(TaskImpl.java:541) at com.tibco.pe.core.Job.a(Job.java:709) at com.tibco.pe.core.Job.k(Job.java:499) at com.tibco.pe.core.JobDispatcher$JobCourier.a(JobDispatcher.java:249) at com.tibco.pe.core.JobDispatcher$JobCourier.run(JobDispatcher.java:200)

(3) Answers

Login