Oracle Road (4)-stored procedure!

Create a stored procedure:

create or replace procedure sp_spo3(spName varchar2,newSal number) isbegin       update emp set sal = newSal where ename = spName;end;/

Write Java code:

/*** @ Title oracleprocudure. java * @ Description * @ create 2013-7-29 02:52:15 by Yangzhi * @ package COM. oracle. procudure * @ version $ ID $ */package COM. oracle. procudure; import Java. SQL. callablestatement; import Java. SQL. connection; import Java. SQL. drivermanager; import Java. SQL. sqlexception;/*** Oracle stored procedure test * @ description ** @ classname oracleprocudure * @ author Yangzhi 
Run the update database.