Toad for MySQL - Community for development, administration, tuning, tips and tricks

Forums » General Discussion

Thread: Can't run the debugger : the generated procedure contains an SQL error

This question is not answered. Helpful answers available: 2. Answered answers available: 1.

Reply to this Thread

Search Forum

Back to Thread List

	Replies: 0 - Pages: 1	Threads: [ Previous \| Next ]

the_gillou_546

Posts: 1
Registered: 10/22/10

Can't run the debugger : the generated procedure contains an SQL error
Posted: Oct 22, 2010 8:30 AM

Hello,

I'am using Toad for MySQL 5.0 beta.
I want to debug ama procedure. The 2 databases for debugging are created (questdebug & questsoftware) with right tables and procedures. But I've got a SQL error when toad try to create the procedure for the debug (line 17).
It seems that the problem come from the questsoftware.DEBUGSET procedure.

Does anybody have a solution ?
Thanks in advance
Gilles

Here is the code of the procedure generated by toad :

CREATE PROCEDURE questdebug.b360e6ac0b08d3a404cf59dea66d1e5198bb363aimpl()
BEGIN

-- -------
-- Societe
-- -------

DECLARE id,id_responsable,id_categorie,id_actif,id_remise,factorable,nb_ex_facture INT;
DECLARE raison_sociale,enseigne,web VARCHAR(80);
DECLARE type_vente VARCHAR(20);
DECLARE commentaire TEXT;
DECLARE siren,factor_reference,commentaire_financier VARCHAR(200);
DECLARE factor_date_approbation,factor_date_expiration DATE;
DECLARE factor_encours DECIMAL(15, 2);

DECLARE done INT DEFAULT 0;
DECLARE CALL questsoftware.DEBUGSET('id','L',id);CALL questsoftware.DEBUGSET('id_responsable','L',id_responsable);CALL questsoftware.DEBUGSET('id_categorie','L',id_categorie);CALL questsoftware.DEBUGSET('id_actif','L',id_actif);CALL questsoftware.DEBUGSET('id_remise','L',id_remise);CALL questsoftware.DEBUGSET('factorable','L',factorable);CALL questsoftware.DEBUGSET('nb_ex_facture','L',nb_ex_facture);CALL questsoftware.DEBUGSET('raison_sociale','L',raison_sociale);CALL questsoftware.DEBUGSET('enseigne','L',enseigne);CALL questsoftware.DEBUGSET('web','L',web);CALL questsoftware.DEBUGSET('type_vente','L',type_vente);CALL questsoftware.DEBUGSET('commentaire','L',commentaire);CALL questsoftware.DEBUGSET('siren','L',siren);CALL questsoftware.DEBUGSET('factor_reference','L',factor_reference);CALL questsoftware.DEBUGSET('commentaire_financier','L',commentaire_financier);CALL questsoftware.DEBUGSET('factor_date_approbation','L',factor_date_approbation);CALL questsoftware.DEBUGSET('factor_date_expiration','L',factor_date_expiration);CALL questsoftware.DEBUGSET('factor_encours','L',factor_encours);CALL questsoftware.DEBUGSET('done','L',done);CALL questsoftware.DEBUGTRACE('PROCEDURE','sara','import',17);c_societe CURSOR FOR
SELECT `sara-avuer`.a_societe.id, id_responsable, raison_sociale, enseigne, web, id_categorie, id_actif, id_remise,
CASE id_type_comptabilisation WHEN 1 THEN 'france'
WHEN 2 THEN 'ue'
WHEN 3 THEN 'export'
END AS type_vente,
commentaire, SIREN.le_texte AS siren, DATEAPPO.la_date AS factor_date_approbation, DATEEXPIR.la_date AS factor_date_expiration,
ENCOURS.la_somme AS factor_encours, REFFACTO.le_texte AS factor_reference,
IF(FACTORABLE.le_texte='VA_O',1,0) AS factorable, COMMENTAIRE.le_texte AS commentaire_financier, NEXEMPL.le_nombre AS nb_ex_facture
FROM `sara-avuer`.a_societe
left join `sara-avuer`.a_dossier as SIREN on SIREN.id_regle=14 and SIREN.id_fiche = `sara-avuer`.a_societe.id
left join `sara-avuer`.a_dossier as TVAINTER on TVAINTER.id_regle=19 and TVAINTER.id_fiche = `sara-avuer`.a_societe.id
left join `sara-avuer`.a_dossier as DATEAPPO on DATEAPPO.id_regle=31 and DATEAPPO.id_fiche = `sara-avuer`.a_societe.id
left join `sara-avuer`.a_dossier as DATEEXPIR on DATEEXPIR.id_regle=91 and DATEEXPIR.id_fiche = `sara-avuer`.a_societe.id
left join `sara-avuer`.a_dossier as REFFACTO on REFFACTO.id_regle=16 and REFFACTO.id_fiche = `sara-avuer`.a_societe.id
left join `sara-avuer`.a_dossier as ENCOURS on ENCOURS.id_regle=32 and ENCOURS.id_fiche = `sara-avuer`.a_societe.id
left join `sara-avuer`.a_dossier as FACTORABLE on FACTORABLE.id_regle=30 and FACTORABLE.id_fiche = `sara-avuer`.a_societe.id
left join `sara-avuer`.a_dossier as COMMENTAIRE on COMMENTAIRE.id_regle=141 and COMMENTAIRE.id_fiche = `sara-avuer`.a_societe.id
left join `sara-avuer`.a_dossier as MODE on MODE.id_regle=5 and MODE.id_fiche = `sara-avuer`.a_societe.id
left join `sara-avuer`.a_dossier as BANQUE on BANQUE.id_regle=148 and BANQUE.id_fiche = `sara-avuer`.a_societe.id
left join `sara-avuer`.a_dossier as NEXEMPL on NEXEMPL.id_regle=18 and NEXEMPL.id_fiche = `sara-avuer`.a_societe.id;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;

