4 Replies Latest reply on Feb 18, 2014 9:40 AM by Sanjeev Gour

    Running anonymous procedure blocks from JDBC Client

    Sanjeev Gour Novice

      Hello-

       

      Looking at the syntax to execute anonymous procedure blocks given here DML Commands - Teiid 8.6 - Project Documentation Editor, I tried the following from the SQuirrel SQL client-

       

      begin insert into actions.rule_state values(now(), 'p','o','match'); end;

       

      It results in the following error-

       

      Error: Remote org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered ",'match')[*]" at line 1, column 67.

      Was expecting: "except" | "fetch" | "intersect" | "limit" | "offset" | "option" | "order" | "union" | "with" | "without" ...

      SQLState:  50000

      ErrorCode: 0

      Error occured in:

      begin insert into actions.rule_state values(now(), 'p','o','match')

       

      Am I doing something fundamental wrong?