Stored procedure definition syntax
CREATE PROCEDURE `addTicket` (in vipsql VARCHAR, in ordersql VARCHAR, in detailkey varchar, in detailsql VARCHAR) comment 'pending order (Drug Sale window)'
BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, NOT FOUND
Rollback
Start transaction
Set @ vid=@oid=''
Set @ outstr=''
Set @ errcode=200
Set @ errmsg=' succeeded'
If vipsql=0 then
Set @ tem=vipsql
Prepare tem from @ tem
Execute tem
Set @ rows=row_count ()
If @ rows
