OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » destype=mail

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

destype=mail [message #240637]

Fri, 25 May 2007 06:40

ritikaindu
Messages: 30
Registered: March 2007
Location: asas

Member

Hi All,

I am trying to send report output in mail which i have deployed on web by giving the URL:
http://localhost:8889/reports/rwservlet?report=reportname.rdf&destype=mail&userid=user/pwd@db&desformat=pdf&desname=u sername@domain.com

i have set the SMTP config in report server config file.
But i am getting the error code REP-50159.Please tell where is the problem.

Ritika

Report message to a moderator

Re: destype=mail [message #241574 is a reply to message #240637]

Wed, 30 May 2007 01:26

ritikaindu
Messages: 30
Registered: March 2007
Location: asas

Member

Please tell me what is the problem and where i am missing.

Ritika

Report message to a moderator

Re: destype=mail [message #241613 is a reply to message #240637]

Wed, 30 May 2007 03:18

apps_ara
Messages: 29
Registered: January 2007
Location: Pune

Junior Member

In your exchange SMTP server setup, do you allow relay at all, and more importantly, do you allow relay from your Oracle Application Server.

Report message to a moderator

Re: destype=mail [message #241616 is a reply to message #241613]

Wed, 30 May 2007 03:38

ritikaindu
Messages: 30
Registered: March 2007
Location: asas

Member

What is relay?I dont have any configuration idea about exchage SMTP server.
Actually i am using OC4J and has not yet installed AS.

Ritika

Report message to a moderator

Re: destype=mail [message #241880 is a reply to message #240637]

Wed, 30 May 2007 16:23

hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE

Senior Member

As per what i know with out that setup in the iAS, you will get that error..

There is a work around to it.

Run the report output to PDF and then use the UTL_SMTP package inbuilt into the SYS user of the Oracle Database (9i or 10g) to send the mail with the earlier PDF output as an attachment. If you use this function, you donot need to have any configuration set on the iAS and it allows any sort of mail to be sent via any SMTP server.

ENJOY Cool

Report message to a moderator

Previous Topic:	Can i do this
Next Topic:	datalink not functioning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 19 09:28:28 CDT 2025