Rem create.sql
connect &1/&2

alter java class "NComp" compile;
create or replace package NCOMP as
  function STATUS return VARCHAR2;
  pragma restrict_references(STATUS, wnds);
end;
/
create or replace package body NCOMP as
  function STATUS return VARCHAR2 as
  language java name 'NComp.status() return java.lang.String';
end;
/

show errors
exit