Edit D:\app\Administrator\product\11.2.0\dbhome_1\javavm\demo\examples\jsproc\basic\basic_kprb\run.sql
Rem run.sql connect &1/&2 set echo on set serveroutput on rem This SQL script runs the Employee kprb test rem show the original data in the employee table select * from employee; rem This PL/SQL block calls the annualReview procedure, which in turns rem call the Java method updatePositionSalary in Employee class to rem update the position and salary of the employee with employee number rem 101. declare eno number; ename varchar2(20); sal number; pos varchar2(20); begin eno := 101; ename := getEmpName (eno); sal := 0; pos := 'Sr. Engineer'; annualReview (eno, pos, sal, 10000); dbms_output.put_line('eno=' || eno || ' ename=' || ename || ' position=' || pos || ' salary=' || sal); end; / rem show the updated data in the employee table select * from employee; exit
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de