[teiid-issues] [JBoss JIRA] (TEIID-1386) Support exception handling in the procedures

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1386?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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