Oracle SQL Developer: how to view results from a ref cursor?

Double click the cursor fields in your result record. On the right side there is a "..." icon. Click this and you'll see the contents.

I know this was asked a while ago but I've just figured this out and it might help someone else. Not sure if this is exactly what you're looking for but this is how I call a stored proc and view the output in SQL Developer. In SQL Developer when viewing the proc, right click and choose 'Run' or select Ctrl+F11 to bring up the Run PL/SQL window.

This creates a template with the input and output params which you need to modify. My proc returns a sys_refcursor. The tricky part for me was declaring a row type that is exactly equivalent to the select stmt / sys_refcursor being returned by the proc: DECLARE P_CAE_SEC_ID_N NUMBER; P_FM_SEC_CODE_C VARCHAR2(200); P_PAGE_INDEX NUMBER; P_PAGE_SIZE NUMBER; v_Return sys_refcursor; type t_row is record (CAE_SEC_ID NUMBER,FM_SEC_CODE VARCHAR2(7),rownum number, v_total_count number); v_rec t_row; BEGIN P_CAE_SEC_ID_N := NULL; P_FM_SEC_CODE_C := NULL; P_PAGE_INDEX := 0; P_PAGE_SIZE := 25; CAE_FOF_SECURITY_PKG.

GET_LIST_FOF_SECURITY( P_CAE_SEC_ID_N => P_CAE_SEC_ID_N, P_FM_SEC_CODE_C => P_FM_SEC_CODE_C, P_PAGE_INDEX => P_PAGE_INDEX, P_PAGE_SIZE => P_PAGE_SIZE, P_FOF_SEC_REFCUR => v_Return ); -- Modify the code to output the variable -- DBMS_OUTPUT. PUT_LINE('P_FOF_SEC_REFCUR = '); loop fetch v_Return into v_rec; exit when v_Return%notfound; DBMS_OUTPUT. PUT_LINE('sec_id = ' || v_rec.

CAE_SEC_ID || 'sec code = ' ||v_rec. FM_SEC_CODE); end loop; END.

There are no way to display a refcursor in datagrid in sqldeveloper. We can define a refcursor,call SP,then print refcursor,then data will be printed in Script output window in a plane text mode,but not in Query Result window.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.