Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4235

dynamic sql recursion check not valid after caught exception

    Details

      Description

      With a procedure like:

      begin
      execute immediate
      exception e
      ...
      execute immediate ...

      An exception on the second execute immediate will be seen like:

      org.teiid.api.exception.query.QueryProcessingException: TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE ..." due to: TEIID30347 There is a recursive invocation of group 'proc'. Please correct the SQL.

      Even when the dynamic sql does not re-invoke the proc. The issue is that when catching the initial exception thrown doesn't clear the entry from the recursion stack.

        Gliffy Diagrams

          Attachments

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                shawkins Steven Hawkins
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: