3

I am trying to write a PL/SQL block for calling a Java Stored procedure where the java method has a boolean as a paramter.

How can I translate the boolean when defining the package for the java procedure and invoking the java procedure from a PL/SQL block?

Somewhere I read that java boolean should be defined as a NUMBER in Oracle, so I tried that also but that did not work either.

Does anyone have an example of how to do this?

adbdkb
  • 1,897
  • 6
  • 37
  • 66

1 Answers1

3

This does not work, you will have to declare your java parameter as number instead of boolean and pass 1/0 for true /false. Alternatively use a char and some encoding that works for you.

Tommy Grovnes
  • 4,126
  • 2
  • 25
  • 40
  • not suppported by JDBC driver see https://docs.oracle.com/cd/B28359_01/java.111/b31224/apxtblsh.htm#i1005380 – Filip Jan 09 '19 at 16:02