Re: Uploading files to an Oracle database with a Perl cartridge and OAS4.0

[Quoted] [Quoted] I used the UTL_FILE-package. This Perl-implementation is suitable for uploading and processing flat text files. I haven't used it for uploading binary files. Furthermore, the database was 7.3.4. (dbms_lob not available).

The problem with the content service of OAS 4.08 in combination with 7.3.4. is the impossibility to extract the files from the database and save to the filesystem, without having to write in filehandler in C++. Uploading (and dowloading) large (binary) files to (and from) the database with the content service works fine. But what to do if the files need further processing!

I suspect this is not a problem with Oracle8 (UTL_RAW?). Is it possible to save a file to the filesystem from the long raw column where files are stored by the content service of OAS?

I'm interested in the limitations you experienced with OAS.

Onno

"Zab" <Zab_at_excite.com> wrote in message news:030120000005274177%Zab_at_excite.com...
>
> Thank you very much Onno, for this valuable post.
> I have been working with owa content myself and found it limitative too.
> This is why your post is so interesting to me.
> I read your note and downloaded the files , but could not find the
> process_file procedure. I suppose you use the dbms_lob package to load
> the file into a blob. Correct ?
>
> Zab.
>
>
> In article <38691c50$0$9998_at_reader3.casema.net>, Onno M. van der
> Straaten <ovds_at_casema.net> wrote:
>
> > If you are looking for information about uploading files to an Oracle
> > database with a Perl Cartridge and OAS 4.0, you can find a detailed
> > description and code samples on the internet:
> > http://onst.webjump.com/oas40.htm
> >
> > Onno van der Straaten
> > Onno.vanderStraaten_at_iname.com
Received on Mon Jan 03 2000 - 16:54:42 CET