[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    Fwd: General error; Invalid char position in string function
From:       Alexey Gaidukov <gaid () dc ! baikal ! ru>
Date:       2005-06-29 11:11:11
Message-ID: 42C281CF.2070807 () dc ! baikal ! ru
[Download RAW message or body]

I'm using MaxDB 7.6.00.10

["General error; Invalid char position in string function" (message/rfc822)]

Message-ID: <42C2704D.4080804@dc.baikal.ru>
Date: Wed, 29 Jun 2005 18:56:29 +0900
From: Alexey Gaidukov <gaid@dc.baikal.ru>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: ru-ru, ru
MIME-Version: 1.0
To:  maxdb@lists.mysql.com
Subject: General error; Invalid char position in string function
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 7bit

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?




-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]