0

I use MySQL-Front tool create and call Stored Procedure successfully, but in my PHP code and phpMyAdmin it fails. How can i figure out this problem

when i run on phpMyAdmin the error show
#1305 - PROCEDURE joomla1.5.9.save_orders does not exist

this is my code of procedure

DROP PROCEDURE `save_orders`//
CREATE DEFINER=`root`@`localhost` PROCEDURE `save_orders`(
INOUT id int,
id_order varchar(10),
customercode varchar(10),
date_order varchar(10),
date_deliverly varchar(10)
)
DETERMINISTIC
SQL SECURITY INVOKER
BEGIN
IF id=0 THEN
INSERT INTO `vhc_orders` (
`id` , `id_order` ,
`customercode` , `date_order` ,
`date_deliverly` , `meet` ,
`base` , `notefromdale` ,
`jobmade` , `date_jobmade` ,
`datestart` , `timestart` ,
`dateback` , `timeback` ,
`realgo` , `srcprovince` ,
`desreal` , `no_tl` ,
`userid`
)
VALUES (
NULL , id_order,
customercode , date_order,
date_deliverly , NULL ,
NULL , NULL ,
0, NULL ,
NULL , NULL ,
NULL , NULL ,
NULL , NULL ,
NULL , NULL ,
NULL
);
SET id = LAST_INSERT_ID();

END IF;


END
2
Contributors
1
Reply
2
Views
8 Years
Discussion Span
Last Post by pritaeas
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.