Home » Developer & Programmer » Forms » Sending mail through forms and Send A Mail From Oracle10g Forms (merged)
Sending mail through forms and Send A Mail From Oracle10g Forms (merged) [message #321800] Wed, 21 May 2008 06:30 Go to next message
nagendra1217
Messages: 4
Registered: May 2007
Junior Member
Below code working fine when i am using Forms6i.
But i want to send a mail by Forms10g..

If any body knows about that plese reply to me..
nagendra1217@gmail.com

Thanks&Regards,
Nagendra.


declare
objOutlook OLE2.OBJ_TYPE;
objMail OLE2.OBJ_TYPE;
objArg OLE2.LIST_TYPE;
objAttach OLE2.OBJ_TYPE;

BEGIN

objOutlook := OLE2.CREATE_OBJ('Outlook.Application');

-- Previous example usually used 'mapi.session' but this doesn't work correctly
--anymore.
objarg := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(objarg,0);

objMail := OLE2.INVOKE_OBJ(objOutlook,'CreateItem', objarg);
OLE2.DESTROY_ARGLIST(objarg);

objAttach := OLE2.GET_OBJ_PROPERTY(objmail, 'Attachments');

objarg := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(objarg,'c:\test.txt'); -- filename

OLE2.SET_PROPERTY(objmail,'To','shashidhar.patel@intertecsys.com');

OLE2.SET_PROPERTY(objmail,'Subject','Email sent from Oracle Forms 9i');
OLE2.SET_PROPERTY(objmail,'Body','This is an email that was sent using CLIENT_OLE2 from Oracle forms 9i');
OLE2.INVOKE(objattach, 'Add', objarg);
OLE2.INVOKE(objmail,'Send');

OLE2.RELEASE_OBJ(objmail);
OLE2.RELEASE_OBJ(objOutlook);
OLE2.DESTROY_ARGLIST(objarg);

END;





Re: Send A Mail From Oracle10g Forms [message #321928 is a reply to message #321800] Wed, 21 May 2008 19:28 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I see you still haven't read the sticky. Please use 'code' tags to aid formatting of your post. Also, this is a public forum not a private question answering service so posting your email address is, at best, useless and, at worst, going to lead to spamming of your mail box.

I suggest your search this forum for 'mail', 'email' and 'outlook' to see if others have had a problem similar to yours and whether it has been answreed.

David
Sending mail through forms [message #321965 is a reply to message #321800] Wed, 21 May 2008 23:39 Go to previous messageGo to next message
shilpaselite
Messages: 2
Registered: January 2006
Location: Bangalore
Junior Member
hi,
I want to send mail through forms10g.
Below mentioned code is working in forms6i but it is not working
in oracle10g.
How we can use OLE objects in oracle10g.

PROCEDURE sendmail IS
objOutlook OLE2.OBJ_TYPE;
objMail OLE2.OBJ_TYPE;
objArg OLE2.LIST_TYPE;
BEGIN
objOutlook := OLE2.CREATE_OBJ('Outlook.Application');
objarg := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(objarg,0);
objMail := OLE2.INVOKE_OBJ(objOutlook,'CreateItem',objarg);
OLE2.DESTROY_ARGLIST(objarg);
OLE2.SET_PROPERTY(objmail,'To','shilpa.raju@intertecsys.com');
OLE2.SET_PROPERTY(objmail,'Subject','Notification');
OLE2.SET_PROPERTY(objmail,'Body','Hi Shilpa How R u..');
OLE2.INVOKE(objmail,'Send');
OLE2.INVOKE(objmail,'Display');
OLE2.RELEASE_OBJ(objmail);
OLE2.RELEASE_OBJ(objOutlook);
END;

Shilpa
Re: Sending mail through forms [message #321971 is a reply to message #321965] Wed, 21 May 2008 23:51 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
How about you two people work together on this problem? You are communicating through the same IP address so I expect you are fairly close to each other location-wise.

David
Re: Sending mail through forms [message #322022 is a reply to message #321965] Thu, 22 May 2008 03:36 Go to previous messageGo to next message
dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai
Member
Hi Shilpa,

Code mentioned above uses OLE2 which is no longer supported in three tier architecture i.e. 10g forms.

Try to read upon Webutil provided in 10g.

Search on google you will find sample code along with complete code.

Use folloing link for reference http://forums.oracle.com/forums/thread.jspa?threadID=638074&tstart=0

Best Regards,

Dhanuka. Rajesh
Re: Sending mail through forms and Send A Mail From Oracle10g Forms (merged) [message #555617 is a reply to message #321800] Fri, 25 May 2012 08:52 Go to previous message
rajeevsql
Messages: 1
Registered: January 2010
Location: new delhi
Junior Member

HI ANY ONE HELP ME PLEASE I AM NEW BEGINNER OF ORACLE FORMS
SEARCHING FOR SENDING MAIL USING ORACLE FORMS
ANY ONE CAN SEND FMB OF THAT REQUIREMENT WHICH SEND EMAIL WITH
ATTACHMENT USING ORACLE FORM 10G.
ON GIVEN E.ID= krmanishapatna@gmail.com
Previous Topic: how to solve 100500 non-oracle exception?
Next Topic: remove duplicate value
Goto Forum:
  


Current Time: Mon Nov 04 11:36:22 CST 2024