Create an operator with returning a fixed length string

Hello there,

I am using Oracle 9i on Windows 2000 Server. I need to create an operator to return a string with length 20.

If I use the following statement:
CREATE OPERATOR test ....
RETURN VARCHAR2....
...

the return string has a default length 4000.

Does any one know to make the return string length 20?

thanks a lot.

Frank Received on Mon Jan 05 2004 - 22:27:43 CST