# Use DBexecute to execute an oracle function of package

**URL:** <https://forum.cloverdx.com/t/use-dbexecute-to-execute-an-oracle-function-of-package/1712>\
**Category:** CloverDX Platform\
**Created:** [January 26, 2016, 12:00am UTC](https://forum.cloverdx.com/t/use-dbexecute-to-execute-an-oracle-function-of-package/1712 "2016-01-26T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![clover\_user3012](https://avatars.discourse-cdn.com/v4/letter/c/c0e974/32.png) [@clover\_user3012](https://forum.cloverdx.com/u/clover_user3012)\
**Post date:** [January 26, 2016, 12:00am UTC](https://forum.cloverdx.com/t/use-dbexecute-to-execute-an-oracle-function-of-package/1712/1 "2016-01-26T00:00:00Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Lukas\_Cholasta](https://yyz1.discourse-cdn.com/flex007/user_avatar/forum.cloverdx.com/lukas_cholasta/32/166_2.png) [@Lukas\_Cholasta](https://forum.cloverdx.com/u/Lukas_Cholasta)\
**Post date:** [February 4, 2016, 11:55am UTC](https://forum.cloverdx.com/t/use-dbexecute-to-execute-an-oracle-function-of-package/1712/2 "2016-02-04T11:55:28Z")

</div>

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](https://cdn.cloverdx.com/forum/18108%5Faae38e4558410712aa4a7415d452e987/oracle%5Ffunction%5Fexample.grf)