Home » SQL & PL/SQL » Client Tools » thirdparty for alert....any kind of alert (oracle 9i, windows 7)
thirdparty for alert....any kind of alert [message #523501] Mon, 19 September 2011 03:01 Go to next message
mas2011
Messages: 11
Registered: September 2011
Location: Malaysia
Junior Member

is the any third party for alert system for oracle 9i??
Re: thirdparty for alert....any kind of alert [message #523510 is a reply to message #523501] Mon, 19 September 2011 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 60018
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you explain with more details.

Quote:
oracle 9i, windows 7

This is a not supported configuration.

Regards
Michel
Re: thirdparty for alert....any kind of alert [message #523517 is a reply to message #523510] Mon, 19 September 2011 03:24 Go to previous messageGo to next message
mas2011
Messages: 11
Registered: September 2011
Location: Malaysia
Junior Member

ops...sorry...

its oracle 6i forms and reports...

i need to make an alert system that alert my user of the date due of a job.

do you have any suggestions?
Re: thirdparty for alert....any kind of alert [message #523520 is a reply to message #523517] Mon, 19 September 2011 03:29 Go to previous messageGo to next message
Littlefoot
Messages: 19893
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use DBMS_JOB which will run a procedure (that will decide whether the job is due or not) and alert a user (UTL_SMTP to send an e-mail). I don't think that Forms (or Reports) should be used here. Both packages are described here.
Re: thirdparty for alert....any kind of alert [message #523682 is a reply to message #523520] Mon, 19 September 2011 18:45 Go to previous messageGo to next message
mas2011
Messages: 11
Registered: September 2011
Location: Malaysia
Junior Member

i'm sorry....i can't find the package described...can you give me the direct link??
Re: thirdparty for alert....any kind of alert [message #523683 is a reply to message #523682] Mon, 19 September 2011 18:52 Go to previous messageGo to next message
BlackSwan
Messages: 23162
Registered: January 2009
Senior Member
http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96612/toc.htm
URLs below are directly from previously posted URL above
http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_job.htm#999107
http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96612/u_smtp.htm#1000695
Re: thirdparty for alert....any kind of alert [message #523684 is a reply to message #523682] Mon, 19 September 2011 19:00 Go to previous messageGo to next message
mas2011
Messages: 11
Registered: September 2011
Location: Malaysia
Junior Member

can DBMS_JOB be used in alerting user to renew their licences?

how can i join both? the DBMS_JOB and UTL_SMTP?
where should i put the command?? using what trigger??

really hope someone could help me with example.
Re: thirdparty for alert....any kind of alert [message #523685 is a reply to message #523684] Mon, 19 September 2011 19:07 Go to previous messageGo to next message
BlackSwan
Messages: 23162
Registered: January 2009
Senior Member
>really hope someone could help me with example.
many fine coding examples can be found at http://asktom.oracle.com

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Nobody here can provide you any example when we don't know table names, column names, or coding requirements
Re: thirdparty for alert....any kind of alert [message #523740 is a reply to message #523685] Tue, 20 September 2011 03:59 Go to previous messageGo to next message
cookiemonster
Messages: 11287
Registered: September 2008
Location: Rainy Manchester
Senior Member
DBMS_JOB runs bits of code at specified times. So you'd create a procedure that creates an email with UTL_SMTP. Then create a job that calls that procedure at the appropriate time to send the email. Triggers aren't involved here.
Re: thirdparty for alert....any kind of alert [message #523871 is a reply to message #523740] Tue, 20 September 2011 18:46 Go to previous messageGo to next message
mas2011
Messages: 11
Registered: September 2011
Location: Malaysia
Junior Member

where should i put this procedure??
Re: thirdparty for alert....any kind of alert [message #523872 is a reply to message #523871] Tue, 20 September 2011 19:20 Go to previous messageGo to next message
BlackSwan
Messages: 23162
Registered: January 2009
Senior Member
>where should i put this procedure??

in the database

CREATE OR REPLACE PROCEDURE
Re: thirdparty for alert....any kind of alert [message #523873 is a reply to message #523872] Tue, 20 September 2011 19:33 Go to previous messageGo to next message
mas2011
Messages: 11
Registered: September 2011
Location: Malaysia
Junior Member

if i'm using forms6i, where should i put it??

or should i put it in sql*plus??
Re: thirdparty for alert....any kind of alert [message #523874 is a reply to message #523873] Tue, 20 September 2011 19:34 Go to previous messageGo to next message
mas2011
Messages: 11
Registered: September 2011
Location: Malaysia
Junior Member

do you have any example of this procedure??
Re: thirdparty for alert....any kind of alert [message #523875 is a reply to message #523874] Tue, 20 September 2011 19:44 Go to previous messageGo to next message
BlackSwan
Messages: 23162
Registered: January 2009
Senior Member
>do you have any example of this procedure??
how do we know what are your requirements?
Re: thirdparty for alert....any kind of alert [message #523876 is a reply to message #523875] Tue, 20 September 2011 20:01 Go to previous messageGo to next message
mas2011
Messages: 11
Registered: September 2011
Location: Malaysia
Junior Member

any example that has been used before. just to get the picture/idea of the procedure.
Re: thirdparty for alert....any kind of alert [message #523877 is a reply to message #523876] Tue, 20 September 2011 20:03 Go to previous messageGo to next message
BlackSwan
Messages: 23162
Registered: January 2009
Senior Member
http://asktom.oracle.com
above has many fine coding examples
Re: thirdparty for alert....any kind of alert [message #523966 is a reply to message #523877] Wed, 21 September 2011 05:34 Go to previous messageGo to next message
Littlefoot
Messages: 19893
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yet another third party alert system: ./fa/1587/0/
Re: thirdparty for alert....any kind of alert [message #524021 is a reply to message #523966] Wed, 21 September 2011 07:06 Go to previous messageGo to next message
ThomasG
Messages: 3123
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Or you could mount this under the users chair. THAT will alert him.
Re: thirdparty for alert....any kind of alert [message #524025 is a reply to message #524021] Wed, 21 September 2011 07:33 Go to previous message
cookiemonster
Messages: 11287
Registered: September 2008
Location: Rainy Manchester
Senior Member
Smile
Previous Topic: error while loading shared libraries: libskgxp10.so: when Sqlplus login with Unix root
Next Topic: Need help regarding notepad++ integration with plsql
Goto Forum:
  


Current Time: Mon Dec 22 15:28:38 CST 2014

Total time taken to generate the page: 0.11767 seconds