OraFAQ Forum: SQL & PL/SQL » Sending an email Contain pie chart by PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Sending an email Contain pie chart by PL/SQL

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

Sending an email Contain pie chart by PL/SQL [message #620642]

Mon, 04 August 2014 13:51

raul33
Messages: 26
Registered: October 2008
Location: jordan

Junior Member

Dears,

Please your support to help me how I can send an email contain pie chart by PL/SQL Code.

Notes: The Pie chart contains data from select statement.

Thanks and Regard,

Report message to a moderator

Re: Sending an email Contain pie chart by PL/SQL [message #620643 is a reply to message #620642]

Mon, 04 August 2014 14:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

raul33 wrote on Mon, 04 August 2014 11:51

Dears,

Please your support to help me how I can send an email contain pie chart by PL/SQL Code.

Notes: The Pie chart contains data from select statement.

Thanks and Regard,

Oracle contains no native capability to produce "graphics" (i.e. pie chart).
You'll need to find & use third party software to produce the pie chart in some known graphic format (i.e. jpg, etc)
You can then attach the graphics file & email the results.
Realize that since PL/SQL is required to send the email, the graphics file needs to reside on the DB Server.

Report message to a moderator

Re: Sending an email Contain pie chart by PL/SQL [message #620663 is a reply to message #620642]

Tue, 05 August 2014 00:07

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You'll find Java classes on the web that generates charts and you can embed these classes in database.

Report message to a moderator

Re: Sending an email Contain pie chart by PL/SQL [message #620709 is a reply to message #620663]

Tue, 05 August 2014 09:45

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

There was a similar topic posted in OTN forum yesterday, not sure if its you, see if it helps https://community.oracle.com/message/12569321

Report message to a moderator

Previous Topic:	SQL
Next Topic:	Schedule Job in Oracle - With conditions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 12:49:18 CDT 2024