CALL questsoftware.DEBUGSET('id','L',id);CALL questsoftware.DEBUGSET('id_responsable','L',id_responsable);CALL questsoftware.DEBUGSET('id_categorie','L',id_categorie);CALL questsoftware.DEBUGSET('id_actif','L',id_actif);CALL questsoftware.DEBUGSET('id_remise','L',id_remise);CALL questsoftware.DEBUGSET('factorable','L',factorable);CALL questsoftware.DEBUGSET('nb_ex_facture','L',nb_ex_facture);CALL questsoftware.DEBUGSET('raison_sociale','L',raison_sociale);CALL questsoftware.DEBUGSET('enseigne','L',enseigne);CALL questsoftware.DEBUGSET('web','L',web);CALL questsoftware.DEBUGSET('type_vente','L',type_vente);CALL questsoftware.DEBUGSET('commentaire','L',commentaire);CALL questsoftware.DEBUGSET('siren','L',siren);CALL questsoftware.DEBUGSET('factor_reference','L',factor_reference);CALL questsoftware.DEBUGSET('commentaire_financier','L',commentaire_financier);CALL questsoftware.DEBUGSET('factor_date_approbation','L',factor_date_approbation);CALL questsoftware.DEBUGSET('factor_date_expiration','L',factor_date_expiration);CALL questsoftware.DEBUGSET('factor_encours','L',factor_encours);CALL questsoftware.DEBUGSET('done','L',done);CALL questsoftware.DEBUGTRACE('PROCEDURE','sara','import',40);OPEN c_societe;

CALL questsoftware.DEBUGSET('id','L',id);CALL questsoftware.DEBUGSET('id_responsable','L',id_responsable);CALL questsoftware.DEBUGSET('id_categorie','L',id_categorie);CALL questsoftware.DEBUGSET('id_actif','L',id_actif);CALL questsoftware.DEBUGSET('id_remise','L',id_remise);CALL questsoftware.DEBUGSET('factorable','L',factorable);CALL questsoftware.DEBUGSET('nb_ex_facture','L',nb_ex_facture);CALL questsoftware.DEBUGSET('raison_sociale','L',raison_sociale);CALL questsoftware.DEBUGSET('enseigne','L',enseigne);CALL questsoftware.DEBUGSET('web','L',web);CALL questsoftware.DEBUGSET('type_vente','L',type_vente);CALL questsoftware.DEBUGSET('commentaire','L',commentaire);CALL questsoftware.DEBUGSET('siren','L',siren);CALL questsoftware.DEBUGSET('factor_reference','L',factor_reference);CALL questsoftware.DEBUGSET('commentaire_financier','L',commentaire_financier);CALL questsoftware.DEBUGSET('factor_date_approbation','L',factor_date_approbation);CALL questsoftware.DEBUGSET('factor_date_expiration','L',factor_date_expiration);CALL questsoftware.DEBUGSET('factor_encours','L',factor_encours);CALL questsoftware.DEBUGSET('done','L',done);CALL questsoftware.DEBUGTRACE('PROCEDURE','sara','import',42);read_loop: LOOP
    CALL questsoftware.DEBUGSET('id','L',id);CALL questsoftware.DEBUGSET('id_responsable','L',id_responsable);CALL questsoftware.DEBUGSET('id_categorie','L',id_categorie);CALL questsoftware.DEBUGSET('id_actif','L',id_actif);CALL questsoftware.DEBUGSET('id_remise','L',id_remise);CALL questsoftware.DEBUGSET('factorable','L',factorable);CALL questsoftware.DEBUGSET('nb_ex_facture','L',nb_ex_facture);CALL questsoftware.DEBUGSET('raison_sociale','L',raison_sociale);CALL questsoftware.DEBUGSET('enseigne','L',enseigne);CALL questsoftware.DEBUGSET('web','L',web);CALL questsoftware.DEBUGSET('type_vente','L',type_vente);CALL questsoftware.DEBUGSET('commentaire','L',commentaire);CALL questsoftware.DEBUGSET('siren','L',siren);CALL questsoftware.DEBUGSET('factor_reference','L',factor_reference);CALL questsoftware.DEBUGSET('commentaire_financier','L',commentaire_financier);CALL questsoftware.DEBUGSET('factor_date_approbation','L',factor_date_approbation);CALL questsoftware.DEBUGSET('factor_date_expiration','L',factor_date_expiration);CALL questsoftware.DEBUGSET('factor_encours','L',factor_encours);CALL questsoftware.DEBUGSET('done','L',done);CALL questsoftware.DEBUGTRACE('PROCEDURE','sara','import',43);FETCH c_societe INTO id, id_responsable, raison_sociale, enseigne, web, id_categorie, id_actif, id_remise, type_vente, commentaire,
        siren, factor_date_approbation, factor_date_expiration, factor_encours, factor_reference, factorable, commentaire_financier,
        nb_ex_facture;
    CALL questsoftware.DEBUGSET('id','L',id);CALL questsoftware.DEBUGSET('id_responsable','L',id_responsable);CALL questsoftware.DEBUGSET('id_categorie','L',id_categorie);CALL questsoftware.DEBUGSET('id_actif','L',id_actif);CALL questsoftware.DEBUGSET('id_remise','L',id_remise);CALL questsoftware.DEBUGSET('factorable','L',factorable);CALL questsoftware.DEBUGSET('nb_ex_facture','L',nb_ex_facture);CALL questsoftware.DEBUGSET('raison_sociale','L',raison_sociale);CALL questsoftware.DEBUGSET('enseigne','L',enseigne);CALL questsoftware.DEBUGSET('web','L',web);CALL questsoftware.DEBUGSET('type_vente','L',type_vente);CALL questsoftware.DEBUGSET('commentaire','L',commentaire);CALL questsoftware.DEBUGSET('siren','L',siren);CALL questsoftware.DEBUGSET('factor_reference','L',factor_reference);CALL questsoftware.DEBUGSET('commentaire_financier','L',commentaire_financier);CALL questsoftware.DEBUGSET('factor_date_approbation','L',factor_date_approbation);CALL questsoftware.DEBUGSET('factor_date_expiration','L',factor_date_expiration);CALL questsoftware.DEBUGSET('factor_encours','L',factor_encours);CALL questsoftware.DEBUGSET('done','L',done);CALL questsoftware.DEBUGTRACE('PROCEDURE','sara','import',46);IF done THEN
        CALL questsoftware.DEBUGSET('id','L',id);CALL questsoftware.DEBUGSET('id_responsable','L',id_responsable);CALL questsoftware.DEBUGSET('id_categorie','L',id_categorie);CALL questsoftware.DEBUGSET('id_actif','L',id_actif);CALL questsoftware.DEBUGSET('id_remise','L',id_remise);CALL questsoftware.DEBUGSET('factorable','L',factorable);CALL questsoftware.DEBUGSET('nb_ex_facture','L',nb_ex_facture);CALL questsoftware.DEBUGSET('raison_sociale','L',raison_sociale);CALL questsoftware.DEBUGSET('enseigne','L',enseigne);CALL questsoftware.DEBUGSET('web','L',web);CALL questsoftware.DEBUGSET('type_vente','L',type_vente);CALL questsoftware.DEBUGSET('commentaire','L',commentaire);CALL questsoftware.DEBUGSET('siren','L',siren);CALL questsoftware.DEBUGSET('factor_reference','L',factor_reference);CALL questsoftware.DEBUGSET('commentaire_financier','L',commentaire_financier);CALL questsoftware.DEBUGSET('factor_date_approbation','L',factor_date_approbation);CALL questsoftware.DEBUGSET('factor_date_expiration','L',factor_date_expiration);CALL questsoftware.DEBUGSET('factor_encours','L',factor_encours);CALL questsoftware.DEBUGSET('done','L',done);CALL questsoftware.DEBUGTRACE('PROCEDURE','sara','import',47);LEAVE read_loop;
    CALL questsoftware.DEBUGSET('id','L',id);CALL questsoftware.DEBUGSET('id_responsable','L',id_responsable);CALL questsoftware.DEBUGSET('id_categorie','L',id_categorie);CALL questsoftware.DEBUGSET('id_actif','L',id_actif);CALL questsoftware.DEBUGSET('id_remise','L',id_remise);CALL questsoftware.DEBUGSET('factorable','L',factorable);CALL questsoftware.DEBUGSET('nb_ex_facture','L',nb_ex_facture);CALL questsoftware.DEBUGSET('raison_sociale','L',raison_sociale);CALL questsoftware.DEBUGSET('enseigne','L',enseigne);CALL questsoftware.DEBUGSET('web','L',web);CALL questsoftware.DEBUGSET('type_vente','L',type_vente);CALL questsoftware.DEBUGSET('commentaire','L',commentaire);CALL questsoftware.DEBUGSET('siren','L',siren);CALL questsoftware.DEBUGSET('factor_reference','L',factor_reference);CALL questsoftware.DEBUGSET('commentaire_financier','L',commentaire_financier);CALL questsoftware.DEBUGSET('factor_date_approbation','L',factor_date_approbation);CALL questsoftware.DEBUGSET('factor_date_expiration','L',factor_date_expiration);CALL questsoftware.DEBUGSET('factor_encours','L',factor_encours);CALL questsoftware.DEBUGSET('done','L',done);CALL questsoftware.DEBUGTRACE('PROCEDURE','sara','import',48);END IF;

    CALL questsoftware.DEBUGSET('id','L',id);CALL questsoftware.DEBUGSET('id_responsable','L',id_responsable);CALL questsoftware.DEBUGSET('id_categorie','L',id_categorie);CALL questsoftware.DEBUGSET('id_actif','L',id_actif);CALL questsoftware.DEBUGSET('id_remise','L',id_remise);CALL questsoftware.DEBUGSET('factorable','L',factorable);CALL questsoftware.DEBUGSET('nb_ex_facture','L',nb_ex_facture);CALL questsoftware.DEBUGSET('raison_sociale','L',raison_sociale);CALL questsoftware.DEBUGSET('enseigne','L',enseigne);CALL questsoftware.DEBUGSET('web','L',web);CALL questsoftware.DEBUGSET('type_vente','L',type_vente);CALL questsoftware.DEBUGSET('commentaire','L',commentaire);CALL questsoftware.DEBUGSET('siren','L',siren);CALL questsoftware.DEBUGSET('factor_reference','L',factor_reference);CALL questsoftware.DEBUGSET('commentaire_financier','L',commentaire_financier);CALL questsoftware.DEBUGSET('factor_date_approbation','L',factor_date_approbation);CALL questsoftware.DEBUGSET('factor_date_expiration','L',factor_date_expiration);CALL questsoftware.DEBUGSET('factor_encours','L',factor_encours);CALL questsoftware.DEBUGSET('done','L',done);CALL questsoftware.DEBUGTRACE('PROCEDURE','sara','import',50);INSERT INTO sara.societe (id, gestionnaire, nom, enseigne, site_web, qualite_id, tarif_id, remise_id, type_vente,
        commentaire, siren, factor_date_approbation, factor_date_expiration,
        factor_encours, factor_reference, factorable, commentaire_financier, nb_ex_facture,
        created_at, updated_at, created_by, updated_by)
        VALUES (id, id_responsable, raison_sociale, enseigne, web, id_categorie, id_actif, id_remise, type_vente,
        commentaire, siren, factor_date_approbation, factor_date_expiration,
        factor_encours, factor_reference, factorable, commentaire_financier, nb_ex_facture,
        '2010-09-30','2010-09-30','admin', 'admin');

