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

Thread: PIC

  1. 11-08-2001, 06:10 AM #1
    vrkeesara
    vrkeesara is offline Junior Member
    Join Date
    Feb 2001
    Posts
    20
    hiiiiiiiii friends shall i insert pic into database
    by using BLOB DATATYPE.
    when ever i am trying to insert a pic by using BLOB I GET
    a error (ORA-01465: invalid hex number),
    so help me?
    keesara
    Reply With Quote Reply With Quote
  2. 11-08-2001, 07:24 AM #2
    Raminder's Avatar
    Raminder
    Raminder is offline Advisor
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    You cannot insert a pic directly into BLOB Column.
    You have to use a package called dbms_lob or some third party software which converts the pic file into binary and inserts into database.
    There are various methods and examples given for JDBC, VB (OO4O) and C given in Oracle documentation.

    Just to give you an idea, you can see my post in:
    http://www.dbasupport.com/forums/sho...threadid=17608

    [Edited by Raminder on 11-08-2001 at 06:33 AM]

    Raminder Singh
    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.
    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