I am trying to use the following options to call an Oracle function from IS 10.1.
- Using Custom SQL.
- Calling it using StoredProcedure Template
But my problem is that the Oracle Function has more than 100 input parameters.
Though i don’t need to map all of those parameters. I still need to define them as inputs in the adapter service. Is there any alternative to it?
How are we supposed to define a BOOLEAN parameter as input ?