I am trying to create a procedure :
create or replace procedure sss_p_print_wls_info (var_days_back_in_time number default 45, var_min_thread_count number default 25)
IS
TYPE REF_CUR IS REF CURSOR returns wls_tab_1%rowtype;
var_cur_wls_stuckthread REF_CUR;
var_cur_wls_stuckthread_rec var_cur_wls_stuckthread%ROWTYPE;
While compiling, I get the below error ..
Error at line 3: PLS-00103: Encountered the symbol "RETURNS" when expecting one of the following:
; return
The symbol ";" was substituted for "RETURNS" to continue.
1. create or replace procedure sss_p_print_wls_info (var_days_back_in_time number default 45, var_min_thread_count number default 25)
2. IS
3. TYPE REF_CUR IS REF CURSOR returns wls_tab_1%rowtype;
4. var_cur_wls_stuckthread REF_CUR;
5. var_cur_wls_stuckthread_rec var_cur_wls_stuckthread%ROWTYPE;
Pleae advise ..