Kalavera

create procedure xenical_xenical.sp_validar_usuario( as_usuario varchar(64), as_subseccion varchar(8) ) begin declare ls_tip_acc char(1); select 1; end|

mysql> create procedure sp_validar_usuario( as_usuario varchar(64), as_subseccion varchar(8) 
    -> begin
    -> declare ls_tip_acc char(1) 
    -> select 1
    -> end|
    -> 
    -> ;
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 'begin
declare ls_tip_acc char(1)
select 1
end|' at line 2
mysql> exit


mysql> create procedure sp_validar_usuario( as_usuario varchar(64), as_subseccion varchar(8) )                              
    -> begin
    -> declare ls_tip_acc char(1);
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 'char(1)' at line 3
mysql>