1 Replies - 2668 Views - Last Post: 27 September 2012 - 06:58 AM

#1 Jonand  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 12
  • Joined: 26-September 12

Empty blob insert and update blob query problem

Posted 27 September 2012 - 02:31 AM

I need to insert a blob in o oracle database. I am using c++ and ODBC library. I am stucked at the insert query and update query .It is abstract for me how to make an blob insert query. I know how to make an query for a non blob column. My table structure is :
REATE TABLE t_testblob (
     filename VARCHAR2(30) DEFAULT NULL NULL,
     apkdata  BLOB         NULL
)


I found an exemple on insert and update :
 INSERT INTO table_name VALUES (memberlist,?,memberlist)
 UPDATE table_name SET ImageFieldName = ? WHERE ID=yourId


But these structure of querys or abstract to me . What should memberlist be ? why is there "?" where are the values to be inserted ?

Thanks ,and i know this is a silly question but i really cant create an blob insert query.

Is This A Good Question/Topic? 0
  • +

Replies To: Empty blob insert and update blob query problem

#2 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 8371
  • View blog
  • Posts: 31,101
  • Joined: 12-June 08

Re: Empty blob insert and update blob query problem

Posted 27 September 2012 - 06:58 AM

... moving to the Oracle DB subforum.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1