Hi!
I scanned now for hours this forum, but i didn't get an answer. I would like to call a stored procedure with return value with jdbc. Caused by default values in my stored procedure I have to use named parameters.
The Problem is how to register this return value correctly with jdbc.
OracleCallableStatement oracall = (OracleCallableStatement) con.prepareCall("? = call mytest1(?); end;");
oracall.setString("test1", "Test");
oracall.registerOutParameter(1,Types.INTEGER);
oracall.execute();
This didn't worked cause of mixed registration of parameters.
I tried now to bind the parameters, but this wasn't successful!
Has anyone a solution fot this problem? In all other threads the solutions didn't work fine or were inadequately.