Re: Emailing pdf files using utl_smtp questions

From: hah <shhoff8_at_yahoo.com>
Date: 11 Jul 2006 06:58:27 -0700
Message-ID: <1152626307.871783.155930_at_m73g2000cwd.googlegroups.com>


[Quoted] Unfortunately database is 9, I saw the UTL_MAIL seemed much easier to work with!

DA Morgan wrote:
> hah wrote:
> > I am using web version. I run a bunch of reports to files on the
> > server which the web version appends numbers to the end of the file
> > name. I'm having 2 problems:
> >
> > First how do I get the code to recognize wildcards. I won't know the
> > numbers that the server appends to the filenames and I need to identify
> > the filename that corresponds to our employee id to send them the
> > correct report. Can wildcards be used in bfilename?
> >
> > Also when I specify the exact filename the loop works and sends out the
> > pdf attachment email but only the first one is ok, all the other pdf's
> > are corrupt and adobe says it is not correctly decoded. ANY help would
> > be greatly appreciated! I am new to the web version as well as using
> > utl_smtp and bfile.
>
> What version of Oracle?
>
> If 10g you should be using UTL_MAIL not UTL_SMTP.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Tue Jul 11 2006 - 15:58:27 CEST

Original text of this message