I've found the problem. In trigger for table 'gis.invest' I used local
variables without initialization.
http://lists.mysql.com/maxdb/25883
Alexey Gaidukov пишет:
drop DBPROC GIS.AddInvestComments
//
CREATE DBPROC GIS.AddInvestComments(
IN p_counter integer,
IN p_comments varchar(1000)) AS
BEGIN
TRY
UPDATE gis.invest set comments=:p_comments WHERE
counter=:p_counter;
CATCH
STOP($rc, $errmsg);
END;
//
call gis.AddInvestComments(2714748,'sfdfsdfsd')
---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-8 POS(1) Execution failed, parse again
call gis.AddInvestComments(2714748,'sfdfsdfsd')
What does it mean?
'UPDATE gis.invest set comments='sfdfsdfsd' WHERE counter=2714748'
works well.
CREATE TABLE "GIS"."INVEST"
(
"COUNTER" Integer NOT NULL,
"CARTNUM" Integer NOT NULL,
"MEDORDER" Integer NOT NULL,
"FINANSID" Smallint NOT NULL,
"POLSER" Varchar (15) UNICODE,
"POLNUM" Varchar (30) UNICODE,
"DOGNUM" Varchar (50) UNICODE,
"COMPANY" Smallint,
"DOCID" Varchar (10) UNICODE,
"RESID" Varchar (10) UNICODE NOT NULL,
"DATERES" Timestamp,
"CABID" Varchar (15) UNICODE,
"KUO" Fixed(3,2) NOT NULL,
"IDPRIHOD" Integer,
"IDRASHOD" Integer,
"DATE_TARIF" Date,
"COMMENTS" Varchar (1000) UNICODE,
"FACTRESID" Varchar (10) UNICODE,
"REASON" Varchar (100) UNICODE,
"KMU" Integer,
"KOORDINATOR_COMMENTS" Varchar (1000) UNICODE,
"DOCTORID" Varchar (10) UNICODE,
PRIMARY KEY ("COUNTER")
)
If change to
CREATE DBPROC GIS.AddInvestComments(
IN p_counter integer,
IN p_comments varchar(1000)) AS
BEGIN
TRY
UPDATE gis.invest set koordinator_comments=:p_comments WHERE
counter=:p_counter;
CATCH
STOP($rc, $errmsg);
END;
problem is go away. This bug I can't reproduce in other RESOURCE USER.
This error I get with JDBC and SQL Studio. MaxDB 7.6.00.10
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
