What's the best way to load a PDF file into an oracle table?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zensunni
    New Member
    • May 2007
    • 101

    What's the best way to load a PDF file into an oracle table?

    Judging by what I've read, I need to use SQL*Loader.

    Before I go studying SQL*Loader, I wanted be sure this was the best method. Judging by what I've read about it, it seems a little complicated.

    The guide I'll be using is this:


    Anyone have a better suggestion or tutorial?

    [Edit] By the way, I need this to be called through ASP.

    [Edit 2] Also, I've tested the command in Oracle SQL*Plus and it is an unrecognized command. I'm guessing it's an external program and not accessible through and SQL command. Funny part is, I can't even find the exe.
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    you want to load data from a pdf file or load the file itself to database ?

    Comment

    • zensunni
      New Member
      • May 2007
      • 101

      #3
      Sorry for not clarifying. I wanted to load the whole pdf file into the database in a blob data type.

      Comment

      • debasisdas
        Recognized Expert Expert
        • Dec 2006
        • 8119

        #4
        you need to conver tthe file to a streaqm of bytes and store in BLOB field.

        Comment

        Working...