MySQL Forums
Forum List  »  Newbie

Re: What's wrong with this insert?
Posted by: Paul Gayeski
Date: February 07, 2013 06:50PM

I'll keep trying - same problem only now with the additional problem of what's wrong with the set?
thanks
--------------------------------------------------------------

DELIMITER ;
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

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
February 07, 2013 12:14PM
Re: What's wrong with this insert?
February 07, 2013 06:50PM


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.