Use DBexecute to execute an oracle function of package

CloverDX Platform
1

Hi,
I am using Clover designer v4.1 and trying to execute an oracle function using DBexceute

{ ${out_parameter}= call package_name.function_name(${in_parameter},${in_parameter})}

Here the input values are passed using internal parameters.

When i run the graph, the following error is thrown:
PLS-00221: ‘function_name’ is not a procedure or is undefined

Can you please help to solve this?

2

Hi

In the SQL query property of DBExecute you cannot use CloverETL parameters (${param}) directly. You have to use question mark (?) instead. You can provide the parameters via query input/output mapping. Alternatively, for some simple functions, you can use DBInputTable, where it is possible to use CloverETL parameters directly. However I wouldn’t recommend using DBInputTable for executing functions as it is designed solely to read data.

Attached is an example graph, where both solutions are shown.

Best regards