select - SQL Anywhere Syntax error near @ -
i working in asa 11 store procedures. example:
create procedure "dba"."pa_select_employ"( @cod nvarchar(10), @name nvarchar(15) output) begin select @name=name_employ employ //the line 6 cod_employ=@cod end
send variable @cod , need result @name output
can't save shows message:
the procedure 'xxx' not modified in database. syntax error near '@name' on line 6 [sybase][odbc driver][sql anywhere]syntax error near '@name' on line 6 sqlcode: -131 sqlstate: 42000
in interactive sql select ok.
declare @name varchar(15) select @name=name_employ employ cod_employ='333333'
please me find syntax error? (i speak spanish.)
try changing procedure definition to:
create procedure "dba"."pa_select_employ"( in @cod nvarchar(10), out @name nvarchar(15)) begin select @name=name_employ employ //the line 6 cod_employ=@cod end
Comments
Post a Comment