Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Inserting OLE Object field into Oracle Blob with stored procedure
55 views
Skip to first unread message
wesley...@gmail.com
May 29, 2012, 7:03:00 AM5/29/12
to
Hi,
I'm trying to import Ms Access 2003 data into Oracle database.
One of the field is an OLE Object field with word doc into it.
I'm trying to import it into a BLOB field but it doesn't work.
I'm connecting to the db with the MSADORA.1 provider and adding the parameter to my adodb command like this
Set param = .CreateParameter("v_long_comment", adLongVarBinary, adParamInput, 2, "Idon'tKnowHowToSetTheValue")
Does anyone know how to do such thing ?
Many thanks for your help.
I'm trying to import Ms Access 2003 data into Oracle database.
One of the field is an OLE Object field with word doc into it.
I'm trying to import it into a BLOB field but it doesn't work.
I'm connecting to the db with the MSADORA.1 provider and adding the parameter to my adodb command like this
Set param = .CreateParameter("v_long_comment", adLongVarBinary, adParamInput, 2, "Idon'tKnowHowToSetTheValue")
Does anyone know how to do such thing ?
Many thanks for your help.
Patrick Finucane
May 29, 2012, 4:53:34 PM5/29/12
to
response with a grain of salt. Would AppendChunk or GetChunk assist
you?
Access Developer
May 29, 2012, 8:18:08 PM5/29/12
to
"Patrick Finucane" <patrickf...@gmail.com> wrote
> Since I have absolutely no experience with an
> issue like yours take my response with a grain
> of salt. Would AppendChunk or GetChunk
> assist you?
That's the way it would be done to save a BLOB in a Jet DB, or an SQL Server
DB. There's an example in some older discussion and demonstration of
handling images at http://accdevel.tripod.com.
Larry Linson
Microsoft Office Access MVP
> Since I have absolutely no experience with an
> issue like yours take my response with a grain
> of salt. Would AppendChunk or GetChunk
> assist you?
DB. There's an example in some older discussion and demonstration of
handling images at http://accdevel.tripod.com.
Larry Linson
Microsoft Office Access MVP
0 new messages