Re: Create an operator with returning a fixed length string

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1073532874.570433_at_yasure>...
> Frank Y wrote:
>
> > dmx_frank_at_yahoo.com (Frank Y) wrote in message news:<9d599275.0401052027.495c4690_at_posting.google.com>...
> >
> >>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
> >
> >
> > The reason I ask this because I need to create an operator to build a
> > domain index. And this operator is used in a View. When my
> > application accesss this view, an buffer overflow was occured because
> > the return length of the operater is 4000. I cannot change the
> > application source code because I donot own it. The only way I can
> > think is to limit the output size of the operator, that is why I ask
> > this question.
> >
> > Any one can have ideas to help me?
> >
> > Frank.
>
> I posted the solution once. Wasn't that enough?
>
> SELECT CAST(object_name AS VARCHAR2(20)) OBJ_NAME
> FROM user_objects;
>
> http://www.psoug.org/reference/cast.html

I have tried the CAST , it works for if the object is a function, but it doesnot work for the object which is Operator. It give me the following error:
ORA-24328: illegal attribute value

Any other idea?

Frank Received on Fri Jan 09 2004 - 05:20:34 CST