Execution of Oracle Functions using Database Connector module in Mendix

Hi,     I am trying to execute function in oracle using DatabaseConnector. The function has 6 IN parameter and it returns a value as NUMBER. Which activity I should use to get the return value?  Can you please guide me on this and provide any example how to do it?     Thanks  VIdula  
1 answers

I am able to solve it with 

Execute Parameterised Query activity.


We need to write sql to execute function as below


select package_name.function_name ({1},{2},{3}) as COLUMN_NAME from dual;

we need to create non-persistent entity with member name same as COLUMN_NANE (should be in Caps).


and pass parameters to query .


return type will be list of Entity.