REF Cursor Question

Hey All,

I got this piece of code I am trying to write and the cursor is not working properly. Please take a look at this. It basically complains about v_osid not being valid......

CREATE OR REPLACE PROCEDURE valid_spf(p_spf VARCHAR2,p_meps_id VARCHAR2, p_processing_spf OUT VARCHAR2) IS rec_array SYS_REFCURSOR;
cursor ora_sid IS select oracle_sid from meps_system_info where meps_id = p_meps_id;
v_osid meps_system_info.oracle_sid%TYPE; sql_statement varchar2(400);

begin
open ora_sid;
fetch ora_sid INTO v_osid;
close ora_sid;
open rec_array FOR select processing_spf from processing_spf_at_v_osid where spf = p_spf;
pass_ref_cur(rec_array,p_processing_spf); close rec_array;
end;
/ Received on Fri Jan 13 2006 - 13:45:52 CST