General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Inserting an oracle 9 BLOB record
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only