CREATE OR REPLACE AND COMPILE
JAVA SOURCE NAMED "demo"
AS
 import  java.sql.SQLException;
 public   class  demo  extends  Object
{
 static   int  counter =  0 ;
 public   static   int  IncrementCounter()  throws  SQLException
{
    System.out.println( "Enter IncrementCounter, counter = "+counter);
     if  ( ++counter >=  3  )
    {
        System.out.println( "Error! counter="+counter);
        #sql {
        begin raise_application_error( - 20001 , 'Too many calls' ); end;
        };
    }
    System.out.println( "Exit IncrementCounter, counter = "+counter);
     return  counter;
}
}
/