Hello All,
I would like to execute a pl/sql function which contains bind variables. The pl/sql Function will return one varchar value.
I have the list of bind variables and associated values. So that i can create a MapSqlParameterSource object in java and pass it as parameter while calling a executing a function.
Currently i am using SimpleJdbcCall in spring to execute the pl/sql function.
Pl sql function sample is here.
I am getting exception like:
UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [{? = call SQL_FUNCTION1()}]; SQL state [99999]; error code [17041]; Missing IN or OUT parameter at index:: 1
Any help!!
Thanks,
Raj