Greetings all.
My question is not strictly related to Spring's
JDBC but since this is what I use at the moment, here it comes..
I want to call an ORACLE stored procedure that has as second parameter a BOOLEAN parameter.
PROCEDURE run_job(job_name IN VARCHAR2,
use_current_session IN BOOLEAN DEFAULT TRUE);
I am calling it like this
My problem is a known one, ORACLE does not have a 'real' boolean type and so it simulates it with integers.
I tried registering "USE_CURRENT_SESSION" parameter as boolean, integer, tried with java.sql types, oracle.jdbc types - all for nothing.
I don't want to make a workaround for this, like wrapping the procedure. I want a correct, programmatic way of passing a boolean to a stored procedure.
If someone can help me with an idea I would be grateful.
Thank you