Knut Anders Hatlen <
Knut.Hatlen@...> writes:
> Bryan Pendleton <
bpendleton@...> writes:
>
>> As part of
https://issues.apache.org/jira/browse/DERBY-3062 I'm trying
>> to clarify the doc regarding the behavior of the
>>
>> { NO SQL | MODIFIES SQL DATA | CONTAINS SQL | READS SQL DATA }
>>
>> clause. I've cleaned the text up somewhat, and will post a patch shortly,
>> but some of the text seems to imply that there exist certain SQL
>> statements which simply can't be executed from a procedure, no matter
>> what level of SQL support is asserted by the above clause:
>>
>> MODIFIES SQL DATA
>> Indicates that the stored procedure can execute any SQL statement
>> except statements that are not supported in stored procedures.
>>
>> I tried looking around in code and tests (particularly LangProceduresTest)
>> but wasn't able to figure out a conclusive answer:
>>
>> Are there any SQL statements that are illegal in a procedure which
>> specifies MODIFIES SQL DATA?
>
> I'm vaguely remembering exceptions being thrown either by setting the
> schema or the isolation level from within a procedure. I'll have to
> check to be sure.
Sorry, I confused this with another issue I had seen. SET SCHEMA and SET
ISOLATION work fine in a procedure. What doesn't work, is
Connection.setAutoCommit(true), but since we don't have any SQL
statement for that operation, that doesn't really answer your question.
--
Knut Anders
