Re: JVM in the database
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 18 Nov 2019 19:02:23 -0500
Message-ID: <e78a1f5b-55f3-c53d-cd44-06d4f5879e1d_at_gmail.com>
Date: Mon, 18 Nov 2019 19:02:23 -0500
Message-ID: <e78a1f5b-55f3-c53d-cd44-06d4f5879e1d_at_gmail.com>
I used Perl for that. Not as fancy as Java but it does the job.
Regards
On 11/18/19 2:30 PM, Jeff Chirco wrote:
> I use a java procedure to dump blob files to an actual file. We store
> some PDF's in the database as blob and at times they need to be dumped
> to a files. Usually its when they want hundreds at time. We found
> doing this in a loop with PL/SQL was really slow and slower over time.
> I found a Java procedure to do this and is is super quick.
> We also have another to get file and directory information. It
> returned back more information that PL/SQL and also was really fast.
>
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 19 2019 - 01:02:23 CET