how to insert the content of file to blob?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: how to insert the content of file to blob?

  1. #1
    Join Date
    Jun 2001
    Posts
    193
    is it possible to use sqlplus
    to read a file and put the content to a blob column of a table?
    the file i want to insert is located at my local machine.

    if so , how?
    guru is on the way!!!!

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    no

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by pando
    no
    It is possible to read the contents of a binary file into a BLOB using PL/SQL.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    dbms_lobs

    but not in sql plus

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by pando
    dbms_lobs

    but not in sql plus
    That's correct. Not in SQL*Plus

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    use sqlloader ...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by sambavan
    use sqlloader ...

    maybe you could supply an example control file of how to load blobs via sqlldr...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    A sample control file for loading blob data:

    load data
    infile 'test_lob.dat'
    append into table test_lob
    fields terminated by ','
    (id , name, external_filename FILLER,
    name_lob LOBFILE(external_filename) TERMINATED BY EOF
    )


    The data in test_lob.dat has
    1,'Tamilselvan',tamil.jpg
    2,'Kannan',Kannan.jpg

Posting Permissions

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


Click Here to Expand Forum to Full Width