snagit 8 2 3 free downloadpowerdvd dx 5 1 downloadnorton confidential plug in downloadpoweriso v4 8 free download
Oracle8i On-Line Generic Documentation Release 3 8.1.7
Oracle8i Online Documentation CD-ROM Release 3 8.1.7 for Microsoft Windows
Oracle8i Client Online Documentation CD-ROM Release 3 8.1.7 for Microsoft Windows
Oracle interMedia Audio, Image, and Video Java Classes Users Guide and Reference, Release 8.1.7
Oracle8i Documentation Addendum, Release 8.1.7
Oracle Label Security Administrators Guide Release 8.1.7
Oracle Heterogeneous Services Release 8.1.7
Oracle8i 8.1.7 Installation Guide for Windows NT
Oracle8i 8.1.7 Client Installation Guide for Windows
Oracle8i 8.1.7 Release Notes for Windows NT
Legato Storage Manager Command Reference Guide Release 8.1.7 for Windows 2000 and Windows NT
Oracle Message Broker 2.0.1.0 Installation Guide for Windows NT
Oracle Applications InterConnect Installation Guide Release 4.0.0 for Windows NT and UNIX
Oracle8i Administrators Reference Release 3 8.1.7 for AIX-Based Systems
Oracle8i Installation Guide Release 3 8.1.7 for AIX-Based Systems
Oracle8i Release Notes Release 3 8.1.7 for AIX-based Systems 64-bit
Oracle8i Release Notes Release 3 8.1.7 for AIX-Based Systems
Oracle Message Broker Installation Guide, Release 2.0.1.0 Stand-alone for AIX-Based Systems
Oracle8i Administrators Reference Release 3 8.1.7 for Compaq Tru64 UNIX
Oracle8i Installation Guide Release 3 8.1.7 for Compaq Tru64 UNIX
Oracle8i Release Notes Release 3 8.1.7 for Compaq Tru64 UNIX
Oracle Message Broker Installation Guide, Release 2.0.1.0 Stand-alone for Compaq Tru64 UNIX
Oracle8i Administrators Reference Release 3 8.1.7 for HP 9000 Series HP-UX
Oracle8i Installation Guide Release 3 8.1.7 for HP 9000 Series HP-UX
Oracle8i Release Notes Release 3 8.1.7 for HP Series 9000 HP-UX 64-Bit
Oracle Message Broker Installation Guide, Release 2.0.1.0 Stand-alone for HP 9000 Series HP-UX
Oracle Procedural Gateway for APPC Installation and Configuration Guide Release 8.0.6.1.0 for HP9000 Series 700/800
Oracle8i Administrators Reference Release 3 8.1.7 for Linux Intel
Oracle8i Installation Guide Release 3 8.1.7 for Linux Intel
Oracle8i Release Notes Release 3 8.1.7 for Linux Intel
Oracle8i Installation Guide Release 3 8.1.7 for Alpha OpenVMS
Oracle8i Parallel Server Addendum Release 3 8.1.7 for Alpha OpenVMS
Oracle8i Release Notes Release 3 8.1.7 for Alpha OpenVMS
Oracle8i 8.1.7 Server and Tools Administrators Guide for Alpha OpenVMS
Oracle8i Administrators Reference Release 3 8.1.7 for Sun SPARC Solaris
Oracle8i Installation Guide Release 3 8.1.7 for Sun SPARC Solaris
Oracle8i Release Notes Release 3 8.1.7 for Sun SPARC Solaris
Oracle 8i Release Notes Release 3 8.1.7 for Sun SPARC Solaris 64-bit
Oracle8i Release Notes Release 3 8.1.7 for IBM DYNIX/ptx
Oracle8i Administrators Reference Release 3 8.1.7 for IBM DYNIX/ptx
Oracle8i Installation Guide Release 3 8.1.7 for IBM DYNIX/ptx
Oracle8i Installation Guide Release 3 8.1.7 64 Bit for SGI IRIX
Oracle8i Administrators Reference Release 3 8.1.7 64 Bit for SGI IRIX
Oracle8i Installation Guide Release 3 8.1.7 for Unified Intel UNIX
Oracle8i Administrators Reference Release 3 8.1.7 for Intel UNIX DG/UX, SCO UnixWare, Solaris Intel
Oracle8i Release Notes Release 3 8.1.7 for Intel UNIX DG/UX Intel and SCO UnixWare
Oracle 8i Release Notes Release 3 8.1.7 for Solaris Intel UNIX
Oracle8i Installation Guide 64 Bit Release 8.1.7 for Fujitsu Siemens ReliantUNIX
Oracle8i Administrators Reference 64 Bit 8.1.7 for Fujitsu Siemens ReliantUNIX
Oracle8i Release Notes Release 3 8.1.7 64 Bit for SGI IRIX
Oracle8i Server 8.1.7 for Fujitsu Siemens Computers BS2000/OSD Users Guide
Oracle8i Server 8.1.7 for Fujitsu Siemens Computers BS2000/OSD Installation and Database Administration Guide
Phone: 1.800.633.0738 Great Customers, See how Oracle company is using SaaS, PaaS, IaaS, as well as other technologies to remodel their businesses and engage customers in new and ways.
Oracle announces beta option of Oracle Database 12 c, Release 2 providing more agility and scalability for cloud deployments.
Welcome to your most comprehensive portfolio of cloud solutions for ones business, IT infrastructure, and development needs.
What key performance indicators matter from the Digital Age, and just how do you measure their value on the business? New global research by CIMA shows ways to build a next-generation finance function capable of capture the additional value being manufactured by digital technologies.
Market-leading vertical software to own your core business.
Recruit, develop, and retain top talent that has a socially oriented, data-rich cloud software suite.
Oracle announces breakthrough processor and systems design with SPARC M7, featuring Security in Silicon, SQL in Silicon for unparalleled database efficiency, and record-setting enterprise performance.
New applications, platforms, and tools broaden Oracles complete enterprise cloud.
Everything an enterprise manager has to know.
Oracle President Thomas Kurian references the benefits of Oracle Database inside Oracle Cloud.
Transform your small business with Oracle Cloud.
Oracle Marketing Cloud creates ideal customers.
Learn the way the Oracle Cloud Platform can accelerate your small business.
Platform being a service allows you to rapidly develop scalable apps.
Oracle Cloud Platform as being a Service is created for developers.
IDC Research weighs in on Platform like a Service.
Discover the best way to drive innovation.
Second quarter fiscal year 2016 results show continued acceleration in cloud.
Finding the appropriate library.
Its information on cloud at each and every level from the enterprise.
How Oracle Database 12 c In-Memory outperforms SAPs HANA in-memory database.
Cloud may be the only way for companies to obtain the speed and innovation they really need.
Oracles Configure, Price, Quote tool is transforming selling practices.
See what CERN European Laboratory for Particle Physics discovered.
His talk to Oracle CEO Mark Hurd offers advice about the transformation underway in the digital industrial giant.
Hitachi moved 650 subsidiaries to centralized recruiting.
When DX Marketing needed to scale up and lower your expenses, there were only one location to turn.
Four Conferences: Modern CX, Finance, HCM, and Supply Chain.
Oracle Industry Connect: Orlando, April 2016
Thought leadership and practices.
Oracle CloudWorld: Seoul, January 19
Featuring keynotes for Oracle executives and industry visionaries.
Five Conferences: Modern CX, Finance, HCM, Supply Chain, and IT.
Modern Supply Chain Experience: Jan 25 27, 2016
Come to San Jose for the best practices and new solutions through the top supply chain innovators.
Simplify processes and accelerate decisions.
Align processes and remain compliant.
Support growth and innovation and exploit enabling technologies.
Leverage insight, empower teams and reach your goals.
Connect with mobile and resolve issues quickly.
Phone: 1.800.633.0738 Oracle reports significant cloud growth, with SaaS and Paas revenues up 39% in constant currency, in second quarter fiscal year 2016 results.
New applications, platforms, and tools broaden Oracle s complete enterprise cloud.
In-depth articles on Oracle technology now in your smartphone and tablet.
Data Capital is usually a foundation with the future.
Oracle s Configure, Price, Quote tool is transforming selling practices.
Phone: 1.800.633.0738 HTTP/1.0 302 Found Location: /pls/asktom/f?p100:11:0::::P11QUESTIONID:255615160805 Server: BigIP Connection: Keep-Alive Content-Length: 0
Sending e-mail! - - Oracle 8i specific response
Thanks for that question, Leonardo.
Answered by: Tom Kyte Last updated: May 30, 2013 - 2:58 pm UTC
Category: Application Server Version: 8.1.5
How to send out personalized email to clients registered inside my portal while using information held in our Database Oracle 8i automatically?
This is really a sample chapter from my book Expert One on One Oracle - it describes tips on how to send email from Oracle versions 816 and the java only approach described about halfway through works in 815 greater UTLSMTP and sending mail UTLSMTP, introduced to the first time in Oracle 8.1.6, is surely an interface on the Simple Mail Transfer Protocol. It requires that you've an SMTP server inside your network somewhere? most sites I have been to obtain at least one SMTP server running as it's the most popular way of sending mail. The UTLSMTP package is best suited for sending small, text only emails in the database. While its API props up sending of attachments and the rest? it can be left to your account to actually encode the multi-part document? for instance turning binary attachments into mime-encoded documents. Weve already seen the way to use UTLSMTP within the DBMSJOB section where we managed to get apparently execute faster by carrying it out asynchronously. In this section we?ll revisit that example, build upon it? adding additional functionality. We will also have a look at an alternative to UTLSMTP that delivers somewhat additional functionality? such as ability to simply send attachments with all the email. Since SMTP is usually a very low level protocol, well reuse existing public domain code for getting an SMTP interface at a lot higher level? and well understand with not much code. UTLSMTP? a bigger example In the DBMSJOB section, we explored how you can make sending email using UTLSMTP apparently execute faster. We also made email transactional in the wild in that section? when you rollback the email isn't getting sent, in case you commit? out it's going. I recommend the use of DBMSJOB as being a layer in your emails routines hence. In that section, the example UTLSMTP routine we used was: tkyteTKYTE816 create or replace 2 PROCEDURE sendmail psender IN VARCHAR2, 3 precipient IN VARCHAR2, 4 pmessage IN VARCHAR2 5 as 6 lmailhost VARCHAR2255: ; 7 lmailconn ; 8 BEGIN 9 lmailconn: connectionlmailhost, 25; 10 lmailconn, lmailhost; 11 lmailconn, psender; 12 lmailconn, precipient; 13 datalmailconn ; 14 datalmailconn, pmessage; 15 datalmailconn ; 16 lmailconn; 17 end; 18Procedure created. tkyteTKYTE816 begin 2 sendmail, 3, 4 Hello Tom ; 5 end; 6PL/SQL procedure successfully completed. That works OK but is quite limited in the wild. It sends email to exactly one recipient, you simply can't CC or BCC anyone, you are unable to setup a topic - - the email always arrives using a?blank? subject line. We would like to back up more options using this package. A full discussion of all possibilities with UTLSMTP would require comprehensive knowledge on the SMTP protocol itself? something which is away from scope of the book. Readers thinking about all from the opportunities provided with SMTP should review RFC812? which could be the description of SMTP. This is available on the internet at
Below, I will simply present tips on how to send a communication using UTLSMTP that supports: o Multiple?to? recipients o Multiple?cc? recipients o Multiple?bcc? recipients o A single body up to 32k bigger o A subject line o A descriptive?from? line rather than showing precisely the email address because?from? within the email client A specification for the PLSQL package that supports it might look like the subsequent. In here, we define an assortment type to allow for just a caller to only send an index of recipients along with provide the external specification in the PLSQL routine i will be implementing: tkyteTKYTE816 create or replace package mailpkg 2 as 3 type array is table of varchar2255; 4 5 procedure send psenderemail in varchar2, 6 pfrom in varchar2, 7 pto in array default array, 8 pcc in array default array, 9 pbcc in array default array, 10 psubject in varchar2, 11 pbody in long ; 12 end; 13Package created. The package body due to this implementation is fairly straightforward? if understand just enough in the SMTP protocol and what an e-mail looks like how email clients receive the From, To, CC and many others. Before we look for the code, we?ll examine what a contact might actually appear like. Consider the subsequent ASCII text: Date: 13 May 01 12:33:22 From: Oracle Database Account Subject: This can be a subject To:, Cc: Hello Tom, this can be a mail you will need That is what you'd probably transmit since the body from the email using UTLSMTP to own the email client set the From, Subject, and many others. There are no SMTP commands to do this magic, rather, this header info is placed right inside body in the email itself? separated in the text from the email by way of a blank line. Once we recognize that? sending a contact with the many options we require is pretty easy. The only thing we'd like to understand beyond that is certainly that in order to deliver the email to more and another recipient, we merely call more then once? with various names. That?s the many information we end up needing to know then to transmit an email. So, here's the package body. We start having a couple of constants and globals. You will naturally need to customize the gmailhost to get the name of a server you need to get, Aria is my machine inside Oracle? you'll not be in a position to access that: tkyteTKYTE816 create or replace package body mailpkg 2 as 3 4 gcrlf char2 default chr13chr10; 5 gmailconn ; 6 gmailhost varchar2255: ; 7 Next we have an enclosed unpublished function for you an email to many people recipients? it essentially addresses the email. At a similar time, it builds the?To:? or?Cc:? lines that any of us?ll eventually send as part on the email itself and returns that formatted string. It was implemented being a separate function since we end up needing to try this separately with the To, CC, and BCC lists: 8 function addressemail pstring in varchar2, 9 precipients in array return varchar2 10 is 11 lrecipients long; 12 begin 13 for i in 1. 14 loop 15 gmailconn, precipientsi ; 16 if lrecipients is null 17 then 18 lrecipients: pstring precipientsi ; 19 else 20 lrecipients: lrecipients, precipientsi; 21 end if; 22 end loop; 23 return lrecipients; 24 end; 25 26 Now we now have the implementation of our own published function? normally the one people will actually call to deliver mail. It starts with an indoor procedure writeData that is certainly used to simplify the sending from the email headers the To:, From:, Subject: records. If the header record is NOT NULL, this routine makes use of the appropriate UTLSMTP call to transmit it? along together with the necessary end of line marker the carriage return/line feed: 27 procedure send psenderemail in varchar2, 28 pfrom in varchar2 default NULL, 29 pto in array default array, 30 pcc in array default array, 31 pbcc in array default array, 32 psubject in varchar2 default NULL, 33 pbody in long default NULL 34 is 35 ltolist long; 36 lcclist long; 37 lbcclist long; 38 ldate varchar2255 default 39 tochar SYSDATE, dd Mon yy hh24:mi:ss ; 40 41 procedure writeData ptext in varchar2 42 as 43 begin 44 if ptext just isn't null 45 then 46 data gmailconn, ptext gcrlf ; 47 end if; 48 end; Now we have been ready to really send the mai. This part just isn't very different from your very simple routine we started with. It begins in precisely the same fashion? by connecting towards the SMTP server and starting a session: 49 begin 50 gmailconn: connectiongmailhost, 25; 51 52 gmailconn, gmailhost; 53 gmailconn, psenderemail; 54 Here is where it differs, rather than calling once? it uses are addressemail function to it is known as potentially frequently, building the?To:? and?Cc:? list for individuals as well. It builds the BCC list but we won?t actually send that people don?t want the recipients to find out that list! 55 ltolist: addressemail To:, pto ; 56 lcclist: addressemail Cc:, pcc ; 57 lbcclist: addressemail Bcc:, pbcc ; 58 Now, we utilize OPENDATA call to start out sending the body from the email. The code on lines 61 through 68 generates the header portion of data. Line 69 sends the body from the email the contents in the email and line 70 terminates the email for people. 59 datagmailconn ; 60 61 writeData Date: ldate ; 62 writeData From: nvl pfrom, psenderemail ; 63 writeData Subject: nvl psubject, no subject ; 64 65 writeData ltolist ; 66 writeData lcclist ; 67 68 data gmailconn, gcrlf ; 69 datagmailconn, pbody ; 70 datagmailconn ; 71 gmailconn; 72 end; 73 74 75 end; 76Package body created. And that?s it, now since I have numerous email addresses, , , I can test this API such as this: tkyteTKYTE816 begin 2 3 psenderemail , 4 pfrom Oracle Database Account, 5 pto , , 6 pcc , 7 pbcc , 8 psubject This is often a subject, 9 pbody Hello Tom, this is actually the mail you'll need ; 10 end; 11PL/SQL procedure successfully completed. And that call is what generated the ASCII text: Date: 13 May 01 12:33:22 From: Oracle Database Account Subject: This is often a subject To:, Cc: Hello Tom, this is actually the mail you would like We saw above? that's what got provided for all of those recipients? including, although we simply cannot see that recipient because it was bcc?ed. That covers most with the typical uses from the UTLSMTP supplied package. Above I did say it's capable of sending email with attachments and the like but that may require an inordinate quantity of effort on our part. We would need to: o Learn tips on how to format a multi-part mime encoded document, no small feat o Base-64 encode binary data or use some equivalent encoding technique including uuencoding, binhex, and so forth That will be conservatively several hundred, otherwise thousands of lines of PL/SQL code. Rather then do this, I will report that you make use of the already written and intensely robust JavaMail API as described below. Loading and while using the JavaMail API In order to makes use of the UTLSMTP package, you have to already have a very Java enabled database in Oracle8i. This is because UTLSMTP utilizes UTLTCP and UTLTCP subsequently is built on Java functions. Remember, when you dont possess a Java enabled database you may use UTLHTTP as described above to deliver simple emails. So, should you are competent to use UTLSMTP, you have to have a Java enabled database, you can go on the Sun website and download their JavaMail API. This will provide us with the ability to send out much more complicated emails on the database; including attachments. The following is determined by work performed with a coworker of mine, Mark Piermarini who helps me out with a great deal of my Java issues. If you go to
youll be capable of download their JavaMail API. The download you have will consist of a number of hundred files; merely one of which we are serious about. After you download the JavaMail API? ensure that also to obtain their the JavaBeansTM Activation Framework extension or JAF. This is needed to own the JavaMail API package. After you have downloaded the two of these sets of files? you will ought to extract on the JavaMail APIdownload and on the JAF download. This is whatever you will need because of this? go ahead and read through the documentation, there can be a lot of functionality in there we have been not using, were just while using the send an e-mail part with the API. The API includes functions for receiving mail also from IMAP, POP, along with sources. We will ought to load the and in to the database using loadjava but before we are able to do that individuals must repackage them. These jar files are compressed within a format which is not understood through the database byte code interpreter. You have to unjar and rejar them without compression or make use of a tool for example WinZip to rejar them right into a zip file. What I did on Windows 2000 was: 1. Used WinZip to extract the items in into my c:tempmail directory 2. Used WinZip to produce a new archive 3. Put the valuables in c:tempmail. including subdirectories into this new archive I did exactly the same thing for? only replacing mail with activation from the above steps. Now we have been ready to load these zip or jar files, whatever you decide to named them to the database. These must be loaded with all the SYS user simply because they have protected Java packages that regular users cannot upload. We makes use of the commands: loadjava - u sys/manager - o - r - v - f - noverify - synonym - g public loadjava - u sys/manager - o - r - v - f - noverify - synonym - g public Where: o - u sys/manager: may be the userid and password for the SYS account. As stated previously, some from the packages are protected and have to be loaded as SYS o - o: is shorthand for?oci8, I am while using the oci8 driver. You could utilize the thin driver likewise but youll ought to modify the command to take action o - r: is short for?resolve. This will resolve all external references from the loaded classes and helps to verify which the loaded java classes will be capable of function even as load them o - v: is short for?verbose. This gives us something to perform while loadjava is running. We can view it work through each step of the process. o - f: is short for?force. This isnt necessary within the first load but is OK to work with. If you try a loadjava colliding with an error, you may correct it, and reload? then you should either must use the dropjava command to decrease the jar file on the database or use?force. Using?force just makes it easier for people. o - noverify: won't attempt to verify the bytecode. You has to be granted Verifier to complete this option. In addition, this program must be used jointly with - r. SYS has this privilege. This is needed as the bytecode verifier will flag some issues while using file and also this works around that issue. o - synonym: creates public synonyms of these classes. Since we won't install the mail java code we write as SYS, this gives us to view the SYS loaded java classes. o - g public: grants execute on these loaded classes to PUBLIC. If this is just not desirable, modify the?g to be only the user you need to create the send mail routines in, one example is - g UTILITYACCT. You can find out much more about loadjava and also the above options from the Oracle8I Java Developers Guide. After these packages are loaded, we're also ready to produce a Java stored procedure to essentially send the mail. This procedure will act as being a thin layer on top from the JavaMail API and may let us ultimately write a PL/SQL binding layer together with the following spec: tkyteTKYTE816 desc send FUNCTION send RETURNS NUMBER Argument Name Type In/Out Default? - -------- - ------ - -- - -- PFROM VARCHAR2 IN PTO VARCHAR2 IN PCC VARCHAR2 IN PBCC VARCHAR2 IN PSUBJECT VARCHAR2 IN PBODY VARCHAR2 IN PSMTPHOST VARCHAR2 IN PATTACHMENTDATA BLOB IN PATTACHMENTTYPE VARCHAR2 IN PATTACHMENTFILENAME VARCHAR2 IN This function will give to us the chance to use CCs and BCCs and send an attachment. It is left being an exercise to the reader to implement passing arrays of BLOBs or overloading this to back up CLOB or BFILE types for attachments likewise. The Java stored procedure we are going to create follows. It uses principle functionality in the JavaMail API class and is fairly straightforward. Again, were not going into all the uses in the JavaMail API that may be a book by itself, the basics here. The?mail? class below features a single method?send?. This could be the method we're going to use to transmit a message. As it truly is implemented, it returns is there a if it can be successful in sending the meial along with a 0 otherwise. This implementation is extremely basic? it could be a lot more sophisticated, providing support for a lot of attachment types CLOBS, BFILES, LONGS etc. It could even be modified to report back on the caller the complete error received from SMTP like?invalid recipient, no transport, and so forth. tkyteTKYTE816 create or replace and compile 2 java source named mail 3 as 4 import ; 5 import ; 6 import ; 7 import ; 8 import ; 9 import ; 10 import ; 11 import ; 12 import ; 13 14 public class mail 15 16 static String dftMime application/octet-stream; 17 static String dftName ; 18 19 public static 20 sendString from, 21 String to, 22 String cc, 23 String bcc, 24 String subject, 25 String body, 26 String SMTPHost, 27 attachmentData, 28 String attachmentType, 29 String attachmentFileName The above argument list matches up while using SQL call specification we outlined above? the arguments are mainly self explanatory. The two which may need some clarification are definitely the attachmentType as well as the attachmentFileName. The attachmentType must be a MIME Multi-purpose Internet Mail Extensions type? perhaps you might be familiar with from HTML documents. The MIME form of a GIF image for instance is?image/gif?, the mime form of a plain text document will be?text/plain?, an HTML attachment will be?text/html? and so forth. The attachmentFileName with this example is NOT the category of an existing OS file that could be attached but alternatively the filename with the attachment within the email itself? what are the recipient on this email will spot the name on the attachment as. The actual attachment is the that's sent to the present routine. Now, on top of the body on the code. We begin by setting the session? to your name on the SMTP host the caller delivered to us? the JavaMail API reads this value when deciding what SMTP server for connecting to: 30 31 int rc 0; 32 33 try 34 35 Properties props ; 36, SMTPHost; 37 Message msg 38 new props, null; 39 Next, we setup the email headers. This part tells the JavaMail API who your message if from, who to send out it to, who to send out a?carbon copy? cc or?blind carbon copy? bcc, exactly what the subject on the email is and what date must be associated using the email: 40 new InternetAddressfrom; 41 42 if to! null 0 43, 44 to, false; 45 46 if cc! null 0 47, 48 cc, false; 49 50 if bcc! null 0 51, 52 bcc, false; 53 54 if subject! null 0 55 subject; 56 else no subject; 57 58 new Date; 59 Next, we use one of two methods to send out an email. If the attachmentData argument isn't null, then we shall MIME encode the email? a normal that props up sending of attachments as well as other multi-part documents. We accomplish this by putting together multiple MIME areas of the body? on this case a pair of them, one for your body from the email the text along with the other for your attachment itself. Lines 76 through 78 take some additional explanation. They are how we can easily send a contact via a BLOB. The JavaMail API doesn?t comprehend the type natively it's after all a plain API. In order to send out the BLOB attachment, we need to provide a method for your JavaMail API to get for the BLOB data. We accomplish this by creating our personal DataHandler? a class having an interface how the JavaMail API understands tips on how to call in order to acquire data to populate the attachment. This class BLOBDataHandler is implemented by us as being a nested class below. 60 if attachmentData! null 61 62 MimeBodyPart mbp1 new MimeBodyPart; 63 body! null? body: ; 64 ; 65 66 MimeBodyPart mbp2 new MimeBodyPart; 67 String type 68 attachmentType! null? attachmentType: dftMime; 69 70 String fileName attachmentFileName! null? 71 attachmentFileName: dftName; 72 73 ; 74 fileName; 75 76 new 77 DataHandlernew BLOBDataSourceattachmentData, type 78 ; 79 80 MimeMultipart mp new MimeMultipart; 81 mbp1; 82 mbp2; 83 mp; 84 If the email won't have an attachment? setting the body from the email is accomplished very simply through single call to setText: 85 else 86 87 body! null? body: ; 88 89 msg; 90 rc 1; 91 catch Exception e 92 93 ; 94 rc 0; 95 finally 96 97 return new rc; 98 99 100 Now for your nested class BLOBDataSource. It simply provides a plain interface for that JavaMail API gain access to our type. It can be quite straightforward in the implementation: 101//Nested class that implements a DataSource. 102 static class BLOBDataSource implements DataSource 103 104 private BLOB data; 105 private String type; 106 107 BLOBDataSourceBLOB data, String type 108 109 type; 110 data; 111 112 113 public InputStream getInputStream throws IOException 114 115 try 116 117 ifdata null 118 throw new IOExceptionNo data.; 119 120 return ; 121 catchSQLException e 122 123 throw new 124 IOExceptionCannot get binary input stream from BLOB.; 125 126 127 128 public OutputStream getOutputStream throws IOException 129 130 throw new IOExceptionCannot make this happen.; 131 132 133 public String getContentType 134 135 return type; 136 137 138 public String getName 139 140 return BLOBDataSource; 141 142 143 144Java created. Now we have the Java class suitable for PL/SQL to bind to, we end up needing to create that binding routine to map the PL/SQL types thus to their Java Types as well as bind the PL/SQL routine to the Java class. That is simply: tkyteTKYTE816 create or replace function send 2 pfrom in varchar2, 3 pto in varchar2, 4 pcc in varchar2, 5 pbcc in varchar2, 6 psubject in varchar2, 7 pbody in varchar2, 8 psmtphost in varchar2, 9 pattachmentdata in blob, 10 pattachmenttype in varchar2, 11 pattachmentfilename in varchar2 return number 12 as 13 language java name , 14, 15, 16, 17, 18, 19, 20, 21, 22 23 return ; 24Function created. Now, abdominal muscles last thing we should do before applying this is to ensure our user the owner in the above mail class and send stored procedure has sufficient privileges to carry out the routine. Those would be the subsequent: sysTKYTE816 begin 2 permission 3 grantee TKYTE, 4 permissiontype , 5 permissionname, 6 permissionaction read, write 7 ; 8 permission 9 grantee TKYTE, 10 permissiontype , 11 permissionname, 12 permissionaction connect, resolve 13 ; 14 end; 15PL/SQL procedure successfully completed. Note that within the grant on, I used a wildcard from the permissionname. This allows TKYTE to get in touch to and resolve ANY host. Technically, we might put in there precisely the name from the SMTP sever as well as using. That can be the minimal grant we needed. This is needed as a way to resolve the hostname individuals SMTP host and connect to it. The other permission, , is needed to be able to set the in your sessions properties. Now we're ready to test. I reused some code from your DBMSLOB section where we a routine loadafile. I modified that plus the DEMO table to own a BLOB column as an alternative to a CLOB and loaded the file we loaded in like a class into this demo table. Now I can use the next PL/SQL block to deliver it to myself being an attachment within an email through the database: tkyteTKYTE816 set serveroutput on size 1000000 tkyteTKYTE816 exec output 1000000 tkyteTKYTE816 declare 2 retcode number; 3 begin 4 for i in select theBlob from demo 5 loop 6 retcode: send 7 pfrom , 8 pto , 9 pcc NULL, 10 pbcc NULL, 11 psubject Use the attached Zip file, 12 pbody to transmit email with, 13 psmtphost , 14 pattachmentdata , 15 pattachmenttype application/winzip, 16 pattachmentfilename ; 17 if retcode 1 then 18 line Successfully sent ; 19 else 20 line Failed to transmit ; 21 end if; 22 end loop; 23 end; 24Successfully sent PL/SQL procedure successfully completed. You definitely would like to set serverouput on and call the OUTPUT routine on when testing this. This is considering that the exception has been printed from the Java stored procedure to and also default that could go to a trace file around the server. If you want to find out any errors inside your SQLPlus session, you
How should i send the mails thru oracle 7.1 database as ourt dataBase isn't Oracle 8. can u plz send me ur a similar solution work with Oracle 7.1???
Reviewer: Bijay R. Tuladhar from Hayward, CA
This is one in the most useful solutions. Thank you Tom for helping you!
Excelent, but sending mails is discussed, why not consider receiving mails.
Reviewer: Shawn from Toronto, ON, Canada
I experimented with un-jar them and re-jar the files. while using the loadjava I am getting a exception. Any suggestions? Or would you send me the re-jared files and let me know where to acquire them. Thanks,
The error message is: loadjava - u user/paswddb - o - r - f - v initialization complete loading: mail creating: mail resolver: resolving: mail errors: mail ORA-29535: source requires recompilation mail:31: Class Message not found. mail:31: Class MimeMessage not found. mail:37: Variable msg might not have been initialized. mail:39: Variable msg may possibly not have been initialized. mail:41: Variable msg might not have been initialized. mail:44: Undefined variable or class name: Transport Info: 6 errors loadjava: 8 errors Can anyone help me out? Thanks before hand.
Reviewer: Rajesh Jaswal from Hoshiarpur, Punjab
Reviewer: Akthar amp; Kamalanathan - from Singapore
Neatly carried out with correct step, We would like to commentchecklist something on positive sense, 1. First to get started with Check whether JVM for Oracle is installed, else run add classpath the steps 1, 2, 3, 4 given from the TOMs response with just have to change on 4 you should desc send not desc mail. Step 5 make changes to fit your SMTP HOST. 4. You are Wish u Happy Oracle Mailing on 8.1.5.
October 25, 2001 - 1:11 am UTC
Dont you would imagine that inside sentence loadjava parameter - s synonym for and elso has to be present?
December 28, 2001 - 10:11 am UTC
It is nice but tips on how to attach file to my e-mail?
January 26, 2002 - 10:25 pm UTC
Dears, When running on 3 i got the subsequent errors. Can anyone help me out from it? D:mail loadjava - u marchant/marchantitcmis - o - r - f - v arguments: - u marchant/marchantitcmis - o - r - f - v creating: source mail loading: source mail creating: mail resolving: source mail errors: source mail ORA-29535: source requires recompilation mail:31: Class Message not found. mail:31: Class MimeMessage not found. mail:37: Variable msg mightn't have been initialized. mail:39: Variable msg mightn't have been initialized. mail:41: Variable msg may possibly not have been initialized. mail:44: Undefined variable or class name: Transport Info: 6 errors The following operations failed source mail: resolution exiting: Failures occurred during processing Thanks
use NOVERIFY also. On Januarary 27th, 2002 - - I totally rewrote the answer for this. The answer above is actually an extract from my book which includes better step by Follow those.
January 27, 2002 - 3:08 am UTC
HI all While loading Jar files I am getting these error, can any body figure out why?? loadjava - u sys/changeoninstall - o - r - v - g public : oracle/jdbc/driver/OracleDriver at :526 at :442 at :93 1 with a:1149 at :1021 at :193 at :49
January 28, 2002 - 11:07 pm UTC
I tried to send out email from D2K but it really failed. I used TYPE according to your writings earlier, nonetheless it shows error, because OBJTYPE isn't a procedure. How it is going to be solved? Would you please provide me a solution?
January 31, 2002 - 4:57 am UTC
hi, I tried the primary example, it doesn't seem to work. Any Idea? thanks beforehand Yogeeraj SQL begin sendmail, , Hello Deg ; end;2 3 4 5 6 begin ERROR at line 1: ORA-20001: 421 Service unavailable ORA-06512: at SMTP, line 83 ORA-06512: at SMTP, line 121 ORA-06512: at MAIL, line 8 ORA-06512: at line 2 SQL
in college not make use of a valid mail host within your sendmail routine. You are getting a blunder back through the smtp server which isnt an smtp server saying im inaccessible you did change: 5 as 6 lmailhost VARCHAR2255: ; 7 lmailconn ; 8 BEGIN to obtain a hostname that could be valid available for you right?
February 01, 2002 - 6:40 am UTC
Hi, many thanks locating the error personally. Indeed, there was clearly an error from the address. sorry for almost any inconveniences. ; For sure, this will help to me proceed within my implementations and research. Best Regards Yogeeraj
February 18, 2002 - 9:33 pm UTC
Tom this mail routine we have been using it since previous few months and is particularly running and mailing well. thank u a lot. I have made some changes to the routine to deliver multiple files by not passing blob array.as would not know I to do this.!!! but by reading files in java program.! I would like to send out u the foundation. Mean I would like to know another thing what decides total attachment size being sent in one mail. In one database sch I can send attachments of 1MB whereas in other Im tied to 6 m cannot find what's restricting me from sending bigger or oracle parameter as those two are on diff unix servers but SMTP is same. Once again Many many thanks for ur continuous support.
February 21, 2002 - 10:01 am UTC
Hi Thomas, Your solutions are just great. I have used your code to deliver email. But I facing a peculiar problem. Once there seemed to be a problem within the SMTP server also it stopped responding, now immediately I fired a mail through the database. The result was that my sesion got hung. Is there however of trapping whole body.
February 25, 2002 - 12:46 am UTC
Hi Check the trace file generated in on your own server u may receive the exacty nature of problem there.
February 25, 2002 - 1:40 pm UTC
Reviewer: Bob Yexley from Dayton, OH USA
Thanks so much just for this solution. If I can understand it working, it will probably be a HUGE help and solution for your needs. I am wanting to follow the instructions outlined here, and did everything they said to accomplish, but am having problems together with the loadjava command for When I ran it, it loaded everything fine, but ran into problems when trying to solve referenced objects. Im getting ORA-29534, and also the result is 45 unresolved object references following load. The loading from the worked great, no problems in any way, but had difficulty with SOME with the objects in Here is one example on the errors that I am getting: skipping: com/sun/mail/imap/RightsRight has already been resolved skipping: javax/mail/IllegalWriteException has already been resolved skipping: com/sun/mail/iap/Argument has already been resolved resolving: com/sun/mail/smtp/SMTPMessage errors: com/sun/mail/smtp/SMTPMessage ORA-29534: referenced object /mail/internet/MimeMessage can't be resolved resolving: javax/mail/internet/MimeMessage errors: javax/mail/internet/MimeMessage ORA-29521: referenced name javax/activation/DataHandler could hardly be found ORA-29521: referenced name javax/activation/DataSource couldn't be found resolving: javax/mail/FolderClosedException errors: javax/mail/FolderClosedException ORA-29534: referenced object /mail/Folder could hardly be resolved Any idea whats wrong, and/or how I can repair it?? - ::YEX::-
show me a cut and paste within your loadjava command.
February 26, 2002 - 1:24 pm UTC
Can you reload their activation and mail ZIP files using another user? This will facilitate debugging and we are able to use it to determine the resolver for almost any problems. Also, add - debug in your loadjava commands and send that output to
February 26, 2002 - 1:39 pm UTC
Reviewer: Raza from Toronto, Canada
I was trying toms example 1 and possess this error! can a single help me out begin psenderemail , pfrom Oracle Database Account, pto , , pcc , pbcc , psubject This is really a subject, pbody Hello Raza, this is actually the mail you will need ; end; ORA-29540: class oracle/plsql/net/TCPConnection will not exist ORA-06512: at TCP, line 678 ORA-06512: at TCP, line 247 ORA-06512: at SMTP, line 99 ORA-06512: at SMTP, line 121 ORA-06512: at PKG, line 49 ORA-06512: at line 2 and what has to be done!!!???
search for ORA-29540 on this internet site.
February 26, 2002 - 3:29 pm UTC
this really should not be done in the network - - the file that you are loading must be the main one on the server anyway dont make use of the network.
February 26, 2002 - 4:03 pm UTC
Do we'd like to do precisely the same things for Oracle9i when you described on this detailed instruction? If it can be different, can you explain what's more, it in detail? Thanks a lot! Harvey
should are employed in 9i, havent loaded it down myself confirmed but the steps would basically be precisely the same you dont ought to use sys and in all probability wont be capable to use sys generally in 9i, that could be different yes, you'll need to try this in 9i in the event you wanted to deliver email with attachments.
February 26, 2002 - 5:43 pm UTC
Thx on your Valuable ideas We have succefully implmented the SMTP mail with any attachments Including Binary in Pure oracle code i.e It Converts Binary to Base 64 format Thx Ashok
February 27, 2002 - 9:58 am UTC
I cant understand it work! I have two instances running about the same machine, I have opened the telnet session on box where my database is, and seeking to load by issuing these command. RCISDEV loadjava - user sys/changeoninstallrcisdvl And getting this error. SQL Error while connecting with oci8 driver to rcisdvl: ORA-01031: insufficient privileges couldn't open connection loadjava: 2 errors I checked my ORACLE SID and that is set to rcisdvl if I issue loadjava without rcisdvl RCISDEV loadjava - user sys/changeoninstall Then I have this error!! SQL Error while connecting with oci8 driver to default database: ORA-01034: ORAC LE hard to get at ORA-27101: shared memory realm won't exist IBM AIX RISC System/6000 Error: 2: No such file or directory can't open connection loadjava: 2 errors What must be done!!! you advice Thanks before hand Raza
Followup February 27, 2002 - 10:44 am UTC
You should log in because Oracle software owner. You should verify your oracle home and oracle sid You should verify that you are able to then: sqlplus sys/changeoninstall then run loadjava.