Solved

Extraction of BLOBS (LONG RAW) using PL/SQL

Posted on 1997-08-27
1
1,359 Views
Last Modified: 2008-03-10
I am trying to find out how to extract a BLOB (LONG RAW data type) from an Oracle database using PL/SQL, and then write it to a file on a UNIX file system.
0
Comment
Question by:oracle082697
1 Comment
 

Accepted Solution

by:
leonidt earned 50 total points
ID: 1080471
The main problem is that PL/SQL does not operate with
data more than 32K long. So you can select the data from long
raw column into PL/SQL variable of type long raw or long
(does not actually matter for PL/SQL) and then write it to UNIX
File using UTL_FILE, the only problem is that you cannot get
more than 32K. There is no way in PL/SQL to operate with data more than 32K long. My advice is to get it through the OCI
interface from C/C++ or probably (I never tried that but should work) even through VB using ODBC.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question