[RESOLVED] newbie in ORACLE

[zaborgmobius]

hmm first i was creating a program in Vb6.0 using Access as database... the db has a field with OLE Object datatype.. i use this code to put the image file to the db.

Dim bvariant As Variant
blob_write = Null
bvariant = Null

register.Export bvariant
blob_write = bvariant

Adodc1.Recordset.Fields("adminFP") = blob_write
Adodc1.Recordset.Update

note: the program runs with no problem..

then i decided to use oracle... i created a table, without BLOB datatype first, connection was successful and it displayed the records, but when i added the BLOB datatype in the table (i heard that OLE Object = BLOB in oracle), the program doesnt run anymore.. and it displays an "INVALID SQL STATEMENT" error..

i know the error is with the blob because when i drop(delete) the column(field) of adminFinger, it runs smoothly. maybe you've experienced this problem or have knowledge to help me... please do i just started in oracle so i need a little bit of your guidance.. thanks in advance

should i change the codes in vb(but i doesnt run in the first place)? or i should do something with the oracle?(no idea)

ninja edit: rsAdmin.Open "ADTABLE", DB, adOpenStatic, adLockOptimistic is where the yellow line points out