Database

Quote:

[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