REF CURSOR

Ok, this is probably a dumb question, but, I have this code:

CREATE OR REPLACE PROCEDURE cj_trials_log (

  p_newsletter_id      NUMBER,
  p_conversion_date    VARCHAR2,
  p_data               OUT REF_CRS) IS

TYPE ref_crs IS REF CURSOR;
.
.
.

I think it is upset because I use the REF_CRS before it is defined. But how can you do this in a procedure? Since the parameter declaration comes first? Do you create a public type? I'm not sure how to do that...... Received on Fri Mar 27 2009 - 09:58:17 CDT