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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Returning Oracle Columns > 4000 Chars

Re: Returning Oracle Columns > 4000 Chars

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Tue, 11 Dec 2001 17:55:49 GMT
Message-ID: <FMrR7.33148$ER5.378873@rwcrnsc52>


The restriction in the MS drivers is due to MS. You will have to ask MS if they are going to support LOB.
Oracle has deprecated the long datatype. They might at some time in the future discontinue it. They have ceased all enhancements to it. Use lob instead.
Jim

"Alan Pollard" <alanpollard_at_yahoo.com> wrote in message news:e76e292f.0112110633.1ac992a2_at_posting.google.com...
> We run Oracle 8i (soon going to 9i) and interface to a Microsoft
> client application through ADO (ADO -> OLEDB for ODBC -> Microsoft
> ODBC Driver for Oracle).
>
> My main question is whether if there is a way to return columns (or
> stored procedure out params) that are > 4000 characters (but not
> datatype LONG) using the MS OBDC driver for Oracle ?
>
> I'm aware of the following:
> 1) the MS ODBC driver currently supports VARCHAR2 and LONG, but none
> of the LOB datatypes
> 2) VARCHAR2 columns cannot be defined as > 4000, although in PL/SQL
> VARCHAR2 variables can be up to 32767
> 3) we currently use the rowset functionality provided by the MS ODBC
> driver, so have been unable to use the MS OLE DB driver for Oracle
> (not that that's really applicable).
>
> I also have some of 'sub-questions':
> a) is the restriction in the MS drivers due to underlying Net8
> restrictions ?
> b) anyone have any idea if Microsoft is ever likely to support the LOB
> datatypes ? Or support returning PL/SQL VARCHAR2 parameters > 4000 ?
> c) I've heard a rumour that Oracle will discontinue support of the
> LONG datatype...is this true ?
Received on Tue Dec 11 2001 - 11:55:49 CST

Original text of this message

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