第一步:建立一个游标
CREATE OR REPLACE PACKAGE TYPES AS
TYPE BJ _CURSOR IS REF CURSOR;
END;
第二步:创建存储过程
CREATE OR REPLACE PROCEDURE BJ_TEST_PROC
(
V_TEMP OUT TYPES.BJ_CURSOR,
PID IN VARCHAR
)
AS
BEGIN
OPEN V_TEMP FOR SELECT NAME FROM TEST WHERE ID = PID;
END BJ_TEST_PROC;
//存储过程要用到的表
create table TEST
(
ID VARCHAR2(10),
NAME VARCHAR2(10)
)
JDBC中的调用: