scottklement.com

I found the following information : it looks like JDBC support for Oracle boolean starts at version 12.2
"Starting in the 12.2 version of the JDBC-thin driver, there is native support for the PLSQL BOOLEAN type."
What do you think about ?

It also doesn't work, I get the following 2 errors when calling the package :
-------------------------------------------------------------------------------------------------------
Message . . . . : Java exception received when calling Java method.
Cause . . . . . : RPG procedure JDBC_EXECC in ...

Sorry but I have a compilation error :

2432 D PR ExtProc(*JAVA
2433 D :'java.sql.PreparedStatement'
2434 D :'setBoolean')
2435 D idx like(jInt) value
2436 D boolean 1n const
2437
*RNF3964 30 2436 033100 The VALUE keyword is required for this parameter type when
used in a method call.

The 4th and 5th parameters are set by respectively :
jdbc_RegisterOutParameter(stmt: 4 :12); 12 for varchar
jdbc_RegisterOutParameter(stmt: 5 :4); 4 for integer

It seems that there is a problem to pass a parameter of type "boolean" to the function since this type of variable does not exist as ...

Hello,

At the start of my original post, I give the following information :
"I have the following Oracle stored procedure :
PROCEDURE genereCodeExterne (num_log IN NUMBER, P_CLASSE IN NUMBER, ISSITEFRANCHISE IN BOOLEAN, P_CODE_RETOURNE OUT VARCHAR(13), P_RETOUR OUT NUMBER) "

What additional ...

Hello,
I have the following Oracle stored procedure :
PROCEDURE genereCodeExterne (num_log IN NUMBER, P_CLASSE IN NUMBER, ISSITEFRANCHISE IN BOOLEAN, P_CODE_RETOURNE OUT VARCHAR(13), P_RETOUR OUT NUMBER)
8 am unable to work with the boolean ISSITEFRANCHISE value, we try to value this variable with ...