[teiid-issues] [JBoss JIRA] (TEIID-1386) Support exception handling in the procedures
[
https://issues.jboss.org/browse/TEIID-1386?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1386.
-----------------------------------
Resolution: Done
added support for exception handling as outlined in the previous comment. Our syntax is
Teiid specific as ANSI PSM and PL/SQL had syntax and concepts that were not desirable.
Between the work done for this issue and TEIID-2226 we are ready to support named cursors
in procedures, so that we can allow them to be passed from one procedure to another.
Support exception handling in the procedures
--------------------------------------------
Key: TEIID-1386
URL: https://issues.jboss.org/browse/TEIID-1386
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.2
Reporter: Ramesh Reddy
Assignee: Steven Hawkins
Priority: Critical
Fix For: 8.2
Currently the in Teiid procedure language there is no exception handling logic. For
example if a INSERT fails due to unique key constraint, there is no way to catch that and
do some other operation. Currently the procedure will exit the procedure will error.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira