-8 POS(1) Execution failed, parse again

[Alexey Gaidukov]

I had a DBPROC

CREATE DBPROC ARM.AddDopolnitRes(
   IN p_counter integer,
   IN p_resid varchar(10),
   IN p_counter_new integer,
   IN p_resid_new varchar(10)) AS
BEGIN
   TRY
       INSERT into gis.did_doc 
(counter,doctorid,resid,forma,did_date,did_time,smrid)
           select 
:p_counter_new,doctorid,:p_resid_new,true,date,time,smrid
               from gis.did_doc where counter=:p_counter and 
resid=:p_resid;
   CATCH
       STOP($rc, $errmsg);
END;
//
CALL ARM.AddDopolnitRes(2865812,'1В2001',2865828,'1В2002')
---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-8 POS(1) Execution failed, parse again



Recreation didn't help. I changed DBPROC and problem was solved. I can't 
reproduce the error message in a simple testcase



CREATE DBPROC ARM.AddDopolnitRes(
   IN p_counter integer,
   IN p_resid varchar(10),
   IN p_counter_new integer,
   IN p_resid_new varchar(10)) AS
VAR
   v_doctorid varchar(10);
   v_smrid varchar(10);
BEGIN
   TRY
       SELECT doctorid,smrid into :v_doctorid,:v_smrid
           from gis.did_doc where counter=:p_counter and resid=:p_resid;
       INSERT into gis.did_doc 
(counter,doctorid,resid,forma,did_date,did_time,smrid)
           VALUES 
(:p_counter_new,:v_doctorid,:p_resid_new,true,date,time,:v_smrid);
   CATCH
       STOP($rc, $errmsg);
END;



--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]