Fwd: General error; Invalid char position in string function

[Alexey Gaidukov]

I'm using MaxDB 7.6.00.10

--- Begin Message ---

CREATE DBPROC test(IN p varchar) AS
BEGIN
   INSERT INTO table(field)
   VALUES (substr(:p,3,1));
END;


Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-3046 POS(319) Invalid char position in string function



CREATE DBPROC test(IN p varchar) AS
VAR
   pp varchar(10);
BEGIN
   SET pp = p;
   INSERT INTO table(field)
   VALUES (substr(:pp,3,1));
END;

Compiles well. Is check of length of VARCHAR in compile time in this situation correct?

--- End Message ---

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