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

Thread: Images

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Location
    hyderabad,india
    Posts
    27
    Hi,

    Can someone help me out on how to insert an image into the table throgh PL/SQL.

    I've got a
    table img(
    f1 number,
    f2 blob)

    Through PL/SQL how i can insert data into the table.

    Waiting for an early reply.

    Warm Regards,
    Raghava Rao.

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    I insert images (BLOBs) into the database via Forms. If you use Forms I could tell you how to do it.


  3. #3
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Have you considered using interMedia to hold your images. It's actually quite good. Intermedia has import functionality built in, and in later versions of 8i export facilities too. This is all done via directory objects or you can do it through java like:

    http://www.oracle-base.com/Articles/...rtOfImages.asp

    If you'd rather stick with your BLOB you can use something like this:

    http://www.oracle-base.com/Articles/8i/ImportBlob.asp

    Cheers

    [Edited by TimHall on 01-31-2002 at 06:16 AM]
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

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