Re: Using BLOBs through ODBC

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 4 Oct 2001 19:16:30 +0200
Message-ID: <trp73ffg69kb35@news.demon.nl>

"Alexander" <abauer_at_gmx.net> wrote in message news:3bbc2de9$0$21926$6e365a64_at_newsreader02.highway.telekom.at...
> OK, Oracle ODBC. But how to access the LOB-Fields, how to insert and
> retrieve data?
>
> Any source for ASP, vbscript,ADO???
>
>
> Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> schrieb in im
> Newsbeitrag: 3bbc1c81$0$231$ed9e5944_at_reading.news.pipex.net...
> > Try getting hold of the latest Oracle ODBC drivers from Oracle. they do
> > support LOBs.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > "Alexander" <abauer_at_gmx.net> wrote in message
> > news:3bbbfdcd$0$35832$6e365a64_at_newsreader02.highway.telekom.at...
> > > Hi!
> > >
> > > I tried, but I could not access BLOBs and LONGRAW-fields via ODBC.
> > >
> > > I use ODBC-driver from Microsoft, VBScript (ASP), IIS, ADODB-Object.
> > >
> > > Can anyone send me a sample script for putting BLOBs into DB, or
getting
> > > them from the db?
> > >
> > > Regards
> > >
> > > Alexander
> > >
> > >
> >
> >
>
>

By using the Oracle provided dbms_lob pl/sql package

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Oct 04 2001 - 12:16:30 CDT