OraFAQ Forum: Client Tools » thirdparty for alert....any kind of alert

Home » SQL & PL/SQL » Client Tools » thirdparty for alert....any kind of alert (oracle 9i, windows 7)

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

thirdparty for alert....any kind of alert [message #523501]

Mon, 19 September 2011 03:01

mas2011
Messages: 11
Registered: September 2011
Location: Malaysia

Junior Member

is the any third party for alert system for oracle 9i??

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523510 is a reply to message #523501]

Mon, 19 September 2011 03:15

Michel Cadot
Messages: 67640
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

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523517 is a reply to message #523510]

Mon, 19 September 2011 03:24

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?

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523520 is a reply to message #523517]

Mon, 19 September 2011 03:29

Littlefoot
Messages: 21647
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.

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523682 is a reply to message #523520]

Mon, 19 September 2011 18:45

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??

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523683 is a reply to message #523682]

Mon, 19 September 2011 18:52

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523684 is a reply to message #523682]

Mon, 19 September 2011 19:00

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.

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523685 is a reply to message #523684]

Mon, 19 September 2011 19:07

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523740 is a reply to message #523685]

Tue, 20 September 2011 03:59

cookiemonster
Messages: 13895
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.

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523871 is a reply to message #523740]

Tue, 20 September 2011 18:46

mas2011
Messages: 11
Registered: September 2011
Location: Malaysia

Junior Member

where should i put this procedure??

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523872 is a reply to message #523871]

Tue, 20 September 2011 19:20

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

Senior Member

>where should i put this procedure??

in the database

CREATE OR REPLACE PROCEDURE

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523873 is a reply to message #523872]

Tue, 20 September 2011 19:33

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??

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523874 is a reply to message #523873]

Tue, 20 September 2011 19:34

mas2011
Messages: 11
Registered: September 2011
Location: Malaysia

Junior Member

do you have any example of this procedure??

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523875 is a reply to message #523874]

Tue, 20 September 2011 19:44

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

Senior Member

>do you have any example of this procedure??
how do we know what are your requirements?

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523876 is a reply to message #523875]

Tue, 20 September 2011 20:01

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.

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523877 is a reply to message #523876]

Tue, 20 September 2011 20:03

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

Senior Member

http://asktom.oracle.com
above has many fine coding examples

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #523966 is a reply to message #523877]

Wed, 21 September 2011 05:34

Littlefoot
Messages: 21647
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Yet another third party alert system: /forum/fa/1587/0/

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #524021 is a reply to message #523966]

Wed, 21 September 2011 07:06

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Or you could mount this under the users chair. THAT will alert him.

Report message to a moderator

Re: thirdparty for alert....any kind of alert [message #524025 is a reply to message #524021]

Wed, 21 September 2011 07:33

cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester

Senior Member

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 16 16:10:58 CST 2021