1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Help! Total newbie question

Discussion in 'General' started by lemons, Jul 27, 2010.

  1. lemons

    lemons Guest

    Hi all,

    I'm sorry that this is such a lame question, but I can't find the answer anywhere.

    I'm trying to create a table with three columns: Pic ID (number), Pic (BLOB) and Desc (Varchar2).

    How do I get a picture into the BLOB column? Can I do it through PL/SQL or do I have to create a form to upload one? Everytime I try in SQL Developer it fails, I don't think I'm supposed to do it that way.


    Any help would be great. Sorry for being dumb!
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Look up the dbms_lob package in the online documentation found here:

    http://tahiti.oracle.com