Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Difference between "SELECT *" and "SELECT COLUMN1, ..., COLUMNN"
It is an oracle 'feature'. What you might consider doing is looking at using
8i and modifying the datatype of the column to an appropriate LOB type BLOB
for binary data, CLOB for Character streams. There is an oracle supplied
package DBMS_LOB which is documented in the 8i documentation (and handy
dandy examples given in Jonathan Lewis's book) which is usable via ADO.
HTH
-- Niall Litchfield Oracle DBA Audit Commission UK "Brian Ross" <brian.ross_at_home.com> wrote in message news:7X8j7.17876$Z2.229375_at_nnrp1.uunet.ca...Received on Thu Aug 30 2001 - 02:40:10 CDT
> > The LONG is the problem..
> > I think that ,because here is no way to determine the size of the LONG ,
> any attempt to retrieve something AFTER the LONG
> > will fail, because the parser won't know when the LONG ends and the next
> field begins..
>
> Is this something because of Oracle? or is this because of how I have my
> connection configured in ADO/ODBC? Is there anywhere I can find some sort
of
> document explaining the relevant issues?
>
> Thanks
>
>
>