Re: 8.1.7 Bug ?

I have this working:

create or replace function d_r2(jrela in varchar2 default null) return varchar2
is
xml_ret varchar2(200);
begin
if jrela is not null then
xml_ret := 'NOT NULL' ;
else
xml_ret := 'NULL' ;
end if;
return xml_ret;
end d_r2;
/

damien.salvador_at_via.ecp.fr (Damien Salvador) wrote in message news:<slrn9ujhd5.lou.damien.salvador_at_zen.via.ecp.fr>...
> On 2 Nov 2001 16:23:25 GMT, Damien Salvador
> <damien.salvador_at_via.ecp.fr> a écrit:
> >
> >Hello,
> >we're moving from a 8.1.5 to a 8.1.7 on AIX.
> >We're using the base through a lot of stored functions which are returning
> >formated strings.
> >On 8.1.5 everything was running fine. On 8.1.7 we're encountering a
> >recurrent ORA-6502 error
>
> It seems it the same issue on 8.1.7 on NT, when using the same parameter
> several times.
>
> Apparently 8.1.7.2 fixes the issue (could not test it though, 'cause it's
> not possible to stop the database to apply the patch, risking to block
> everything, and eventually encountering other bugs :-) )
Received on Thu Nov 08 2001 - 11:18:09 CST