Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to access ref cursor from java

user10447332Jan 18 2009 — edited Jan 18 2009
i written a procedure as shown below
CREATE OR REPLACE PROCEDURE sp_countrymasterlist_get
AS
TYPE CurTyp IS REF CURSOR;
country_cur CurTyp;
BEGIN
OPEN country_cur FOR
SELECT country_name FROM country_mstr;
END;


how to access this from java application
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2009
Added on Jan 18 2009
1 comment
312 views