Execution of Oracle Functions using Database Connector module in Mendix

0
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  
asked
1 answers
1

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.

answered