473,385 Members | 1,588 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

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

101 100+
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:
http://download.oracle.com/docs/cd/B...s.htm#i1004619

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.
May 20 '08 #1
3 5056
debasisdas
8,127 Expert 4TB
you want to load data from a pdf file or load the file itself to database ?
May 21 '08 #2
zensunni
101 100+
Sorry for not clarifying. I wanted to load the whole pdf file into the database in a blob data type.
May 21 '08 #3
debasisdas
8,127 Expert 4TB
you need to conver tthe file to a streaqm of bytes and store in BLOB field.
May 22 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: jmdeschamps | last post by:
Hello Having cx_Oracle (an Oracle database connector for Python) used it here where I teach for the last couple of years, and finding it so easy to use (and install) I was taken aback when I got...
1
by: Phil Lamey | last post by:
I have the code below that I am using to load a dataset from and Oracle DB table called PARTNER (SNB). I then wish to load the information into a drop down but I am getting lost near the end of...
12
by: jacob nikom | last post by:
Hi, I would like to store XML files in MySQL. What is the best solution: 1. Convert it to string and store it as CLOB/text 2. Serialize it and store as byte array 3. Flatten it out and create...
125
by: Sarah Tanembaum | last post by:
Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from...
1
by: Jim Shank | last post by:
I am adding support to my application for Oracle 10g and using Enterprise Library Data Access Application Blocks and trying to determine the best way to convert the GUID's which are stored as...
14
by: peteh | last post by:
Hi All; We have many production jobs that "load from cursor" to a UDB/AIX 8.2 (with dpf) data warehouse from source tables residing Oracle 9i. Since Oracle dates are (roughly) equivalent to DB2...
6
by: jrthor2 | last post by:
I have a shell script I am trying to run that loads a table from a control file. The file I am trying to load is delimited by the "}" character. How do I set the delimeter code? Here is my load...
0
by: pratapsantanu | last post by:
Dear Sir, How I will load data from XML file to oracle table. please help me....as soon as posible. Very Very Urgent Thanks pratapsantanu
9
by: Gilles Ganault | last post by:
Hello I googled for samples, but I'd like to make sure there's no simpler way to parse tab-separated data read from a web page, before I can save them into a database: <?php $input =...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.