Search found 6 matches

by pada
Mon Dec 06, 2021 1:26 pm
Forum: JDBCR4
Topic: Access oracle database via stored procedure
Replies: 11
Views: 73103

Re: Access oracle database via stored procedure

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 ?
by pada
Fri Dec 03, 2021 11:19 am
Forum: JDBCR4
Topic: Access oracle database via stored procedure
Replies: 11
Views: 73103

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...
by pada
Wed Dec 01, 2021 9:18 am
Forum: JDBCR4
Topic: Access oracle database via stored procedure
Replies: 11
Views: 73103

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.
by pada
Mon Nov 29, 2021 1:21 pm
Forum: JDBCR4
Topic: Access oracle database via stored procedure
Replies: 11
Views: 73103

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...
by pada
Mon Nov 22, 2021 9:07 am
Forum: JDBCR4
Topic: Access oracle database via stored procedure
Replies: 11
Views: 73103

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...
by pada
Fri Nov 19, 2021 4:38 pm
Forum: JDBCR4
Topic: Access oracle database via stored procedure
Replies: 11
Views: 73103

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...