Re: Create an operator with returning a fixed length string

On 5 Jan 2004 20:27:43 -0800, dmx_frank_at_yahoo.com (Frank Y) wrote:

>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

Not possible (and not important, as the 4000 only specifies the maximum length)

--
Sybrand Bakker, Senior Oracle DBA