Hola:
Tengo este ejemplo de procedemiento:
Código SQL:
Ver originalCREATE PROCEDURE scopes()
DEFINE x,y,z INT;
LET x = 5;
LET y = 10;
LET z = x + y; --z is 15
BEGIN
DEFINE x, q INT;
DEFINE z CHAR(5);
LET x = 100;
LET q = x + y; -- q = 110
LET z = 'silly'; -- z receives a character value
END
LET y = x; -- y is now 5
LET x = z; -- z is now 15, not 'silly'
END PROCEDURE;
me da 12 errores siguientes:
Código SQL:
Ver original[Error Code: -201, SQL State: 42000] A syntax error has occurred.
quisiera saber por que?