Stored Procedure Mapping for Insert using function
Posted: Thu 13 Jun 2013 10:33
Hello,
I am trying to map a function on my Oracle database to an insert stored procedure. I have found it works fine when it doesn't return anything but I need it to return some basic data. Since it's a function which returns a scalar value, I cannot bind the column to the property, since the column name can't be found in the results. Is there a way to bind a function result using this? Or will I need to use an out parameter?
Ken
I am trying to map a function on my Oracle database to an insert stored procedure. I have found it works fine when it doesn't return anything but I need it to return some basic data. Since it's a function which returns a scalar value, I cannot bind the column to the property, since the column name can't be found in the results. Is there a way to bind a function result using this? Or will I need to use an out parameter?
Ken