Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011

    Unanswered: How to create procedure?

    Hi all,

    This is my first post, hopefully this is where I should post ...
    I am trying to create a procedure with the create procedure command in the eclipse sql scrapbook.

    I get this error message :
    Remote org.teiid.api.exception.query.QueryParserException : Parsing error: Encountered "IN" at line 1

    My database type is "Ingres _2006"

    My sql statement is as follow:
    CREATE PROCEDURE GetAllDivision [IN @DivisionDesc int NOT NULL] AS
    select company_code
    from consol.fin_division
    where company_code = @DivisionDesc

    What have I done wrong ??

    Thanks in advance!


  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    probably best asking this question in the forum for the db you are using rather than the java forum. mind you it would also help if you say what db you are using...
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts