[ http://issues.apache.org/jira/browse/DERBY-1551?page=comments#action_12431671 ] Deepa Remesh commented on DERBY-1551: -------------------------------------
I think this change (svn revision 430925) missed the mega-merge. Can a committer please merge this doc change to 10.2 branch? > Update documentation to indicate procedures can be called from triggers > (DERBY-551) > ----------------------------------------------------------------------------------- > > Key: DERBY-1551 > URL: http://issues.apache.org/jira/browse/DERBY-1551 > Project: Derby > Issue Type: Task > Components: Documentation > Reporter: Deepa Remesh > Assigned To: Laura Stewart > Fix For: 10.3.0.0 > > Attachments: derby1551_ref.diff, derby1551_ref2.diff, > derby1551_ref_html.zip, derby1551_ref_html2.zip > > > Derby Reference manual has to be updated with following information: > * Section "CREATE TRIGGER statement" --> "Triggered-SQL-statement" > - The following line "It must not execute a CALL statement." needs to be > removed > - The following line "Before triggers cannot have INSERT, UPDATE or DELETE > statements as their action." needs to be replaced to indicate before triggers > also cannot call procedures that modify SQL data. It can be replaced with > something like ""Before triggers cannot have INSERT, UPDATE or DELETE > statements or calls to procedures that modify SQL data as their action." > * Section "SQLState and error message reference" > - Message text for X0Y69 has to be changed to "<value> is not supported in > trigger <triggerName>." > - An additional row to be added for 42Z9D with following message text > "Procedures that modify SQL data are not allowed in BEFORE triggers." > If there are any other places where the documentation needs to be updated for > DERBY-551, please post it to this issue. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
