On 10/3/14 9:08 AM, Alessandro Manzoni wrote:
I created an udf (defined as contains sql) and a procedure (defined as
modifies sql data).
The function eventually calls the procedure, but its get an exception
that says that the function attempted to change data but is not
defined as modifies sql data.
Derby reference states that a derby function cannot be defined with
modify sql data.
Is there any way to permit the function executing registered
procedures even if they change data?
Thank you for any information.
Hi Alessandro,
I believe that this limitation protects the correctness of query results
when a query invokes a function. You could log an enhancement request. I
don't know of a way around this limitation at this time.
Hope this helps,
-Rick
