Re: VW7.3 Long RAW --> BLOB in Oracle9i

Steve A <stevea@xxxxxxxxxx> wrote:
> maarten wrote:
> > Hi,
> >
> > Does anyone know a way around using BLOB data instead of LONG RAW with
> > Oracle 9.2 and VW 7.3 ?
> >
> > I am using the lens to get through to Oracle but BLOB or CBLOB is not
> > provided here ?
>
> We've been experiencing a similar problem with VisualAge. We had a guess
> that all the long types are probably the same in how they are stored and
> the types are only used as switches for Oracle behaviour. Like many ST
> apps we only use the database as a data store and don't use other
> database facilities for any data processing.
>
> I can't confirm that all longs are stored the same but we've been
> happily mapping CLOB and other long types unknown to VA into the VA
> Oracle long raw class and have had no problems.
I can confirm this - as long as you use the OCI functions with
fixed-size buffers and stay below 32KByte, blob can be treated just like
long raw.
However, accessing *really* long data using the mechanisms provided in
the ORACLE 8 OCI is not yet supported by the VAST database interface.
Don't know whether VW has support for that.

Cheers,
Hans-Martin
.

Relevant Pages

  • Re: VW --> Bianary file into CLOB or BLOB
    ... In fact the remaining poblem I have is not in transferring the BLOB to the database as I manage this on both PostgreSQL, Oracle and ODBC following the documentation. ...
    (comp.lang.smalltalk)
  • Re: DBI and DBD issues with Accessing BLOB
    ... DBD-Oracle Oracle database driver for the DBI module ... The data that is in the blob is zipped/compressed XML data. ... > server is at least an 8.1.7 database, but you've not posted your versions ...
    (perl.dbi.users)
  • Re: VW7.3 Long RAW --> BLOB in Oracle9i
    ... The Oracle EXDI classes in VW 7.3 support the BLOB OCI calls. ... Oracle don't really behave the same way as LONG RAW. ...
    (comp.lang.smalltalk)
  • Re: VW7.3 Long RAW --> BLOB in Oracle9i
    ... Oracle don't really behave the same way as LONG RAW. ... I've got a couple of support calls in that relate to BLOB support as ...
    (comp.lang.smalltalk)
  • Re: Raw volume or UFS for Oracle 9i on Sun cluster
    ... But in order to run Oracle on Sun cluster, ... file has to be installed on raw volume. ... software and data files stay with raw volume, database will run faster, ...
    (comp.unix.solaris)