Try the following:
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')
>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
- Jayesh