11 Replies Latest reply on May 27, 2013 9:04 PM by Ramesh Reddy

    Teiid:Virtual Procedure Not working from Select query

    Manoj Dalei Newbie

      Hi,

       

      Rnning virtual proc using exec works, but does not work from select query.

       

      1. exec  "CompositeViewModel"."TestProc1"()   --Works

      2. select * from ( exec "CompositeViewModel"."TestProc1"() ) AS X     --- Does not work.

      17:49:13,201 WARN  [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue87) TEIID30020 Processing exception 'TEIID30492 Command must project at least one symbol' for request FmJW7EwI3MX5.0.  Exception type org.teiid.api.exception.query.QueryValidatorException thrown from org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:330)

       

      I have created procedure using Teiid Designer.

       

      CREATE VIRTUAL PROCEDURE

      BEGIN

      SELECT id FROM audit WHERE aid = 1;

      END

       

       

      I want to see all records as output.