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

Stored procedures should allow for better use of inout/out/return values

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 7.2
    • 7.1
    • Query Engine
    • None
    • Documentation (Ref Guide, User Guide, etc.), Release Notes

      Teiid stored procedure command or assignment statements do not typically make use of inout/out/return values (the exception is if a resultset is not returned). It would be better to allow variables to be used in inout/out positions to capture the out values.

      e.g. instead of

      call proc(1)

      just implicitly creating the result set to return,

      a = call proc(1, b)

      would also assign the return value to a and would set an out value to b.

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: