Use DBexecute to execute an oracle function of package

clover_user3012

• January 26, 2016 00:00

• Answered

Follow

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?

• 

  Lukas Cholasta

  • February 04, 2016 11:55

  0

  Comment actions Permalink

  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

  • oracle_function_example.grf

Please sign in to leave a comment.