Hi

In TOS 5.0.1, i've the same problem.

thanks for your help

I did it. I created an output 'result' as an Object.
I didn't add it on parameters table but after modifications I have the same error.

Hello!,
I've got a cursor which is returned by my Oracle function and I want to read all records of this cursor.
I use a t_OracleSP to call my function and I return an Object.
And my function looks like this :

FUNCTION ExtractArticle (v_org_id IN NUMBER, v_subinv_code IN VARCHAR2)
RETURN t_cursor AS

BEGIN
.......
END ExtractArticle;


But :

Exception in component tOracleSP_1
java.sql.SQLException: Type de colonne non valide: 1111
    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
    at oracle.jdbc.driver.OracleStatement.getInternalType(OracleStatement.java:3520)
    at oracle.jdbc.driver.OracleCallableStatement.registerOutParameterInternal(OracleCallableStatement.java:126)
    at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:287)
    at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:378)
    at oracle.jdbc.driver.OracleCallableStatementWrapper.registerOutParameter(OracleCallableStatementWrapper.java:1568)
    at cggv.cggv_mvl_runcall_0_1.CGGV_mvl_RunCall.tRowGenerator_1Process(CGGV_mvl_RunCall.java:1191)
    at cggv.cggv_mvl_runcall_0_1.CGGV_mvl_RunCall.tOracleConnection_1Process(CGGV_mvl_RunCall.java:238)
    at cggv.cggv_mvl_runcall_0_1.CGGV_mvl_RunCall.runJobInTOS(CGGV_mvl_RunCall.java:1601)
    at cggv.cggv_mvl_runcall_0_1.CGGV_mvl_RunCall.main(CGGV_mvl_RunCall.java:1514)


Can you help me !!