[DERBY-551] Allow invoking java stored procedures from inside a trigger. Make CALL a valid statement in the trigger body.

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.1.0
• Fix Version/s: 10.2.1.6
• Component/s: SQL
• Environment: All platforms
• Assignee: Deepa
• Reporter: Satheesh E. Bandaram
• Created: 02/Sep/05 08:44
• Updated: 01/Jul/09 00:34
• Resolved: 27/Jul/06 21:53

Description

Derby currently doesn't allow CALL statement to be used in a trigger body. It would be great to allow java stored procedure invocation inside a trigger. Since Derby doesn't have SQL procedure language, triggers can only execute a single SQL statement. If we allow stored procedures in triggers, it would be possible to write a trigger that involves more than just one SQL statement. Functions are currently allowed, but they are read-only.

I believe it is fairly easy to support this enhancement. Need good amount of testing though.

Issue Links

• incorporates: DERBY-1551 Update documentation to indicate procedures can be called from triggers (DERBY-551)
• relates to: DERBY-1729 Invoking Java stored procedure that contains GRANT or REVOKE statement with CONTAINS SQL should fail.