sage 50 premium accounting 2015 downloadquicken deluxe 2011 trial downloadroxio easy media creator 7 msi downloadpajama sam 3 you are what you eat free download
An error occurred. Code: 19f1c056-6580-489e-b034-24abdf5572f7
Please attempt to access the feature again by pressing the trunk button within the browser.
Error information continues to be sent to they.
If you might have any comments, suggestions or questions, you can write to Contact Us. We like to know from you.
Oracle announces beta accessibility of Oracle Database 12 c, Release 2 providing more agility and scalability for cloud deployments.
Welcome on the most comprehensive portfolio of cloud solutions for the business, IT infrastructure, and development needs.
What key performance indicators matter from the Digital Age, and ways in which do you measure their value for the business? New global research by CIMA shows ways to build a next-generation finance function capable of capture the worthiness being put together by digital technologies.
Market-leading vertical software running your core business.
Recruit, develop, and retain top talent having 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 a company manager has to know.
Oracle President Thomas Kurian discusses the benefits of Oracle Database within the Oracle Cloud.
Transform your organization with Oracle Cloud.
Oracle Marketing Cloud creates ideal customers.
Learn what sort of Oracle Cloud Platform can accelerate your small business.
Platform being a service enables you to rapidly develop scalable apps.
Oracle Cloud Platform like a Service is designed for developers.
IDC Research weighs in on Platform as being a Service.
Discover tips on how to drive innovation.
Cloud could be the only way for companies to obtain the speed and innovation they really need.
Finding the appropriate library.
Under memo of understanding with Tencent Cloud, Oracles portfolio of cloud services will probably be offered in China.
In-depth articles on Oracle technology now with your smartphone and tablet.
Data Capital is usually a foundation for that future.
Oracles Configure, Price, Quote tool is transforming selling practices.
See what CERN European Laboratory for Particle Physics discovered.
Oracle DIVArchive Suite helps MLB Network manage 7 petabytes of video content annually.
Hitachi moved 650 subsidiaries to centralized recruiting.
When DX Marketing was required to scale up and reduce costs, there is only one spot 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 very best practices and new solutions on 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 announces beta accessibility to Oracle Database 12 c, Release 2 providing more agility and scalability for cloud deployments.
Welcome to your most comprehensive portfolio of cloud solutions for the business, IT infrastructure, and development needs.
What key performance indicators matter within the Digital Age, and just how do you measure their value towards the business? New global research by CIMA shows tips on how to build a next-generation finance function capable of capture the additional value being put together 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 Oracle s complete enterprise cloud.
Everything an organization manager must know.
Oracle President Thomas Kurian references the benefits of Oracle Database inside the 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 organization.
Platform like a service allows you to rapidly develop scalable apps.
Oracle Cloud Platform being a Service is manufactured for developers.
IDC Research weighs in on Platform to be a Service.
Discover how you can drive innovation.
Cloud is definitely the only way for companies to have the speed and innovation they need.
Hunting down hard-to-find errors.
Under memo of understanding with Tencent Cloud, Oracle s portfolio of cloud services is going to be offered in China.
In-depth articles on Oracle technology now with your smartphone and tablet.
Data Capital can be a foundation to the future.
Oracle SuperCluster and Oracle ZFS Storage Appliance have boosted performance 17x for the cycling innovator.
Oracle ERP, EPM, and Sales Cloud are improving the Silicon Valley YMCA boost its membership.
Oracle DIVArchive Suite helps MLB Network manage 7 petabytes of video content annually.
Oracle Exalytics and Oracle Business Intelligence are enabling start up company opportunities.
When DX Marketing were required to scale up and save money, 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 greatest 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 most powerful 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 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 to the question, Leonardo.
Answered by: Tom Kyte Last updated: May 30, 2013 - 2:58 pm UTC
Category: Application Server Version : 8.1.5
How to transmit personalized email to clients registered around my portal with all the information saved in our Database Oracle 8i automatically?
This is usually a sample chapter from my book Expert One on One Oracle - it describes the best way to send email from Oracle versions 816 far better the java only approach described about halfway through works in 815 greater UTLSMTP and sending mail UTLSMTP, introduced for your first time in Oracle 8.1.6, can be an interface on the Simple Mail Transfer Protocol. It requires that you could have an SMTP server inside your network somewhere? most sites I have been to get at least one SMTP server running which is the most popular way of sending mail. The UTLSMTP package is best suited for sending small, text only emails from your database. While its API props up the sending of attachments and the rest? it truly is left to you personally to actually encode the multi-part document? for instance turning binary attachments into mime-encoded documents. Weve already seen tips on how to use UTLSMTP inside 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 examine an alternative to UTLSMTP providing you with somewhat far more functionality? such as the ability to only send attachments while using email. Since SMTP can be a very low level protocol, well reuse existing public domain code to obtain an SMTP interface at better level? and well have it with little or no code. UTLSMTP? a bigger example In the DBMSJOB section, we explored tips on how to make sending email using UTLSMTP apparently execute faster. We also made email transactional naturally in that section? in the event you rollback the email doesn't get sent, should you commit? out it's going. I recommend the use of DBMSJOB like a layer on the emails routines thereby. 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 can not setup a topic - - the email always arrives having a?blank? subject line. We would like to aid more options on this package. A full discussion of all possibilities with UTLSMTP would require comprehensive knowledge in the SMTP protocol itself? something which is outside of the scope on this book. Readers thinking about all from the opportunities provided with SMTP should review RFC812? which could be the description of SMTP. This is on the net at
Below, I will simply present the best way to send a message using UTLSMTP that supports: o Multiple?to? recipients o Multiple?cc? recipients o Multiple?bcc? recipients o A single body all the way to 32k in proportions o A subject line o A descriptive?from? line rather then showing precisely the email address because?from? from the email client A specification for the PLSQL package that supports this can look like this. In here, we define an assortment type to allow for any caller to only send a listing of recipients together with provide the external specification with the PLSQL routine we will likely 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 with this implementation is comparatively straightforward? if understand just enough from the SMTP protocol and what a message looks like how email clients obtain the From, To, CC and the like. Before we look for the code, we?ll examine what a contact might actually appear like. Consider this ASCII text: Date: 13 May 01 12:33:22 From: Oracle Database Account Subject: This is really a subject To:, Cc: Hello Tom, this is actually the mail you will need That is what you'd probably transmit since the body from the email using UTLSMTP to obtain the email client set the From, Subject, and many others. There are no SMTP commands for doing that magic, rather, this header data is placed right inside body with the email itself? separated in the text in the email with a blank line. Once we be aware that? sending a contact with every one of the options we'd like is pretty easy. The only thing we end up needing to understand beyond that may be that in order for you the email to more and another recipient, we just call more then once? with various names. That?s the many information we want to know then to deliver an email. So, this can be a package body. We start using a couple of constants and globals. You will naturally need to customize the gmailhost to get the name of a server you've access to, Aria is my machine in Oracle? you do not be capable of 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 inside unpublished function to send out an email to several recipients? it in place addresses the email. At exactly the same 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 accomplish 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 have now the implementation individuals published function? normally the one people will actually call to send out mail. It starts with an interior procedure writeData that may be used to simplify the sending on the email headers the To:, From:, Subject: records. If the header record is NOT NULL, this routine use the appropriate UTLSMTP call to send out it? along with all 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 were ready to essentially send the mai. This part just isn't very different on the very simple routine we started with. It begins in the identical fashion? by connecting for 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 refer to it potentially frequently, building the?To:? and?Cc:? list for many people as well. It builds the BCC list but we won?t actually send we don?t want the recipients to view that list! 55 ltolist: addressemail To:, pto ; 56 lcclist: addressemail Cc:, pcc ; 57 lbcclist: addressemail Bcc:, pbcc ; 58 Now, we makes use of the OPENDATA call to start out sending the body with the email. The code on lines 61 through 68 generates the header area of data. Line 69 sends the body on the email the contents on the email and line 70 terminates the email for individuals. 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 some of email addresses, , , I can test this API similar to this: tkyteTKYTE816 begin 2 3 psenderemail , 4 pfrom Oracle Database Account, 5 pto , , 6 pcc , 7 pbcc , 8 psubject This is usually a subject, 9 pbody Hello Tom, this is actually the mail you may 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 usually a subject To:, Cc: Hello Tom, this can be a mail you will need We saw above? that may be what got delivered to all of those recipients? including, although we can't see that recipient given it was bcc?ed. That covers most on the typical uses from the UTLSMTP supplied package. Above I did say it really is capable of sending email with attachments etc but that will require an inordinate quantity of effort on our part. We would should: o Learn the best way 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 could be conservatively some hundred, or even thousands of lines of PL/SQL code. Rather then do this, I will advise that you utilize already written and intensely robust JavaMail API as described below. Loading and while using the JavaMail API In order to make use of the UTLSMTP package, you should already use a Java enabled database in Oracle8i. This is because UTLSMTP will depend on UTLTCP and UTLTCP in return is built on Java functions. Remember, in case you dont employ a Java enabled database you can utilize UTLHTTP as described above for you simple emails. So, in the event you are capable to use UTLSMTP, you should have a Java enabled database, you can go on the Sun website and download their JavaMail API. This will impart us with the ability to send out much more complicated emails through the database; including attachments. The following is dependant on 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 will get will consist of a few hundred files; one of which we are thinking about. After you download the JavaMail API? ensure also to acquire their the JavaBeansTM Activation Framework extension or JAF. This is needed to operate the JavaMail API package. After you've downloaded both of these sets of files? you will have to extract in the JavaMail APIdownload and on the JAF download. This is whatever you will need out of this? go ahead and read through the documentation, there is often a lot of functionality in there we're not using, we're just while using the send an e-mail part from the API. The API includes functions for receiving mail also from IMAP, POP, and also other sources. We will ought to load the and in the database using loadjava but before we are able to do that individuals must repackage them. These jar files are compressed inside a format that is certainly not understood with the database byte code interpreter. You ought to unjar and rejar them without compression or work with a tool for example WinZip to rejar them in to a zip file. What I did on Windows 2000 was: 1. Used WinZip to extract the valuables in into my c:tempmail directory 2. Used WinZip to generate a new archive 3. Put the valuables in c:tempmail. including subdirectories into this new archive I did a similar thing for? only replacing mail with activation inside above steps. Now we're also ready to load these zip or jar files, whatever you decide and named them in the database. These should be loaded while using SYS user 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: would be the userid and password on your SYS account. As stated previously, some with the packages are protected and has to be loaded as SYS o - o: is shorthand for?oci8, I am while using the oci8 driver. You could makes use of the thin driver also but youll must modify the command to do this o - r: is short for?resolve. This will resolve all external references within the loaded classes helping verify which the loaded java classes will be capable to function as we load them o - v: is short for?verbose. This gives us something to accomplish while loadjava is running. We can view it work through each step of the company's process. o - f: is short for?force. This isnt necessary about the first load but is OK to utilize. If you try a loadjava thus hitting an error, you may correct it, and reload? then you should either should use the dropjava command to go the jar file in the database or use?force. Using?force just makes it easier for people. o - noverify: will not attempt to verify the bytecode. You have to be granted Verifier to try and do this option. In addition, this approach must be used jointly with - r. SYS has this privilege. This is needed as the bytecode verifier will flag some issues with all the file and this also works around that issue. o - synonym: creates public synonyms because of these classes. Since on the internet install the mail java code we write as SYS, this gives us to find out the SYS loaded java classes. o - g public: grants execute on these loaded classes to PUBLIC. If this isn't desirable, alter the?g to be only the user you wish to create the send mail routines in, for instance - g UTILITYACCT. You can find out a little more about loadjava and also the above options inside the Oracle8I Java Developers Guide. After these packages are loaded, we're ready to generate a Java stored procedure to send the mail. This procedure will act as being a thin layer on top on the JavaMail API and can 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 impart us with the chance to use CCs and BCCs and send an attachment. It is left for an exercise for that reader to implement passing arrays of BLOBs or overloading this to compliment CLOB or BFILE types for attachments too. The Java stored procedure we'll create follows. It uses the essential functionality in the JavaMail API class and is comparatively straightforward. Again, were not going into every one of the uses from the JavaMail API that might be a book itself, the basics here. The?mail? class below carries a single method?send?. This will be the method we are going to use to deliver a message. As it's implemented, it returns is there a if it's successful in sending the meial as well as a 0 otherwise. This implementation is extremely basic? it could be additional sophisticated, providing support for many people attachment types CLOBS, BFILES, LONGS and so forth. It could be modified to report back towards the caller the complete error received from SMTP like?invalid recipient, no transport, and the like. 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 with all the SQL call specification we outlined above? the arguments are typically self explanatory. The two that will need some clarification include the attachmentType along with the attachmentFileName. The attachmentType ought to be a MIME Multi-purpose Internet Mail Extensions type? as you may be familiar with from HTML documents. The MIME style of a GIF image by way of example is?image/gif?, the mime form of a plain text document can be?text/plain?, an HTML attachment can be?text/html? and so forth. The attachmentFileName in this particular example is NOT the domain name of an existing OS file that could be attached but instead the filename on the attachment inside the email itself? just what the recipient in this email will dsicover the name with the attachment as. The actual attachment would be the that is provided for this routine. Now, into the body in the code. We begin by setting the session? for the name from the SMTP host the caller shipped to us? the JavaMail API reads this value when deciding what SMTP server in order to connect 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 create the email headers. This part tells the JavaMail API who the content if from, who for you it to, who to send out a?carbon copy? cc or?blind carbon copy? bcc, the subject in the email is and what date really should be associated together with 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 transmit an email. If the attachmentData argument isn't null, then we are going to MIME encode the email? an ordinary that props up sending of attachments and also other multi-part documents. We do that by establishing multiple MIME limbs? in this particular case 2 of them, one with the body from the email the text as well as the other with the attachment itself. Lines 76 through 78 take some additional explanation. They are how we can easily send an e-mail via a BLOB. The JavaMail API doesn?t comprehend the type natively it really is after all a plain API. In order to deliver the BLOB attachment, we need to provide a method to the JavaMail API to get in the BLOB data. We make it happen by creating our very own DataHandler? a class with the interface how the JavaMail API understands how you can call in order to obtain data to populate the attachment. This class BLOBDataHandler is implemented by us to be 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 doesn't have an attachment? setting the body on the email is accomplished very simply through the 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 to get into our type. It is extremely 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 that any of us have the Java class designed for PL/SQL to bind to, we require to create that binding routine to map the PL/SQL types on their Java Types also to bind the PL/SQL routine for this 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, the last thing we need to do before by using this is to ensure our user the owner in the above mail class and send stored procedure has sufficient privileges to try and do 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 inside permissionname. This allows TKYTE to get in touch to and resolve ANY host. Technically, we will put in there exactly the name from the SMTP sever we will probably be using. That will be the minimal grant we needed. This is needed so as to resolve the hostname of the SMTP host and connect to it. The other permission, , is needed as a way to set the in your sessions properties. Now we're ready to test. I reused some code in the DBMSLOB section where there was a routine loadafile. I modified that and also the DEMO table to get a BLOB column rather then a CLOB and loaded the file we loaded in to be a class into this demo table. Now I can use the next PL/SQL block to deliver it to myself just as one attachment in the email in 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 deliver 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 for you ; 21 end if; 22 end loop; 23 end; 24Successfully sent PL/SQL procedure successfully completed. You definitely wish to set serverouput on and call the OUTPUT routine on when testing this. This is as the exception will be printed because of the Java stored procedure to and also by default that may go in to a trace file within the server. If you want to find out any errors as part of your SQLPlus session, you
How do you send the mails thru oracle 7.1 database as ourt dataBase will not be Oracle 8. can u plz send me ur exactly the same solution help Oracle 7.1???
Reviewer: Bijay R. Tuladhar from Hayward, CA
This is one on the most useful solutions. Thank you Tom for helping you!
Excelent, but sending mails continues to be discussed, why don't you consider receiving mails.
Reviewer: Shawn from Toronto, ON, Canada
I attempted to un-jar them and re-jar the files. when using the loadjava I am getting a exception. Any suggestions? Or are you able to send me the re-jared files and identify where to have 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 mightn't have been initialized. mail:39: Variable msg mightn't have been initialized. mail:41: Variable msg mightn't have been initialized. mail:44: Undefined variable or class name: Transport Info: 6 errors loadjava: 8 errors Can anyone assist me out? Thanks upfront.
Reviewer: Rajesh Jaswal from Hoshiarpur, Punjab
Reviewer: Akthar amp; Kamalanathan - from Singapore
Neatly carried out with correct step, We want 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 inside TOMs response with replace on step 4 you might have to desc send not desc mail. Step 5 make changes to match 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 the sentence loadjava parameter - s synonym for and elso need to be present?
December 28, 2001 - 10:11 am UTC
It is a useful one but the way to attach file to my e-mail?
January 26, 2002 - 10:25 pm UTC
Dears, When running on 3 i got these errors. Can anyone assist me out of computer? 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 might possibly not have been initialized. mail:39: Variable msg may possibly not 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 too. On Januarary 27th, 2002 - - I totally rewrote the answer to the. The answer above is 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 this error, can any body let me know 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 for you email from D2K however it failed. I used TYPE according to your writings earlier, nonetheless it shows error, because OBJTYPE isn't a procedure. How it will probably 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
you probably did not employ a valid mail host with your sendmail routine. You are getting a blunder back on the smtp server which isnt an smtp server saying im inaccessible you did change: 5 as 6 lmailhost VARCHAR2255: ; 7 lmailconn ; 8 BEGIN to get a hostname that will be valid in your case right?
February 01, 2002 - 6:40 am UTC
Hi, appreciate your locating the error in my opinion. Indeed, there was clearly an error inside address. sorry for almost any inconveniences. ; For sure, this will assist 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 couple of months and it is running and mailing well. thank u a whole lot. I have made some changes to the present routine for you multiple files by not passing blob array.as failed to know I to do this.!!! but by reading files in java program.! I would like to deliver u the original source. Mean I would love to know the one thing what decides total attachment size to become sent in one mail. In one database sch I can send attachments of 1MB whereas in other Im on a 6 m cannot find precisely what is restricting me from sending bigger or oracle parameter as both of these 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 only great. I have used your code to deliver email. But I facing a peculiar problem. Once there were a problem from the SMTP server and it also stopped responding, now at the time I fired a mail in the database. The result was that my sesion got hung. Is there in whatever way of trapping whole body.
February 25, 2002 - 12:46 am UTC
Hi Check the trace file generated in on your own server u may find the exacty nature of problem there.
February 25, 2002 - 1:40 pm UTC
Reviewer: Bob Yexley from Dayton, OH USA
Thanks so much due to this solution. If I can understand working, it will probably be a HUGE help and solution for the needs. I am seeking to follow the instructions organized here, and did everything they said to accomplish, but am having problems while using loadjava command for When I ran it, it loaded everything fine, but ran into problems when trying to end referenced objects. Im getting ORA-29534, as well as the result is 45 unresolved object references following your load. The loading with the worked great, no problems in any way, but had complications with SOME from the objects in Here is one example from the errors that I am getting: skipping: com/sun/mail/imap/RightsRight is resolved skipping: javax/mail/IllegalWriteException is resolved skipping: com/sun/mail/iap/Argument is definitely resolved resolving: com/sun/mail/smtp/SMTPMessage errors: com/sun/mail/smtp/SMTPMessage ORA-29534: referenced object /mail/internet/MimeMessage couldn't be resolved resolving: javax/mail/internet/MimeMessage errors: javax/mail/internet/MimeMessage ORA-29521: referenced name javax/activation/DataHandler couldn't be found ORA-29521: referenced name javax/activation/DataSource can'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 of the loadjava command.
February 26, 2002 - 1:24 pm UTC
Reviewer: Bob Yexley from Dayton, OH USA
Can you reload the two activation and mail ZIP files using another user? This will facilitate debugging and we could use it to look for the resolver for virtually every problems. Also, add - debug for 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 still have this error! can anyone help me out begin psenderemail , pfrom Oracle Database Account, pto , , pcc , pbcc , psubject This can be a subject, pbody Hello Raza, this can be a mail you'll need ; end; ORA-29540: class oracle/plsql/net/TCPConnection won't 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
Reviewer: Raza from Toronto, Canada
this shouldn't be done within the network - - the file you're loading need to be the one around the server anyway dont makes use of the network.
February 26, 2002 - 4:03 pm UTC
Do we'd like to do precisely the same things for Oracle9i while you described within this detailed instruction? If it truly is different, might you explain what's more, it in detail? Thanks a lot! Harvey
should be employed in 9i, havent loaded this myself up to now but the steps would basically be a similar you dont need to use sys and doubtless wont be in a position to use sys generally in 9i, that will be different yes, you'd probably need to accomplish this in 9i in case you wanted to send out email with attachments.
February 26, 2002 - 5:43 pm UTC
Thx for ones 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 have it work! I have two instances running within the same machine, I have opened the telnet session on box where my database is, and looking to load by issuing the subsequent command. RCISDEV loadjava - user sys/changeoninstallrcisdvl And getting this error. SQL Error while connecting with oci8 driver to rcisdvl: ORA-01031: insufficient privileges can't open connection loadjava: 2 errors I checked my ORACLE SID that's set to rcisdvl in case 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 doesn't exist IBM AIX RISC System/6000 Error: 2: No such file or directory couldn't open connection loadjava: 2 errors What needs to be done!!! you advice Thanks ahead of time Raza
Followup February 27, 2002 - 10:44 am UTC
You should log in as being the 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.
Very nice! But i'm looking to get more information regarding UTLSMTP.
Tom, In your pl/sql solution if bcc list is just not written out with writeData, is it possible to explain the way will work? Thanks, Chris
because this: 15 gmailconn, precipientsi ; does the exact sending, the writing from the CC and TO list is merely for display - - the phone call to writedata with this doesnt affect WHO the email is actually shipped to - - just what are the email client displays.
I have followed each of the instructions. And they were successfull also. But when I type this command SQL desc send ERROR: ORA-04043: object send will not exist I obtain the above said error. Can anybody let me. The mail8i and activation8i, are proper. But if anybody features a working version please send on
Tom I downloaded the javamail package according to your note. However, within the archive there isn't a file. Any idea how I will get this?. I downloaded the 1.2 version. Also, appreciate your explaining how bcc list works. Rgds, Chris
It is separate, goto and check for activation.
tom, i run this snippet of code, i receive the error declare lmailhost VARCHAR2255: our mailserver ip; lmailconn ; begin lmailconn: connectionlmailhost, 25; lmailconn, lmailhost; lmailconn, ; lmailconn, ; datalmailconn ; datalmailconn, pakka ma; datalmailconn ; lmailconn; end; ORA-20002: 550 5.7.1 Unable to relay for ORA-06512: at SMTP, line 86 ORA-06512: at SMTP, line 223 ORA-06512: at line 8 is it possible to tell me why? i understand this error whatsoever the email i give inside recpt please help
contact your email guys/network guys. the server you might be attempting to use will not be set up to relay, this is NOT an oracle issue, not only a UTLSMTP issue, it can be a SMTP configuration issue. You are probably with all the WRONG mailhost since it's not setup to relay anti-spamming defense
tom, it is possible to limit within the email body size as if you mentioned with your answer as 32k only. please reply. thanks
Only as I own it coded. I am passing the body as being a single plsql varchar2 variable. If you passed a short-term clob and wrote out 32k with a time, you might make it as large when you wanted. There is no limit well, 4gig
If i have to send out multiple emails, like typicallly. i employ a cursor that returns emails and other detials. i ought to loop and email additional details towards the email address could it be only this way or anyother simple way declare lmailhost VARCHAR2255: our mail server; lmailconn ; gcrlf char2 default chr13chr10; begin lmailconn: connectionlmailhost, 25; lmailconn, lmailhost; for rec in cemailcur loop lmailconn, ; lmailconn, address; datalmailconn ; data lmailconn, Date: sysdate gcrlf ; data lmailconn, Subject: Testing utlsmtp gcrlf ; datalmailconn, To: address gcrlf; datalmailconn, This can be a Reminder for the Notification Received originally on: March 1, 2002. gcrlf; datalmailconn, gcrlf; datalmailconn, The Access Removal form attached requires your immediate attention. gcrlf; datalmailconn, gcrlf; datalmailconn, Access Removal Request For: gcrlf; datalmailconn, gcrlf; datalmailconn ; end loop; lmailconn; end; any suggestions? thanks
Yes, use modular code and factor out repeated processing Write a sendmail routine or just makes use of the ones above. that becomes: begin for rec in loop ; end loop; end;Thats what procedures are only for.
Can you please indicate the way the code should be changed to e-mail a bfile as a possible attachment I should e-mail compressed files inside an OS filesystem. I am just beginning to learn Java and dont even know where to focus on above mentioned problem although I expect a minimum of the BLOBDataSource nested class to vary or a similar class for bfile to become added. By the way - which resources might you suggest for learning Java, originating from an Oracle background?
Should be as simple as changing pattachmenttype to BFILE and opening the BFILE in plsql before calling java - - the api with a bfile in java could be the same to be a blob. You might consider:
it has some nifty utilities within it. It is written to the PLSQL developer that wants to obtain their feet wet by java.
Reviewer: Randy Richardson from St. Louis, MO
Tom, Is there a strategy to validate the TO list before sending? Or do you've to just send and permit the bad contact information fail? We are choosing MS exchange 2000 mail server and would like to perform validation resistant to the address book. Thanks.
Well, the email is coming from your database for the server The address book was in exchange or for the If it is possible to ask MS the way to access the address book via java, we are able to certainly accomplish that. hmm, isnt this how email viruses begin? Im doubtful, a myriad of security complications with accessing the address book you've got to trust the oracle account and I don't realize if Java can access that or otherwise. We could use C also if they support that - - however the security issues abound.
Reviewer: srividhya from bangalore, India
Hi Tom, Thanks a lot to the is really great and dealing had installed within the development database oracle 8.1.6 together with no complications with it. However, when we attemptedto deploy on our live database oracle 8.1.6, we're also facing lots of installation problems. We realized the java option will never be set in the event the database was setup1.several years database dimensions are do we set the java option?We are not competent to set the java option just as one incremental do we do this. Thanks beforehand. Please !!. We are just delayed in making use of it.
tom, would it be possible to track the failure of an e-mail. feel that i am sending email using utlsmtp with TO list has anyone and CC list has 10 persons. now email was deliver to all the CC people but not towards the TO list person. in this particular case i need for you an email with an ADMIN saying email compared to that TO body's failed could it be possible?
the email will bounce tot he REPLY-TO address. set the reply-to to admin. I believe there is undoubtedly an error-to or something like that also. you should have to look up
tom, is it possible to give me just how can set the reply-to address to admin. because as i tried from the following way mail is not delivered to the admin. though the bounced mail come on the from addressee only. declare lmailhost VARCHAR2255: our mail server; lmailconn ; ltoaddr varchar250: ; - - invalid email id lfromaddr varchar250; - - assign the from address here lreplyto varchar250; gcrlf char2 default chr13chr10; begin lmailconn: connectionlmailhost, 25; lmailconn, lmailhost; lmailconn, lfromaddr; lmailconn, ltoaddr; datalmailconn ; data lmailconn, Date: sysdate gcrlf ; data lmailconn, Subject: Testing utlsmtp gcrlf ; datalmailconn, To: ltoaddr gcrlf; datalmailconn, REPLY-TO: lreplyto gcrlf; datalmailconn, This can be a Reminder to get a Notification Received originally on: March 1, 2002. gcrlf; datalmailconn, gcrlf; datalmailconn, The Access Removal form attached requires your immediate attention. gcrlf; datalmailconn, gcrlf; datalmailconn, Access Removal Request For: gcrlf; datalmailconn, gcrlf; datalmailconn ; lmailconn; end;
Reviewer: shamim from New Delhi, India
Great Service done my you TOM Hi Tom Your answer and subsequent followup have become informative. I tried it, doenloaded perfectly but I am facing overuse injury in downloading of, It is showing error while recolving objects, inside the same way as Yexley have. and send the debugged code at, BUt message comes that id doed not exist. So please if he have given some strategy to Yexley problem Forward it in my opinion.
drop north america. in the email address as should happen to be indicated from the bounced email, weve stopped while using country specific domain name
Reviewer: Binh Ta from Maryland, USA
Hi Tom, Very helpful indeed. But I would you answer my follow-up question too please: How can one use PL/SQL to make Appointments in Exchange? Ive searched practically the main internet but found nothing. Would really appreciate when you can shedsome light. Many thanks. Binh Ta.
No idea, I know nothing about exchange. We can do com automatation calls from plsql on NT while using com cartridge.
Reviewer: Munz from Reston, USA
Tom: Do I be aware that if I want to transmit an email but which has a subject line and some text pulled out in the database I can practice it with PL/SQL. I only have to use jAVAMAIL API when I need t osend attachments. THank you,
You never need javamail, you can use utlsmtp 100%. It is just much much easier with javamail to send out attachments, it can the benefit you. UTLSMTP will do for sending text based email
Reviewer: Munz from Reston, USA
Tom: If you do not want make use of named parameters but not cc or bcc anyone in email how will you pass parameters. I am getting a blunder when I do: begin , null, , ,, This can be a subject, Hello Tom, this is actually the mail you'll need ; lineMessage provided for the user successfully; end;Cant you pass null values to a selection. Thanks,
why dont you want to make use of named parameters? they're better then positional, that you are not calling this from SQL so which is not a problem. Otherwise, arrange the parameters to fit your needs but wait, thatll break your other code unless it uses named parameters I would recommend you work with a named parameter, it truly is more readable, less ambigous and when someone changes the transaction on you later - - that you are PROTECTED. You can do that: begin sender email, from, to, , , subj, body ; end;at the same time. You are not passing a clear array - you passed a selection with some blank strings - - distinctive. Just pass empty arrays like I have them defaulted to
TCPConnection class is just not loaded in database I want to send out mail rid of, though the classes are loaded in another db behind the firewall that I can access via a db link. I have tried setting up a synonym for UTLSMTP while using db link. Should this work? I also tried writing a package that accepts the identical inputs send mail does, but simply calls send mail over the db link with all the same arguments that it was called with. This doesnt work either. I get wrong number or type arguments. Can you show how you'd probably call UTLSMTP across a db link coming from a db that doesnt hold the java classes installed?
utlsmtp works on the record. you might be probably not defining your connection record employing this remote utlsmtp package. 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 ; but, sigh, lacking an example plus the error message cut and pasted from sqlplus, its really tough to tell
Reviewer: Sven Bleckwedel from Santos, Brazil
Hi TOM, Your explanation was invaluable to assist me to implement this resource in the database that we administer. When using another character set during my case, WE8ISO8859P1 some problems appeared, but i
Oracle 11g Free Download Latest Version setup for Windows. It is full offline installer standalone setup of Oracle 11g for Windows 32 bit 64 bit PC.
Oracle 11g can be an object relational databasebased management system which s considered since the most robust database software inside the market. Oracle 11g is additionally the leading database management software all on the world. This software product is the standard within the management of data so you don t ought to worry about the size with the data it could manage them easily. You can also Download Oracle 10g for Windows.
Before visiting details of what Oracle 11g seems to have new to the users we must go through principle concept of Oracle s data management procedure. Oracle manages databases inside a relational manner. Software focused on database management were while using hierarchical concept where data was saved in tree like structures. Oracle uses relational based model where details are stored logically in table which can be composed of column who have different attributes. Now you wonder where this g comes from within the title of Oracle s version Oracle 11g. Well Oracle is often a company which has always come on top of some creative strategies to marketing. Like within the 90s internet was the most well liked entity and everyone only agreed to be crazy about having internet. Oracle during those times upgraded their database management version Oracle 8 and named it Oracle 8i we here stands fir internet. This became a very striking move and it also hit the nail within the head. Just in this way now a days grid computation is the next growing trend for enterprises for architecture management hence the letter g is protected which symbolizes grid. You can also Download Oracle 9i that was another great release.
In Oracle 11g there are lots of components that may be installed like Oracle Application Express, Oracle Database Vault, Oracle Configuration Manager and Oracle SQL Developer. Then 11g has Automatic Maintenance Task Management which will give a comprehensive and efficient treating scheduling and allocation of resources like CPU time. Automatic Diagnostic Respiratory is an additional very helpful feature for Oracle 11g. It is really a new management system for storing and organizing whole body diagnostic data and trace files.
Below are a few noticeable features that you just ll experience after Oracle 11g free download.
Object relational database management system.
Leading database management software all on the world.
Numerous new components ready to become installed.
Automatic Maintenance Task Management for scheduling of resources.
Automatic Diagnostic Respiratory included.
Software Full Name: Oracle 11g v11.2.0.1.0
Before you begin Oracle 11g free download, ensure that your PC meets minimum system requirements.
Memory RAM: 1GB of RAM required.
Hard Disk Space: 500MB of free space required.
Click on below button to start out Oracle 11g Free Download. This is complete offline installer and standalone setup for Oracle 11g. This could well be compatible with both 32 bit and 64 bit windows.
Copyright 2013-2015 All Rights Reserved.
Welcome towards the worlds largest community of developers,
admins, and architects using industry-standard technologies
in in conjunction with Oracle products.
Java Magazine : What Will You Build Today?
Phone: 1.800.633.0738 Welcome for the worlds largest community of developers,
admins, and architects using industry-standard technologies
in in conjunction with Oracle products.
DBAs, Developers, SysAdmins, Architects - Something for all! FREE OTN Virtual Tech Summit Replay Library. Watch now!
Java Magazine : What Will You Build Today?
Free, Interactive Tech Info Delivered to Your Desk
Download : Oracle Database Migration Assistant for Unicode 2.1
Phone: 1.800.633.0738 You are having an outdated browser. Please upgrade to your latest version for that best experience.
On the Refine Search results page, select a number of categories of products or services on the left sidebar.
Then for the category with google search, click Select to select your product and release filters, and after that click OK.
For search queries that have multiple words, surround the query with quotes, then resubmit your query. Example: database cloud service
From your home page, select the technology categories to your products or services. If you do not know which category to select, try the subsequent features:
Click the Find a product tab and search for ones product or service.
Click Browse All Products Services in the bottom in the home page to look at an alphabetical directory of products and services.
Welcome to your Oracle Help Center. Whether you might be new to Oracle or perhaps advanced user, you are able to find useful info on our services and products, starting from getting started guides to advanced features.
Choice flexibility having a vast, secure portfolio of products
Delivering performance, simplified management and high availability
Copyright 2015, Oracle and/or its affiliates. All rights reserved.
You are utilising an outdated browser. Please upgrade on the latest version for your best experience.
On the Refine Search results page, select several categories of products or services from your left sidebar.
Then for the category with search engine results, click Select to settle on your product and release filters, after which click OK.
For search queries that includes multiple words, surround the query with quotes, and after that resubmit your query. Example: database cloud service
From the house page, select the technology categories for ones products or services. If you do not know which category to choose, try the next features:
Click the Find a product tab and search for ones product or service.
Click Browse All Products Services on the bottom with the home page to examine an alphabetical report on products and services.
Welcome towards the Oracle Help Center. Whether you're new to Oracle or even an advanced user, you'll be able to find useful specifics of our services, starting from getting started guides to advanced features.
Choice flexibility having a vast, secure portfolio of products
Delivering performance, simplified management and high availability
Copyright 2015, Oracle and/or its affiliates. All rights reserved.