OraFAQ Forum: Forms » Sending mail through forms and Send A Mail From Oracle10g Forms (merged)

Home » Developer & Programmer » Forms » Sending mail through forms and Send A Mail From Oracle10g Forms (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sending mail through forms and Send A Mail From Oracle10g Forms (merged) [message #321800]

Wed, 21 May 2008 06:30

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;

Report message to a moderator

Re: Send A Mail From Oracle10g Forms [message #321928 is a reply to message #321800]

Wed, 21 May 2008 19:28

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

Report message to a moderator

Sending mail through forms [message #321965 is a reply to message #321800]

Wed, 21 May 2008 23:39

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

Report message to a moderator

Re: Sending mail through forms [message #321971 is a reply to message #321965]

Wed, 21 May 2008 23:51

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

Report message to a moderator

Re: Sending mail through forms [message #322022 is a reply to message #321965]

Thu, 22 May 2008 03:36

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

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	how to solve 100500 non-oracle exception?
Next Topic:	remove duplicate value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 22:43:41 CDT 2024