[OAUGNetDBA]-Re: Print a PDF stored as a BLOB?

["Joseph Imbimbo" <joei@andrew.cmu.edu>]

Is the blob stored as a PDF or do you have a mixed bag.  It may be easier to
do a print driver with PDF in the mix.  
If I understand this:

You want to create a print driver or concurrent job that retrieves an
attachment from the data base for printing without having to view the
document, correct?

Joe

-----Original Message-----
From: OAUG Net DBA listserver [mailto:OAUGNetDBA@oaug.com] On Behalf Of Chad
Thompson
Sent: Tuesday, August 26, 2008 10:27 AM
To: OAUG Net DBA listserver
Subject: [OAUGNetDBA]-Re: Print a PDF stored as a BLOB?

Manipulating the LOBs isn't the problem.  Sending a PDF to the printer from
withing Apps is.

At the moment, I'm looking at:
1. A 10mb file has just the URL stored on an Apps server in Florida pointing
to a file on a file server in Calgary that needs printed in Germany.  Or the
10mb file is already stored in a DB LOB in Florida.  Done.
2. A custom process that copies the Calgary file to a DB BLOB in Florida (if
not already there).  Done.
3. A custom process that copies the file from the DB BLOB to the OS.  Done.
4. A custom unix print from the OS in Florida to the printer in Germany.
Not done, would prefer printing from the Apps rather than OS.

Duplicating many printers on the Apps config to the OS is a concern.  So is
I/O, though a lesser concern due to fast networks.

Chad

--- On Mon, 8/25/08, Joe Imbimbo <joei@andrew.cmu.edu> wrote:

> From: Joe Imbimbo <joei@andrew.cmu.edu>
> Subject: [OAUGNetDBA]-Re: Print a PDF stored as a BLOB?
> To: "OAUG Net DBA listserver" <OAUGNetDBA@oaug.com>
> Date: Monday, August 25, 2008, 7:23 PM Check out the DBMS_LOBS package 
> that has many procedures and functions inside to manipulate LOBs.  You 
> may be able to write your own function modeled after one of these.
> 
> joe
> 
> 
> > Does anyone know how to print a PDF that is stored as
> a BLOB (fnd_lobs)?
> > I have groups of 50+ attachments to print.  I'd
> prefer to somehow print
> > them from within DB and use the Apps printer
> configurations rather than
> > exporting the files to the OS and use GhostScript.
> > 
> > Chad
> > 
> >
> #############################################################
> This message
> > is sent to you because you are subscribed to the
> mailing list
> > <OAUGNetDBA@oaug.com>. To unsubscribe, E-mail
> to:
> > <OAUGNetDBA-off@oaug.com> To switch to the FEED
> mode, send any message to
> > <OAUGNetDBA-feed@oaug.com> To switch to the
> DIGEST mode, E-mail to
> > <OAUGNetDBA-digest@oaug.com> To switch to the
> INDEX mode, E-mail to
> > <OAUGNetDBA-index@oaug.com> Send administrative
> queries to
> > <OAUGNetDBA-request@oaug.com>
> > 
> > 
> > 
> 
> 
> #############################################################
> This message is sent to you because you are subscribed to the mailing 
> list <OAUGNetDBA@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com> To switch to the 
> FEED mode, send any message to <OAUGNetDBA-feed@oaug.com> To switch to 
> the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com> To switch to 
> the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com> Send 
> administrative queries to <OAUGNetDBA-request@oaug.com>

#############################################################
This message is sent to you because you are subscribed to the mailing list
<OAUGNetDBA@oaug.com>.
To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com> To switch to the FEED
mode, send any message to <OAUGNetDBA-feed@oaug.com> To switch to the DIGEST
mode, E-mail to <OAUGNetDBA-digest@oaug.com> To switch to the INDEX mode,
E-mail to <OAUGNetDBA-index@oaug.com> Send administrative queries to
<OAUGNetDBA-request@oaug.com>




#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNetDBA@oaug.com>.
To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNetDBA-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
Send administrative queries to  <OAUGNetDBA-request@oaug.com>