pictures in tables?????
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: pictures in tables?????

  1. #1
    Join Date
    Apr 2001
    Posts
    5

    Question

    hi,

    can anyone help me out, how to store pictures in a database tables (like bmp files).

    pl. provide me an example.

    thanks,
    ram


  2. #2
    Join Date
    Apr 2001
    Posts
    17
    USE LONG RAW LIKE:

    CREATE TABLE EMP
    (EMP_ID NUMBER,
    PIC LONG RAW);

  3. #3
    Join Date
    Apr 2001
    Location
    hyderabad,india
    Posts
    27
    hai,
    u can store images of any format by using lob data types
    step1:first create a table with field type as BFILE,BLOB
    eg:create table img(imgno number,imgo BFILE,imgi BLOB)
    step2:using DBMS_LOB package load the picture into the BFILE field
    Step 3:Using the DBMS_LOB.LOAD() u load the bfile field into BLOB field
    step 4:To retrieve the image from database to front end it is possible only with forms6i.

    regarding the actual coding please visit the site of oracle
    doc umentation there u have a book on dealing with images using visual cartridge.

    prior to this u should have oracle 8 with visual cartridge installed on it(optional)handing will be easy

    with regards
    k.raghava rao

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