You can't get a boolean value from a pl/SQL function using Java. If you have a function that returns a boolean and you register the output parameter in Java as OracleTypes.BOOLEAN. Well the darn thing will throw a 'Invalid collum type' exception.
How the heck can you release a software for accessing your database if you know you can't access some type of variables (boolean is not the only one...).
After some googling, the only solution I could find was to write a wrapper pl/SQL function that returns a integer instead of a boolean.
How the heck can you release a software for accessing your database if you know you can't access some type of variables (boolean is not the only one...).
After some googling, the only solution I could find was to write a wrapper pl/SQL function that returns a integer instead of a boolean.
Avtor: Anonymous, objavljeno na portalu SloDug.si (Arhiv)