connectivity asp.net and oracle

inserting image in oracle database through asp.net

Page 1 of 1

0 Replies - 1203 Views - Last Post: 05 December 2009 - 06:53 AM

#1 Soniyo   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 10
  • Joined: 05-December 09

connectivity asp.net and oracle

Post icon  Posted 05 December 2009 - 06:53 AM

hello, anybody knw how to insert more than one image in oracle database table.

i hve written the code for inserting in plsql block
String block = " BEGIN " +
" INSERT INTO testblob (id, photo) VALUES (100, :10); " +
" SELECT photo into :2 from testblob WHERE id = 100; " +
" END; ";
and passing this string to filestream.

Bt the problem is Oracle table can hold only one image
so i always have to truncate the table.

anybody any idea pls help.. :rolleyes:

Is This A Good Question/Topic? 0
  • +

Page 1 of 1