You have an error in your SQl synatx!
Hi,
I am trying to create this stored proceedure on mysql but getting the following error:
[Err] 1064 - 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 'PROCEDURE sp_add_event_log
(
IN param_event_log_category varcha' at line 1
DROP PROCEDURE IF EXISTS `sp_add_event_log`;
CREATE OR REPLACE PROCEDURE sp_add_event_log
(
IN param_event_log_category varchar(255),
IN param_event_log_reference varchar(255),
IN param_event_log_user varchar(255),
IN param_event_log_machine_name varchar(255),
IN param_event_log_os_version varchar(255),
IN param_event_log_windows_user varchar(255),
IN param_event_log_windows_user_domain varchar(255),
IN param_event_log_processor_count int,
IN param_event_log_stack_trace text,
IN param_event_log_working_set int,
IN param_event_log_tick_count int,
IN param_event_log_current_culture varchar(255),
IN param_event_log_date_time_format varchar(255),
IN param_event_log_number_format varchar(255),
IN param_event_log_language_name varchar(255),
IN param_event_log_text text
)
BEGIN
INSERT INTO students
(
event_log_category,
event_log_reference,
event_log_user,
event_log_machine_name,
event_log_os_version,
event_log_windows_user,
event_log_windows_user_domain,
event_log_processor_count,
event_log_stack_trace,
event_log_working_set,
event_log_tick_count,
event_log_current_culture,
event_log_date_time_format,
event_log_number_format,
event_log_language_name,
event_log_text
)
VALUES
(
param_event_log_category,
param_event_log_reference,
param_event_log_user,
param_event_log_machine_name,
param_event_log_os_version,
param_event_log_windows_user,
param_event_log_windows_user_domain,
param_event_log_processor_count,
param_event_log_stack_trace,
param_event_log_working_set,
param_event_log_tick_count,
param_event_log_current_culture,
param_event_log_date_time_format,
param_event_log_number_format,
param_event_log_language_name,
param_event_log_text
) ;
END