Previous	Next		Contents	Index	Navigation	Glossary	Library

A custom application is an application that was not installed using AutoInstall or, any application that resides outside the database where Oracle Alert resides. For example, an Oracle Application that resides in a different database from Oracle Alert is considered a custom application. Using database links, Oracle Alert can monitor any custom application as if it resides in the same database as Oracle Alert.

   To define a periodic alert for your custom application:

1. Use SQL*Net to create a database link from the Oracle Alert database to the custom Oracle database:

	CREATE DATABASE LINK linkname
	CONNECT TO username IDENTIFIED BY password
	USING 'connect string'; 

Note: Replace

'connect string'

with a SQL*Net V1 connect string or a SQL*Net V2 alias. Refer to the SQL*Net User's Guide for your protocol for more information.

Here is an example if you are using SQL*Net V1:

	CREATE DATABASE LINK CUSTOM_APPL
	CONNECT TO SCOTT IDENTIFIED BY TIGER
	USING 't:hqfin:CUSTOM_DB'; 

Note: If your custom application resides in the same database as Oracle Alert, you need not define a database link.

2. Optionally, you can create synonyms for each table in your custom application so that you can reference the table using the synonym instead of the table name and database link. That way, the users defining alerts and actions do not need to know the location of the custom application, just the table names. See: SQL Language Reference Manual.

3. Register your custom application with Oracle Alert so that it is available in the list of values for the Application field of the Alerts form. See: Applications Window.

4. Register your custom application's Oracle ID with Oracle Alert. See: Registering Application Installations.

5. Once you complete these steps you can define periodic alerts for your custom application. See: Creating a Periodic Alert.

   To define an event alert for your custom application:

1. If you want to create event alerts for your custom Oracle applications, you need to complete the following steps.

Attention: If you want to create event alerts for Oracle Applications that reside on another database, you must install Oracle Alert on that database.

2. Register your custom application with Oracle Alert so that it appears in the list of applications available in the Alerts form. See: Applications Window.

3. Register your custom application's Oracle ID with Oracle Alert. See: Registering Application Installations.

4. Use the Table Registration API to register the table(s) that you want Oracle Alert to monitor for inserts and updates. See: Table Registration API, Oracle Applications Coding Standards.

5. Once you complete these steps you can define event alerts for your custom application. Oracle Alert creates the necessary insert or update database trigger in your custom application table for your event alert. See Creating an Event Alert.

See Also