Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to force an oracle procedure to return an empty string?
I think Oracle treats zero length strings as NULL.
"Paul Fell" <novaweb_at_iinet.net.au> wrote in message
news:4b270a4e.0204161632.194123ab_at_posting.google.com...
> Oracle 9i.
>
> I'm using nvl(<field>,'') to return an empty string in a refcursor
> recordset, but this still returns a null value through the jdbc thin
> driver. Is it oracle or the driver? If it's oracle, is there a way of
> forcing the return of an empty string or can't oracle tell the
> difference?
>
> thanks
> Paul
Received on Tue Apr 16 2002 - 21:36:44 CDT