Results 1 to 6 of 6

Thread: Saving Documents in Oracle

  1. #1
    Junior Member
    Join Date
    Mar 2009
    Answers
    1

    Saving Documents in Oracle

    Hi memebers

    Is there any possible way to to store word documents, PDF and excel files into Oracle 10g database. If so please explain the possible ways how it is achievable with developer forms.

    Cheers
    Udai


  2. #2
    Expert Member
    Join Date
    Nov 2008
    Answers
    300

    Re: Saving Documents in Oracle

    yes you can store large objects using CLOB, BLOB datatypes. Check for these datatypes and also DBMS_LOB package that will help you to store the objects in to oracle database


  3. #3
    Contributing Member
    Join Date
    Dec 2008
    Answers
    76

    Re: Saving Documents in Oracle

    Hai Udaikanth,

    Yes it is possible...
    here some examples for u..

    create table blob_table
    (
    num number(20),
    var varchar2(100),
    datecont date,
    blobcont blob
    );

    ----Controlfile

    load data
    infile 'file_name'
    into table blob_table
    fields terminated by ','
    (
    .
    .
    .
    .
    )


    Using SQL*Loader command,
    run from the command line in the same directory where files located.

    sqlldr username/password@DB_identifier control=c.ctl log=l.log bad=b.bad


    Hope you get some idea from the above example..

    As like amit said, we can able to do this job through SP using DBMS_LOB packages.
    refer here
    Loading Objects, LOBs, and Collections

    Last edited by ecearund; 03-12-2009 at 02:25 AM.

  4. #4
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Saving Documents in Oracle

    you can also use the data type BFILE.


  5. #5
    Junior Member
    Join Date
    Mar 2009
    Answers
    7

    Re: Saving Documents in Oracle

    yes u can save document in orecle .
    If u want to store it inside database use blob,clob .
    or u can use bfile ,bfile stores d locator to the physical file, with the help of bfile database user can access the external file system


  6. #6
    Junior Member
    Join Date
    Jun 2009
    Answers
    1

    Re: Saving Documents in Oracle

    Hi
    I have the same Issue,but I want to know how to link the table for fetch and editing using the forms.
    when I create the block it create image control to the Blob field,and when fetch record its empty.


  7.  Sponsored Ads
    Ad


     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact