DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: urgent : how to insert a record with BLOB

  1. 02-05-2003, 08:48 AM #1
    SridharS
    SridharS is offline Junior Member
    Join Date
    Aug 2002
    Posts
    5

    urgent : how to insert a record with BLOB

    I need to insert a record into a table having a BLOB data type . I want to insert a '*.bmp' image into that. I have tried as below from the sql prompt.

    'INSERT INTO MY_TABLE VALUES (1, BLOB_FILE('c:\WInnt','action.bmp');

    but it's giving an serror saying 'inconsistent data types' .
    Please can somebody help.
    Reply With Quote Reply With Quote
  2. 02-06-2003, 08:30 AM #2
    Sameer's Avatar
    Sameer
    Sameer is offline Advisor
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    http://www.oracle-base.com/Articles/8i/ImportBlob.asp
    Reply With Quote Reply With Quote
  3. 02-06-2003, 09:45 AM #3
    TimHall
    TimHall is offline Senior Advisor
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Yeah! I'm famous
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog
    Reply With Quote Reply With Quote
  4. 02-06-2003, 11:23 AM #4
    Sameer's Avatar
    Sameer
    Sameer is offline Advisor
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Originally posted by TimHall
    Yeah! I'm famous
    No doubt about it
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width