Re: Email from stored proc in Oracle 8.1.5

Hi:

You can store the .class file directly into the database using the following Util. it comes with Oracle

loadjava -u username/password_at_host:port:machine -v -r -t <yourclass file>

And then, you can call the class from your SP.

Good luck.

V Prakash

In article <900c5p$bng$1_at_news2.isis.unc.edu>,   "Patrick Casey" <patrick_casey_at_unc.edu> wrote:
> Prakash,
>
> I have not use Java Stored Procedures before. But I have used JavaMail
 in
> our day to day web work.
>
> This may be a dumb question, but would I have to install JavaMail in
 the
> database? Or could I point something to my JavaMail install in our
 class
> library? Hmm, not sure I am explaining this well. Would I need to
 create a
> class library within Oracle to be able to run java SP's?
>
> "Prakash" <venkatprakash_at_my-deja.com> wrote in message
> news:8vv3ig$ojn$1_at_nnrp1.deja.com...
> >
> >
> > The only way I know is, calling a stored Java procedure. Thats how I
 did
> > in the past. We can invoke the Java stored procedure from PL SQL
> > Procedure and in turn that java (using java Mail) will send the
 mail.
> >
> > Hope this helps. Thanks
> >
> > V Prakash
> > venkatprakash_at_Hotmail.com
> >
> > In article <8vufq3$jf0$1_at_news2.isis.unc.edu>,
> > "Patrick Casey" <patrick_casey_at_unc.edu> wrote:
> > > I have seen all the info about email from UTL_SMTP but that is
 only
 for
> > > 8.1.6 release 2 and above.
> > >
> > > Does anyone have any samples of sending email from PL/SQL in
 8.1.5????
> > >
> > > Thanks in advance.
> > >
> > > --
> > >
> > > Patrick Casey
> > > Applications Analyst Programmer II
> > > UNC - Chapel Hill
> > > patrick_casey_at_unc.edu
> > >
> > >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 28 2000 - 19:02:16 CET