Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> how to force an oracle procedure to return an empty string?

how to force an oracle procedure to return an empty string?

From: Paul Fell <novaweb_at_iinet.net.au>
Date: 16 Apr 2002 17:32:41 -0700
Message-ID: <4b270a4e.0204161632.194123ab@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 - 19:32:41 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US