Home » RDBMS Server » Server Administration » images out to the file system
images out to the file system [message #369715] Thu, 24 August 2000 10:03
Peter Bosch
Messages: 1
Registered: August 2000
Junior Member
Hi there,

Peoplesoft, (up to v7.5) stores images in long_raw field
types on oracle. And with the help of utl_file and dbms_lob it is
possible to insert a .jpg file into the table. But it drives me crazy
that I don't find a solution unloading the image back to the filesystem
with PL/SQL code.
QUESTION: How do I write an image out from the database to the file
system ?

Thanks for any hint

Peter Bosch
PS Consultant
Previous Topic: Sending email from database through forms
Next Topic: unix-sql
Goto Forum:

Current Time: Tue Oct 20 10:19:09 CDT 2020