2 Replies Latest reply on Mar 14, 2013 3:43 PM by jane_lj

    Update procedure in Teiid Designer

    jane_lj Novice

      Hi,

       

      I'm writing update procedure in Teiid Designer 8.0, I gave this:

       

      CREATE VIRTUAL PROCEDURE

      BEGIN

      INSERT INTO Petrel_SM.PetrelBorehole (UWI) VALUES (INPUTS.uwi);

      END

       

      But got this error:

       

      ERROR: TEIID31119 Symbol INPUTS.uwi is specified with an unknown group context

       

       

       

       

      I got this syntax from this doc http://docs.jboss.org/teiid/7.0.0/reference/en-US/html_single/#d0e4885, but not working with version 8.0.

      1. How should I correct this procedure?

      2. Where can I find update procedure docs for version 8.0?

      Thanks a lot!