Alert 
      Wizard
    
 
  


Information
 
  
The Alert Wizard is provided for 
    your reference purposes, and carries no warranty. Oracle does not warrant 
    that the software will satisfy your requirements, or that the software is 
    without defect or error. 

Summary

 
  
Alert Generation Wizard will give 
    you a wizard to create and manage triggers to send messages to Oracle Mobile 
    Server. It will get the necessary information to create a trigger and generate 
    a OracleMessageXML to send messages through Oracle Mobile.

Requirements

  
Oracle 8i or above;
  
JDK-1.2.2_006 or above;


Repository
  
  
Alert Wizard to work needs its own repository. So before start to use Alert 
    Wizard, you need to create the repository.
   
  

    
Download file alertwizard.zip;
    
Extract zip file in a directory 
      (eg.: D:\AlertWizard);
    
Connect to a database with a 

      DBA user;
    
Run the script create_repository.sql(eg.:D:\AlertWizard\oracle\mobile\tools\alert\sql\create_repository.sql);
    
The script will ask for a connection 
      string, please enter a connect_string when script ask for (eg.:ommod);
    
After open a Command Prompt 
      and run create_repository.bat passing the connect string(eg:.D:\AlertWizard\loadrep.bat 
      ommod01.us.oracle.com:1521:ommod01); 
  
  
To create a AlertWizard demo 
    user and demo tables run the script tabdemo.sql as DBA and inform 
    a connect_string.


Demo

  
Download file alertwizard.zip 
    and follow the install instructions
  
To use Alert Generation Wizard 
    follow this instructions:
  
Username: OMALERT_DEMO
  
Password:DEMO 
    

  
  
After login you must click on 
    button New to create a new trigger. 
    


  
  
Now you need give the informations 
    to the wizard to create the trigger: 
    

      
In the first page you have 
        three field that you need to inform: 
        
 
          
Trigger Name: enter the 
            trigger name without spaces.:
          
fd
          
 Schema name: choose OMALERT_DEMO
          
:
          
Table name: choose account 
            table.

          

        
      
    
  
  
Now press button Next.
  
Check the Update check 
    box, select BALANCE and add balance to selected columns: 
    

  
  
After press button Next:
  
Choose BALANCE in list 
    box, choose lower than signal in list box and put 300 in value 
    field and press add: 
    


  
  
Press Next:
  
Choose the message that you would 
    like to send or create a new one: 
    

  
  
Press Next:
  
Now you need to tell how can the 
    trigger get the recipient name and address: 
    
 
      
Choose the schema OMALERT_DEMO: 
        
      

      
Choose PERSON table:
      

      
In Recipient name choose NAME:

      

      
In Recipient address choose 
        ADDRESS:
      

      
In Trigger Table choose PERSON_ID:
      

      
In Recipient table choose ID:
      

      
Now press button ADD:
      

    
  
  
 Press Next:
  
Choose a sender for a message: 
    

  
  
Now press button Finish:

  
Now go to this URL: AlertGenerationDemo.jsp
  
Add a user on PERSON table.
  
Add a account on ACCOUNT table.
  
Update BALANCE to 100 on ACCOUNT 
    table where PERSON_ID equals the ID of PERSON that you inserted on PERSON.