Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inserting an oracle 9 BLOB record
Message
From
30/03/2005 14:09:36
Héctor Lizarraga
Gobierno Del Edo de Querétaro
Querétaro, Mexico
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Inserting an oracle 9 BLOB record
Miscellaneous
Thread ID:
01000032
Message ID:
01000032
Views:
50
Hi, does anyone know how can I insert a blob record in an oracle database?

I've tried this but it doesn't work:

cFile=FILETOSTR('c:\background1.jpg') * this file is 2k in size
cQuery = "insert into prueba_blob (blob_id,blob_1) values (1,"+cFile+")"
nReg=SQLEXEC(nHnd,cQuery,'curResult')

the message from oracle is:
missin comma
or
invalid caracter

Any ideas?
Thanks in advance
Next
Reply
Map
View

Click here to load this message in the networking platform