I am trying to return multiple values from a Function, not sure if it is
allowed:
 
delimiter |
create function cf_test()
returns integer, varchar(255)    /* tried with semicolon after
varchar(255)   */
 
begin
   declare p_col2 smallint;
   declare p_col3 varchar(255);
 
   select col2, col3
     into p_col2, p_col3
     from test
    where col1 = 1;
 
   return p_col1, p_col2;
 
end
|
 
and i get the following error when i am trying to create this function:
 
source test5.sql
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near ' varchar(255);
begin
   declare p_col2 smallint;
   declare p_col3 varch' at line 2
 
Any advice would be greatly appreciated.
 
Thanks
 
Dinesh

Reply via email to