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
begin
select company_code
from consol.fin_division
where company_code = @DivisionDesc
end;

What have I done wrong ??

Thanks in advance!

leeroy

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...