Edit D:\app\Administrator\product\11.2.0\dbhome_1\javavm\demo\examples\jsproc\basic\objbyref\create.sql
Rem create.sql connect &1/&2 create or replace package empbyref as function getemp (empno in number) return number; function empsal (empid in number) return number; procedure raiseemp (empid in number, percent in number); procedure updateemp (empid in number); end; / show errors create or replace package body empbyref as function getemp (empno in number) return number as language java name 'EmployeeByRef.getEmployee (java.lang.Integer) return java.lang.Integer'; function empsal (empid in number) return number as language java name 'EmployeeByRef.employeeSalary (java.lang.Integer) return java.lang.Integer'; procedure raiseemp (empid in number, percent in number) as language java name 'EmployeeByRef.raiseEmployee (java.lang.Integer, float)'; procedure updateemp (empid in number) as language java name 'EmployeeByRef.updateEmployee (java.lang.Integer)'; end; / show errors exit
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de