Hello,
I'm using MaxDb version 7.5.01.00.
I have a function TO_CHAR2 owned by user PPORTAL that receives a float and give me
back a char value.
The function is created like this in Oracle mode (the grant in Internal mode because
they don't work in oracle mode)
DROP FUNCTION TO_CHAR2
//
CREATE FUNCTION TO_CHAR2(VAL FLOAT) RETURNS VARCHAR AS
BEGIN
RETURN TO_CHAR(FLOOR(VAL));
END;
//
GRANT EXECUTE ON PPORTAL.TO_CHAR2 TO PSF
//
GRANT EXECUTE ON PPORTAL.TO_CHAR2 TO PPORTAL_PERMISSION
//
Calling it in this way
SELECT PPORTAL.TO_CHAR2(Max(TO_NUMBER(K_KEY) +1)) pluto FROM REGISTRY_TREE
the database crashes everytime.
Note that writing this (swapping the call of the TO_CHAR2 function with max),
SELECT Max(PPORTAL.TO_CHAR2(TO_NUMBER(K_KEY) +1)) pluto FROM REGISTRY_TREE
it doesn't happened (but the result isn't what I need).
In the database error log I've found only rows like this
2004-06-16 15:08:16 32057 ERR 54111 MOVE VAK05.4: 32768[32552]->1[8192000] len:0
What's wrong with it?
