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 ?
Search found 6 matches
- Mon Dec 06, 2021 1:26 pm
- Forum: JDBCR4
- Topic: Access oracle database via stored procedure
- Replies: 11
- Views: 81616
- Fri Dec 03, 2021 11:19 am
- Forum: JDBCR4
- Topic: Access oracle database via stored procedure
- Replies: 11
- Views: 81616
Re: Access oracle database via stored procedure
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 prog...
- Wed Dec 01, 2021 9:18 am
- Forum: JDBCR4
- Topic: Access oracle database via stored procedure
- Replies: 11
- Views: 81616
Re: Access oracle database via stored procedure
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.
- Mon Nov 29, 2021 1:21 pm
- Forum: JDBCR4
- Topic: Access oracle database via stored procedure
- Replies: 11
- Views: 81616
Re: Access oracle database via stored procedure
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...
- Mon Nov 22, 2021 9:07 am
- Forum: JDBCR4
- Topic: Access oracle database via stored procedure
- Replies: 11
- Views: 81616
Re: Access oracle database via stored procedure
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 additiona...
- Fri Nov 19, 2021 4:38 pm
- Forum: JDBCR4
- Topic: Access oracle database via stored procedure
- Replies: 11
- Views: 81616
Access oracle database via stored procedure
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 J...