Oracle stored procedures with return values

Oracle stored procedures with returned values SQL code create or replace procedure sp_pro_order (spName in nvarchar2, spAddress in nvarchar2, spId out number) is begin INSERT INTO ORDER_MC (ID, NAME, ADDRESS, CREATETIME) values (order_id.nextval, spName, spAddress, SYSDATE); select order_id.currval into spId from dual; end sp_pro_order; www.2cto.com java code calls Java code Connection conn = super. getConn (); try {String SQL = "{call sp_pro_order (?, ?,?)} "; CallableStatement cs = conn. prepareCall (SQL); cs. setString (1, om. getName (); cs. setString (2, om. getAddress (); cs. registerOutParameter (3, oracle. jdbc. oracleTypes. NUMBER); // return value type cs.exe cute (); int id = cs. getInt (3); // 3 indicates the position of the returned value.