db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: Function calling a Procedure
Date Fri, 03 Oct 2014 18:04:03 GMT
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,

View raw message