Error creating store procedure in MariaDB

Navigation
0

I'm creating a procedure stored in Mysql

01 CREATE PROCEDURE prcGrabarLocationGPS (
02 _latitude DECIMAL (10,7),
03 _longitude DECIMAL (10,7),
04 _speed INT (10),
05 _direction INT (10),
06 _distance DECIMAL (10,1),
07 _date TIMESTAMP,
08 _locationMethod VARCHAR (50),
09 _userName VARCHAR (50),
10 _phoneNumber VARCHAR (50),
11 _sessionID VARCHAR (50),
12 _accuracy INT (10),
13 _extraInfo VARCHAR (255),
14 _eventType VARCHAR (50),
15 _imei VARCHAR (255),
16 _ VARCHAR number (255)
17)
18 BEGIN
19 INSERT INTO gpslocations (latitude, longitude, speed, direction, distance, gpsTime, locationMethod, userName, phoneNumber, sessionID, accuracy, extraInfo, eventType, imei, number)
20 VALUES (_latitude, _longitude, _speed, _direction, _distance, _date, _locationMethod, _userName, _phoneNumber, _sessionID, _accuracy, _extraInfo, _eventType, _imei, _number);
21 SELECT NOW ();
22 END

but it tells me an error

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 20

I can not see what is wrong.

    
asked by Max Cabanillas 29.09.2017 в 00:01
source

1 answer

0

Remember to use the DELIMITER command, see Delimiters : 

DELIMITER //

CREATE PROCEDURE prcGrabarLocationGPS (...)
BEGIN
...
END//

DELIMITER ;
    
answered by 07.10.2017 в 18:45
Count all the characters except a few Avoid booting tomcat Spring Boot