-- Run from SQL*Plus
-- This creates a function around the Java method 'translate' from
-- the class AvQuery.  It can be called as a PL/SQL function called 
-- AvTranslate.  See cr_java.sql for the Java source
 
create or replace function JAvTranslate (avQueryString varchar2) 
    return varchar2 
  as language java name 'AvQuery.translate(java.lang.String) 
    return java.lang.String';
/