arms - 12:55 pm on Oct 5, 2011 (gmt 0)

According to Mysql docs you may have to declare variable direction:

Create PROCEDURE Sp_InsertCountry
(
IN pcode char(3),
IN pname varchar(50),
IN paddress1 varchar(50),
IN paddress2 varchar(50),
IN pphone1 varchar(25),
IN pphone2 varchar(25),
IN pfaxno varchar(25),
IN plstno varchar(50),
IN pcstno varchar(25),
IN ptanno varchar(25),
IN pcity varchar(25),
IN pstate varchar(25),
IN pzip int,
IN pstatus varchar(1)
)
BEGIN
insert into company (code,name,address1,address2,phone1,phone2,faxno,tanno,lstno,cstno,city,state,zip,status)
values (pcode,pname,paddress1,paddress2,pphone1,pphone2,pfaxno,ptanno,plstno,pcstno,pcity,pstate,pzip,pstatus);
END
GO

other than that do the variables def match the columns def in the table?, that's the only other thing I can think of