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

Popular posts from this blog

css - Which browser returns the correct result for getBoundingClientRect of an SVG element? -

gcc - Calling fftR4() in c from assembly -

Function that returns a formatted array in VBA -