Invalid use params in func INDEX

I use MaxDB Version: 7.6.00.16 Build 016-123-109-428 for LINUX

If I execute in "sql studio" procedure "SELECT 
PREFS.testIdx('obj1.prop1.prop2.prop4') FROM DUAL" result 5
If I execute in "sql studio" procedure "SELECT 
index('obj1.prop1.prop2.prop4', '.', 6, 1) FROM DUAL" result 11

//

DROP FUNCTION PREFS.testIdx
//
CREATE FUNCTION PREFS.testIdx
(
 ObjTitle CHAR(1000)
) RETURNS INT
AS
VAR
 str VARCHAR(1000);
 p SMALLINT;
 s INT;
BEGIN
 SET str = ObjTitle;
 SET p = 1;
 SET s = 2;
 RETURN index(str, '.', p, s);
END;

//

SELECT PREFS.testIdx('obj1.prop1.prop2.prop4') FROM DUAL

//
SELECT index('obj1.prop1.prop2.prop4', '.', 6, 1) FROM DUAL



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