[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1408
  • Last Modified:

Extraction of BLOBS (LONG RAW) using PL/SQL

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
oracle082697
Asked:
oracle082697
1 Solution
 
leonidtCommented:
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now