CALL questsoftware.DEBUGSET('id','L',id);CALL questsoftware.DEBUGSET('id_responsable','L',id_responsable);CALL questsoftware.DEBUGSET('id_categorie','L',id_categorie);CALL questsoftware.DEBUGSET('id_actif','L',id_actif);CALL questsoftware.DEBUGSET('id_remise','L',id_remise);CALL questsoftware.DEBUGSET('factorable','L',factorable);CALL questsoftware.DEBUGSET('nb_ex_facture','L',nb_ex_facture);CALL questsoftware.DEBUGSET('raison_sociale','L',raison_sociale);CALL questsoftware.DEBUGSET('enseigne','L',enseigne);CALL questsoftware.DEBUGSET('web','L',web);CALL questsoftware.DEBUGSET('type_vente','L',type_vente);CALL questsoftware.DEBUGSET('commentaire','L',commentaire);CALL questsoftware.DEBUGSET('siren','L',siren);CALL questsoftware.DEBUGSET('factor_reference','L',factor_reference);CALL questsoftware.DEBUGSET('commentaire_financier','L',commentaire_financier);CALL questsoftware.DEBUGSET('factor_date_approbation','L',factor_date_approbation);CALL questsoftware.DEBUGSET('factor_date_expiration','L',factor_date_expiration);CALL questsoftware.DEBUGSET('factor_encours','L',factor_encours);CALL questsoftware.DEBUGSET('done','L',done);CALL questsoftware.DEBUGTRACE('PROCEDURE','sara','import',59);END LOOP;

