Re: Function returnning string > 2000 bytes???
From: Marcel Claus <Marcel.Claus_at_Informatik.Uni-Oldenburg.DE>
Date: Wed, 10 Jun 1998 16:27:15 +0100
Message-ID: <6lm52v$mud_at_news.Informatik.Uni-Oldenburg.DE>
Date: Wed, 10 Jun 1998 16:27:15 +0100
Message-ID: <6lm52v$mud_at_news.Informatik.Uni-Oldenburg.DE>
Joep Hendrix wrote:
> Imagine the following query:
>
> select function_name
> from dual;
>
> The function function_name might return a string larger then 2000 bytes.
> Does anybody know a work around? BTW buying Oracle 8 is not an option.
>
> Thanks in advance!!!
>
> Joep
Use Reports or Forms. A declaration like
the_str varchar2(30000)
is no problem.
With a DB-stored-proc: no chance. You can only try to convert to long
or something like that, but I dont know if this is supported by functions.
A tip: Buy Oracle 8 ;)
We did and it works...
Marcel Received on Wed Jun 10 1998 - 17:27:15 CEST