Is it possible to email a ref cursor using utl_smtp (or indeed javamail
etc)? I have a need to mail the output from a number of similar select
statements to an applications administrator on a scheduled basis. I'd
therefore quite like to use dbms_job to automate this procedure. At the
moment I achieve this by using OS scheduling and a shell script to mail the
spooled output of a sqlplus session from my workstation. This fails dismally
when I go on leave and turn the workstation off. It also isn't exactly the
best documented procedure in the world!
Alternatively how do others do this sort of thing? utl_file? OEM Reports?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Wed Aug 28 2002 - 07:44:51 CDT
