Configuring a User Defined Function in RTI

To configure a User Defined Function in RTI

1. GETLASTCHARS (FUNCTION NAME) (PARAMETER NAME1 DATA TYPE1, PARAMETER NAME2    
         DATA TYPE 2)
   return 'return data type'
   Begin
   Function Body
   End

2. For Example, to create a Function GETLASTCHARS in the Atomic Schema, follow the steps below.

   create or replace function GETLASTCHARS(inputString varchar2, noOfChars 
   number) 
   return varchar2 
   is 
    v_chars varchar2(32767):=''; 
   
   begin 
     select SUBSTR(inputString,0-noOfChars,noOfChars) into v_chars from dual; 
      
     return v_chars; 
   end GETLASTCHARS; 

Note:

At any point of time, the user created functions for use in Expression should have only two parameters. In the Example Function, the inputString and noOfChars are the two parameters.