how to handle SYS_REFCURSOR?
I created table in oracle 11g like below,
CREATE TABEL family(
EMP_ID VARCHAR(255),
EMP_PASSWD VARCHAR(255),
EMP_NAME VARCHAR(255),
PRIMARY KEY(EMP_ID) )
And I inserted a few data. commit command was successful.
I made a stored procedure to call data. The sp is
CREATE OR REPLACE PROCEDURE SP_SELECT_ORA (
id_input IN VARCHAR2 ,
my_cursor OUT SYS_REFCURSOR
)
IS
BEGIN
OPEN my_cursor FOR
SELECT EMP_ID, EMP_PASSWD, EMP_NAME
FROM family
WHERE EMP_ID = ID_INPUT;
END;
But the stored procedure threw error. Stored procedure was created successfully but error was thrown when running.
I need your advice. Thanks in advance!
Best regards.