photostage slideshow producer 1 12 downloadnik software color efex pro 3 downloadoracle 8i client software free downloadpdf creator download 64 bit
Thanks with 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 deliver personalized email to clients registered during my portal while using the information saved in our Database Oracle 8i automatically?
How should i send the mails thru oracle 7.1 database as ourt dataBase just isn't 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 probably the most useful solutions. Thank you Tom for helping everyone!
Excelent, but sending mails has become discussed, think about receiving mails.
Reviewer: Shawn from Toronto, ON, Canada
I experimented with un-jar them and re-jar the files. with all the loadjava I am getting a exception. Any suggestions? Or is it possible to send me the re-jared files and identify where to get 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 might possibly not 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 let me out? Thanks ahead of time.
Reviewer: Rajesh Jaswal from Hoshiarpur, Punjab
Reviewer: Akthar amp; Kamalanathan - from Singapore
Neatly through with correct step, We want to commentchecklist something on positive sense, 1. First to begin with Check whether JVM for Oracle is installed, else run add classpath the steps 1, 2, 3, 4 succumbed the TOMs response with replace on step four you have to 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 believe that within the sentence loadjava parameter - s synonym for and elso have to be present?
December 28, 2001 - 10:11 am UTC
It is great but how to require file to my e-mail?
January 26, 2002 - 10:25 pm UTC
Dears, When running on step three i got the next errors. Can anyone assist me to out than 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 may possibly not have been initialized. mail:39: Variable msg might 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 at the same time. On Januarary 27th, 2002 - - I totally rewrote the reply to this. The answer above has become an extract from my book containing 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 inform me why?? loadjava - u sys/changeoninstall - o - r - v - g public : oracle/jdbc/driver/OracleDriver at :526 at :442 at :93 1 in a:1149 at :1021 at :193 at :49
January 28, 2002 - 11:07 pm UTC
I tried to deliver email from D2K nevertheless it failed. I used TYPE per your writings earlier, however it shows error, because OBJTYPE will not be a procedure. How it will likely be solved? Would you please deliver a solution?
January 31, 2002 - 4:57 am UTC
hi, I tried the primary example, this doesn't seem to work. Any Idea? thanks ahead of time Yogeeraj SQL begin sendmail, , Hello Deg ; end;2 3 4 5 6 begin ERROR at line 1: ORA-20001: 421 Service out of stock 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 didn't use a valid mail host with 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 have a hostname that could be valid for you personally right?
February 01, 2002 - 6:40 am UTC
Hi, many thanks for locating the error personally. Indeed, there was clearly an error within the address. sorry for almost any inconveniences. ; For sure, this will aid me proceed during my implementations and research. Best Regards Yogeeraj
February 18, 2002 - 9:33 pm UTC
Tom this mail routine we're also using it since previous couple of months which is running and mailing well. thank u much. I have made some changes to the present routine for you multiple files by not passing blob array.as would not know I for doing that.!!! but by reading files in java program.! I would like to send out u the foundation. Mean I would like to know a very important factor 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 limited by 6 m cannot find precisely what is restricting me from sending bigger or oracle parameter since these two are saved to diff unix servers but SMTP is same. Once again Many many thanks ur continuous support.
February 21, 2002 - 10:01 am UTC
Hi Thomas, Your solutions are just great. I have used your code for you email. But I facing a peculiar problem. Once there was clearly a problem from the SMTP server also it stopped responding, now at that time I fired a mail on the database. The result was that my sesion got hung. Is there however of trapping larger than fifteen.
February 25, 2002 - 12:46 am UTC
Hi Check the trace file generated in in your server u gets the exacty nature of problem there.
February 25, 2002 - 1:40 pm UTC
Reviewer: Bob Yexley from Dayton, OH USA
Thanks much for this solution. If I could possibly get it working, it is going to be a HUGE help and solution for your needs. I am attempting to follow the instructions spelled out here, and did everything the trainer told us to do, but am having issues with the loadjava command for When I ran it, it loaded everything fine, but ran into problems when attempting to resolve referenced objects. Im getting ORA-29534, as well as the result is 45 unresolved object references following your load. The loading from the worked great, no problems in any respect, but had complications with SOME in the objects in Here is one example with 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 couldn't be found ORA-29521: referenced name javax/activation/DataSource could hardly be found resolving: javax/mail/FolderClosedException errors: javax/mail/FolderClosedException ORA-29534: referenced object /mail/Folder cannot be resolved Any idea whats wrong, and/or how I can correct it?? - ::YEX::-
show me a cut and paste within your 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 that we can use it to determine the resolver for almost any problems. Also, add - debug on 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 also have this error! can anyone help me out begin psenderemail , pfrom Oracle Database Account, pto , , pcc , pbcc , psubject This is an interest, pbody Hello Raza, this is actually the 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 needs to become done!!!???
search for ORA-29540 on this website.
February 26, 2002 - 3:29 pm UTC
Reviewer: Raza from Toronto, Canada
this must not be done above the network - - the file you might be loading should be the one about the server anyway dont utilize the network.
February 26, 2002 - 4:03 pm UTC
Do we should instead do a similar things for Oracle9i since you described in this particular detailed instruction? If it really is different, is it possible you explain furthermore, it in detail? Thanks a lot! Harvey
should are employed in 9i, havent loaded it myself to date but the steps would basically be exactly the same you dont have to work with sys and possibly wont be able to work with sys in many instances in 9i, that could be different yes, you would need to try and do this in 9i in the event you wanted for you email with attachments.
February 26, 2002 - 5:43 pm UTC
Thx for the 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 on the identical machine, I have opened the telnet session on box where my database is, and wanting 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 could hardly open connection loadjava: 2 errors I checked my ORACLESID that is set to rcisdvl and when I issue loadjava without rcisdvl RCISDEV loadjava - user sys/changeoninstall Then I understand error!! SQL Error while connecting with oci8 driver to default database: ORA-01034: ORAC LE inaccessible ORA-27101: shared memory realm will not exist IBM AIX RISC System/6000 Error: 2: No such file or directory cannot open connection loadjava: 2 errors What should be carried out!!! you advice Thanks upfront Raza
Followup February 27, 2002 - 10:44 am UTC
You should visit as the Oracle software owner. You should verify your oraclehome and oraclesid You should verify you can then: sqlplus sys/changeoninstall then run loadjava.
Very nice! But how can i get more info on UTLSMTP.
Tom, In your pl/sql solution if bcc list isn't written out with writeData, could you explain the way will work? Thanks, Chris
because this: 15 gmailconn, precipientsi ; does the particular sending, the writing on the CC and TO list is simply for display - - the decision to writedata to be able doesnt affect WHO the email is in fact sent to - - just what email client displays.
I have followed every one of the instructions. And they were successfull also. But when I type the subsequent command SQL desc send ERROR: ORA-04043: object send won't exist I get the above mentined said error. Can anybody assist me to. 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 any 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 these snippet of code, i get larger than fifteen 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 would you tell me why? i understand error no matter what the current email address i give within the recpt please help
contact your email guys/network guys. the server you happen to be attempting to use will not be set up to relay, this is NOT an oracle issue, not just a UTLSMTP issue, it is just a SMTP configuration issue. You are probably utilizing the WRONG mailhost as the not setup to relay anti-spamming defense
tom, it is possible to limit around the email body size just like you mentioned with your answer as 32k only. please reply. thanks
Only as I get it coded. I am passing our bodies as a single plsql varchar2 variable. If you passed a short lived clob and wrote it 32k at the time, you might make it as large because you wanted. There is no limit well, 4gig
If i have for you multiple emails, like typicallly. i've got a cursor that returns contact information and other detials. i want to loop and email additional details on the email address will it be only these 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 is a Reminder for just 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 ; end loop; lmailconn; end; any suggestions? thanks
Yes, use modular code and factor out repeated processing Write a sendmail routine or just make use of the ones above. the idea becomes: begin for rec in loop ; end loop; end;Thats what procedures are only for.
Can you please indicate what sort of code need to become changed to e-mail a bfile being an attachment I have to e-mail compressed files inside an OS filesystem. I am beginning to learn Java and dont even know where to begin with above mentioned problem although I expect at the very least the BLOBDataSource nested class to alter or a similar class for bfile to become added. By the way - which resources can you suggest for learning Java, via an Oracle background?
Should be as elementary as changing pattachmenttype to BFILE and opening the BFILE in plsql before calling java - - the api to read a bfile in java is precisely the same as a blob. You might consider:
it has some nifty utilities inside. It is written for that PLSQL developer that really wants to get their feet wet with many java.
Reviewer: Randy Richardson from St. Louis, MO
Tom, Is there a approach to validate the TO list before sending? Or do you need to just send and permit the bad emails fail? We are using MS exchange 2000 mail server and would like to complete validation resistant to the address book. Thanks.
Well, the email is coming through the database about the server The address book was in exchange or about the If you can ask MS the best way to access the address book via java, we are able to certainly do this. hmm, isnt this how email viruses start? Im doubtful, a myriad of security difficulties with accessing the address book you will need to trust the oracle account and I do not know if Java can access that or you cannot. We could use C at the same time if they support that - - however the security issues abound.
Reviewer: srividhya from bangalore, India
Hi Tom, Thanks a lot with the is really great and dealing had installed around the development databaseoracle 8.1.6 along no difficulty with it. However, when we aimed to deploy on our live databaseoracle 8.1.6, we're facing many installation problems. We remarked that the java option is not set in the event the database was setup1.five years database dimensions are do we set the java option?We are not competent to set the java option for an incremental do we make it happen. Thanks ahead of time. Please !!. We are just delayed in with it.
tom, could it be possible to track the failure connected with an email. believe that i am sending email using utlsmtp with TO list has one individual and CC list has 10 persons. now email was provided for all the CC people but not to your TO list person. in this particular case i need for you an email for an ADMIN saying email fot it 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 a mistake-to or something like that also. you should look it
tom, would you give me just how do set the reply-to address to admin. because as i tried inside following way mail isn't sent on the admin. though the bounced mail come to your 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 is 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 are extremely informative. I tried it, doenloaded perfectly but I am facing condition in downloading of, It is showing error while recolving objects, in precisely the same way as Yexley have. and send the debugged code at, BUt message comes that it id doed not exist. So please if he have given some treatment for Yexley problem Forward it in my opinion.
drop america. through the email address as should are actually indicated inside bounced email, weve stopped with all the country specific domain name
Reviewer: Binh Ta from Maryland, USA
Hi Tom, Very helpful indeed. But I could you answer my follow-up question too please: How can one use PL/SQL to build Appointments in Exchange? Ive searched practically the main internet but found nothing. Would really appreciate in case 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 the com cartridge.
Reviewer: Munz from Reston, USA
Tom: Do I realize that if I want to send out an email however with a subject line along with a message pulled out on the database I can undertake it with PL/SQL. I only need to work with jAVAMAIL API when I need t osend attachments. THank you,
You never need javamail, you may use utlsmtp 100%. It is just much much easier with javamail for you attachments, it can do the work with you. UTLSMTP is enough for sending text based email
Reviewer: Munz from Reston, USA
Tom: If you do not want to make use of named parameters rather than cc or bcc anyone in email how must you pass parameters. I am getting a blunder when I do: begin , null, , ,, This is a subject matter, Hello Tom, this can be the mail you will need ; lineMessage deliver to the user successfully; end;Cant you pass null values for an array. Thanks,
why dont you want make use of named parameters? they can be better then positional, you're not calling this from SQL so that is just not an issue. Otherwise, arrange the parameters to fit your needs but wait, thatll break your other code unless it uses named parameters I would recommend you utilize 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 try this: begin sender email, from, to, , , subj, body ; end;also. You are not passing a clear array - you passed an array with a few blank strings - - unique. Just pass empty arrays like I have them defaulted to
TCPConnection class just isn't loaded in database I want to send out mail out of, nevertheless the classes are loaded in another db behind the firewall that I can access by way of a db link. I have tried making 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 merely calls send mail over the db link with the identical arguments it absolutely was called with. This doesnt work either. I get wrong number or type arguments. Can you show the way you would call UTLSMTP across a db link at a db that doesnt possess the java classes installed?
utlsmtp utilizes a record. you might be probably not defining your connection record making use of 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 and the mistake message cut and pasted from sqlplus, its very hard to tell
Reviewer: Sven Bleckwedel from Santos, Brazil