connect jserver_demo/jserver_demo

CREATE OR REPLACE PACKAGE JServer_mgr AS

  PROCEDURE create_tables;

  PROCEDURE insert_values (  intr_no     NUMBER
                           , name        VARCHAR2
                           , company     VARCHAR2);

  PROCEDURE query_forward;

  PROCEDURE query_reverse;

  PROCEDURE delete_values;

  PROCEDURE drop_object (  obj_type VARCHAR2
                         , obj_name VARCHAR2);

  PROCEDURE show_user;

END JServer_mgr;
/
show errors


CREATE OR REPLACE PACKAGE BODY JServer_mgr AS

  /*
   ** -------------------
   ** PROC: create_tables
   ** -------------------
  */
  PROCEDURE create_tables
   AS LANGUAGE JAVA
   NAME 'JServerApplication.createTables()';

  /*
   ** -------------------
   ** PROC: insert_values
   ** -------------------
  */
  PROCEDURE insert_values (  intr_no     NUMBER
                           , name        VARCHAR2
                           , company     VARCHAR2)
    AS LANGUAGE JAVA
    NAME 'JServerApplication.insertValues(int, java.lang.String, java.lang.String)';

  /*
   ** -------------------
   ** PROC: query_forward
   ** -------------------
  */
  PROCEDURE query_forward
   AS LANGUAGE JAVA
   NAME 'JServerApplication.queryForward()';

  /*
   ** -------------------
   ** PROC: query_reverse
   ** -------------------
  */
  PROCEDURE query_reverse
   AS LANGUAGE JAVA
   NAME 'JServerApplication.queryReverse()';

  /*
   ** -------------------
   ** PROC: delete_values
   ** -------------------
  */
  PROCEDURE delete_values
   AS LANGUAGE JAVA
   NAME 'JServerApplication.deleteValues()';

  /*
   ** -------------------
   ** PROC: drop_object
   ** -------------------
  */
  PROCEDURE drop_object (  obj_type VARCHAR2
                         , obj_name VARCHAR2)
    AS LANGUAGE JAVA
    NAME 'JServerApplication.dropObject(java.lang.String, java.lang.String)';

  /*
   ** -------------------
   ** PROC: show_user
   ** -------------------
  */
  PROCEDURE show_user
   AS LANGUAGE JAVA
   NAME 'JServerApplication.showUser()';

END JServer_mgr;
/
show errors