Ok, here's the deal. I've got a piece of java code that attempting to call some functions on a Oracle 8i database. I can call many of the functions with no problem. However when I try to call a function with a boolean argument I get the following exception.

java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GET_AVAIL_TRUNK'

I have tried using


I can get this to run fine using toad but for some reason cannot figure out why the jdbc call is not getting sent correctly. Has anyone done this before or know if it is not possible.

Thanks, Jay