From: Jos? Luis on
hi
I have some trobles about runstoredprocedure.m function, i have an oracle database procedure that needs two data inputs and returns 2 data type outputs, one is a number and the other one a varchar2

when i run
x = runstoredprocedure(c, 'construirHistoricoRedes', {'01/01/2000', '02/01/2000'}, {java.sql.Types.NUMERIC, java.sql.Types.VARCHAR})

it reports

??? Java exception occurred:
java.sql.SQLException: General error

at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)

at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)

at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(Unknown Source)


Error in ==> database.runstoredprocedure at 75
csmt.executeUpdate;

any ideas about why? Thanks in advance
From: Oleg Komarov on
well, how did u set up your connection?
How did u get "c"?