CALL questsoftware.DEBUGSET('id','L',id);CALL questsoftware.DEBUGSET('id_responsable','L',id_responsable);CALL questsoftware.DEBUGSET('id_categorie','L',id_categorie);CALL questsoftware.DEBUGSET('id_actif','L',id_actif);CALL questsoftware.DEBUGSET('id_remise','L',id_remise);CALL questsoftware.DEBUGSET('factorable','L',factorable);CALL questsoftware.DEBUGSET('nb_ex_facture','L',nb_ex_facture);CALL questsoftware.DEBUGSET('raison_sociale','L',raison_sociale);CALL questsoftware.DEBUGSET('enseigne','L',enseigne);CALL questsoftware.DEBUGSET('web','L',web);CALL questsoftware.DEBUGSET('type_vente','L',type_vente);CALL questsoftware.DEBUGSET('commentaire','L',commentaire);CALL questsoftware.DEBUGSET('siren','L',siren);CALL questsoftware.DEBUGSET('factor_reference','L',factor_reference);CALL questsoftware.DEBUGSET('commentaire_financier','L',commentaire_financier);CALL questsoftware.DEBUGSET('factor_date_approbation','L',factor_date_approbation);CALL questsoftware.DEBUGSET('factor_date_expiration','L',factor_date_expiration);CALL questsoftware.DEBUGSET('factor_encours','L',factor_encours);CALL questsoftware.DEBUGSET('done','L',done);CALL questsoftware.DEBUGTRACE('PROCEDURE','sara','import',61);CLOSE c_societe;

CALL questsoftware.DEBUGSET('id','L',id);CALL questsoftware.DEBUGSET('id_responsable','L',id_responsable);CALL questsoftware.DEBUGSET('id_categorie','L',id_categorie);CALL questsoftware.DEBUGSET('id_actif','L',id_actif);CALL questsoftware.DEBUGSET('id_remise','L',id_remise);CALL questsoftware.DEBUGSET('factorable','L',factorable);CALL questsoftware.DEBUGSET('nb_ex_facture','L',nb_ex_facture);CALL questsoftware.DEBUGSET('raison_sociale','L',raison_sociale);CALL questsoftware.DEBUGSET('enseigne','L',enseigne);CALL questsoftware.DEBUGSET('web','L',web);CALL questsoftware.DEBUGSET('type_vente','L',type_vente);CALL questsoftware.DEBUGSET('commentaire','L',commentaire);CALL questsoftware.DEBUGSET('siren','L',siren);CALL questsoftware.DEBUGSET('factor_reference','L',factor_reference);CALL questsoftware.DEBUGSET('commentaire_financier','L',commentaire_financier);CALL questsoftware.DEBUGSET('factor_date_approbation','L',factor_date_approbation);CALL questsoftware.DEBUGSET('factor_date_expiration','L',factor_date_expiration);CALL questsoftware.DEBUGSET('factor_encours','L',factor_encours);CALL questsoftware.DEBUGSET('done','L',done);CALL questsoftware.DEBUGTRACE('PROCEDURE','sara','import',65);END;

Message was edited by: the_gillou_546

Pages: 1

Back to Thread List

Threads: [ Previous | Next ]

Legend
	Guru: 2001 + pts
	Expert: 751 - 2000 pts
	Enthusiast: 31 - 750 pts
	Novice: 0 - 30 pts
	Moderators
	Helpful answer (5 pts)
	Answered (10 pts)

Toad World

Downloads

Welcome, Guest