[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

[BrianS]

Paste the exact code you are using for the Oracle SQL

[zaborgmobius]

Paste the exact code you are using for the Oracle SQL

i dont use SQL but if your talking about SQL when oracle creates the table

CREATE TABLE "ADTABLE"
( "ADMINID" NUMBER(6,0),
"FIRST_NAME" VARCHAR2(20),
"LAST_NAME" VARCHAR2(25) NOT NULL ENABLE,
"ADMINFP" BLOB
)
/

if this is not what you're talking about... then could you guide me what is it? since im not using SQL as much as possible...

[zaborgmobius]

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

i tried adding the adCmdTable at that code, rsAdmin.Open "ADTABLE", DB, adOpenStatic, adLockOptimistic, adCmdTable - The error was changed... "DATA TYPE NOT SUPPORTED"

[zaborgmobius]

oops nevermind guys already fixed it... thanks for the time!!

[RhinoBull]

You may as well provide your "solution"...