About calling the oracle stored procedure with the output parameter CURSOR

About calling the oracle stored procedure with the output parameter CURSOR 1. create Procedure with Out parameter of CURSOR type www.2cto.com Java code create or replace package pa_query as type p_cursor is ref cursor; end pa_query;/create or replace procedure p_query (v_cursor out pa_query.p_cursor) is begin open v_cursor for select * from emp; end p_query; 2. call the procedure in PL/SQL Java code declare type search_results is ref cursor; results_out search_results; begin -- Call the procedure package pa_query (results_out); end; or the Java code declare results_out [B] sys_refcursor [/B]; begin -- Call the procedure package pa_query (results_out); end; 3. call the procedure in JDBC java. www.2cto.com Java code cstmt.registeroutparameter(2,oracle.jdbc.oracletypes.cursor?;cstmt.exe cute (); -- convert the referenced cursor type to the result set ResultSet rs = (ResultSet) cstmt. getObject (2 );