Function calling a Procedure

[Alessandro Manzoni <ma...@gmail.com>]

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.

Re: Function calling a Procedure

[Rick Hillegas <ri...@oracle.com>]

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