Hi…Does calling user defined functions in Oracle works as in stored procedures? How do I handle INOUT parameters in the JDBC adapter? Is it defined as an INPUT or OUTPUT field? Thanks…
You may try StoredProcedureWithSignature adapter service template. I don,t know everything in detail but this will serve your purpose.