Re: Emailing pdf files using utl_smtp questions

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