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 -> Re: Oracle values in ref cursor being truncated after database upgrade

Re: Oracle values in ref cursor being truncated after database upgrade

From: <lisaashleyrafter_at_yahoo.com>
Date: 12 Jan 2006 08:20:10 -0800
Message-ID: <1137082809.969655.199030@g43g2000cwa.googlegroups.com> 





I've had a similar experience with ODBC and ref cursors.
Try doing a to_char on the number fields and wrapping a substr for
however much precision you need ie.


substr(to_char(numberfield), 0, 15) b/c to_char's with ref cursor's
sometimes give you the max size of a CLOB (which I think is
varchar2(4000) or something to that effect).
I don't know if you can change the datatype you return to Labview but
you could give it a shot.


HTH,



Lisa Ashley Rafter
Received on Thu Jan 12 2006 - 10:20:10 CST












Original text of this message













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