Re: Easy Way to Extract BLOB data to file
Date: Wed, 18 Aug 1999 08:55:14 -0700
Message-ID: <GHAu3.630$3S5.2332_at_client>
CONNX for Oracle supports BLOB's and CLOB's; you will be able to 'MailMerge' from Oracle. For a free evaluation please see the information below:
CONNX 8.0
for Oracle RdB, Open VMS supporting RMS,and DBMS databases.
Now Supports Oracle on every platform! Full SQL support, CLOBs and BLOBs.
CONNX 8.0 information can be obtained at http://www.solutionsiq.com/products/index.html
The Solution: The CONNX family of Data Access Engine software is a data access solutions that allows PC applications secure real-time read and write access to various back end data sources without major programming effort. CONNX 8.0 accomplishes this through its data dictionary, which contains the metadata about the source information and provides GUI screen for easy and intuitive querying of the database. This means the bulk of an application can be offloaded to the PC, resulting in reduced server-processing loads and significantly improved user interfaces while preserving your existing database investment.
*Data Migration *Y2K Compliance *Application Development *Ad Hoc Reporting *Data Warehousing *Application Migration *Web Enablement of Data *E-Commerce *Connectivity for OLE-DB, ODBC, JDBC, compliant applications
Full SQL Support: Supports ODBC SQL (Insert, Update, Select, and Delete). Supports group by, distinct aggregate (AVE, MIN, MAX, SUM, and COUNT), and all substring, string, date, conversion, and math functions. Nested inner and outer left/right joins are supported, as well as subqueries and correlated subqueries. CONNX also supports Unions and Insert/Select.
Please visit the SolutionsIQ website for more information about our exciting line of products.
Thank you,
The CONNX data access team
-- Remy O'Keefe 888.882.6669 ext. 189 toll free or 425.519.6692 RO'Keefe_at_SolutionsIQ.com SolutionsIQ, Software Products Division http://www.solutionsiq.com/products/index.html Aik Khoon <wrote in message news:7pc7qm$6e5...Received on Wed Aug 18 1999 - 17:55:14 CEST
> Hi,
>
> Currently, I'm trying to extract BLOB data to file (Oracle 8.0.5 NT
> platform) e.g. MS Word document. I did some research, including finding
out
> from this newgroup where someone
> suggested calling an external procedure OutputString to dump BLOB data
out.
> I tried this
> out but always find it troublesome since I have many tables with BLOB
> columns and
> everytime I have to expliclitly create new procedures just to pump the
BLOB
> data out
> for that particular column.
>
> Question :
> 1. Will Oracle come up with some builtin packages I can just call to
extract
> data. I come
> from Informix background and they have this handy way of extracting BLOB
> data e.g.
>
> SELECT LOTOFILE(col_name, 'YourPathTofile!', 'SERVER') from some_table
> where ....
>
> and the data is extracted. Data Insertion is also straight forward :
>
> INSERT INTO some_table VALUES (1,
FILETOBLOB('YourPathToFile','SERVER')
> ...
>
> 2. Why does Oracle only provide a package procedure to load BLOB data e.g.
> DBMS_LOB.
> LOADFROMFILE but none for extracting data ?
>
> This is especially important for MSWord BLOB data (r.t. graphics data
> for Web use).
>
> I hope there is some extra support for BLOB data manipulation in
Oracle
> 8.0.5 though I
> saw improvement in 8.1.5 but I can't be using it.
>
> regards,
> Aik Khoon
>
>