ORACLE BLOB

[mariocarrera]

Hi all
I'm using vast 601, and need to reed and write a Blob field from a table. I got a runtime error because the blob is undefined.
So I redefined
AbtOracle8DatabaseManager class>>#buildTypeDict
"Answer a newly constructed dictionary to map Oracle Internal datatypes returned by the
Oracle server to the appropriate Smalltalk field classes."
" AbtOracle8DatabaseManager
typeDict: nil;
typeDict: AbtOracle8DatabaseManager buildTypeDict. "

^ ( Dictionary new )
at: 1 put: AbtDatabaseVarCharField; "VARCHAR2"
at: 2 put: AbtOracle8DecimalField; " Number "
at: 3 put: AbtDatabaseLongIntegerField;
at: 4 put: AbtDatabaseDoubleFloatField; " FLOAT"
at: 7 put: AbtOracle8DecimalField; " Number "
at: 8 put: AbtOracleLongField; " LONG/LONG VARCHAR"
at: 9 put: AbtDatabaseVarCharField; "VARCHAR"
at: 11 put: AbtDatabaseVarCharField; "ROWID. These are treated as VARCHAR2 fields "
at: 12 put: AbtOracleDateField; "DATE"
at: 23 put: AbtOracleRawField; "RAW"
at: 24 put: AbtOracleLongRawField; " LONG RAW "
at: 96 put: AbtDatabaseFixedCharField; "CHAR"
" at: 105 put: AbtOracleMlsLabelField ; " " MLSLABEL "
" at: 111 put: AbtRefField;" " REF "
" at: 112 put: AbtCLOBField;" " CLOB "
"My change*******************"
at: 113 put: AbtOracleLongRawField; " BLOB"
"end my change**************"
yourself.

So I get an ByteArray. that rapresents the file stored on the table. Now I nee to transform it... but I don't know how...

Thank for help

[tc]

Looks like you got further along based on your other post but remember, these are not BLOBs. BLOBs are files stored by Oracle and the pointer to the file is kept in the table, not the data itself.

If you download st 7.5, you can see how BLOBs work.

--tc