Re: Create an operator with returning a fixed length string

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 05 Jan 2004 22:12:42 -0800
Message-ID: <1073369475.285975@yasure>

Sybrand Bakker wrote:

> 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

Are you sure my friend?

SELECT CAST(object_name AS VARCHAR2(20)) OBJ_NAME FROM user_objects;

Sure looks like a VARCHAR2(20) to me.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Tue Jan 06 2004 - 00:12:42 CST