MySQL Forums
Forum List  »  Newbie

What's wrong with this insert?
Posted by: Paul Gayeski
Date: February 07, 2013 12:14PM

So what is wrong with my simple Insert? I've tried to record it with the phpadmin and the mysqlworkbench and both don't like the way it end? "Unexpected end of input" expect ';' where the closing ) is?
thanks
--------------------------------------------------------------------
CREATE PROCEDURE `aspLogEntry` (
in p_le_let_id tinyint(1),
in p_le_msg varchar(2000),
in p_le_subject varchar(250),
in p_le_ipAddress varchar(150),
in p_le_host varchar(50),
in p_le_referrer varchar(150),
in p_le_UserAgent varchar(150),
in p_le_IsBot tinyint(1)
)

BEGIN
/* IF le_IsBot = null THEN
// set le_IsBot = 0;
//END IF; */
insert into tblLogEntry (
le_let_id,
le_msg,
le_subject,
le_ipAddress,
le_host,
le_referrer,
le_UserAgent,
le_IsBot
)
VALUES (
p_le_let_id,
p_le_msg,
p_le_subject,
p_le_ipAddress,
p_le_host,
p_le_referrer,
p_le_UserAgent,
p_le_IsBot
);

END
-----------------------------------------------------------------

Options: ReplyQuote


Subject
Written By
Posted
What's wrong with this insert?
February 07, 2013 12:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.