Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
DECLARE TYPE cur_type IS REF CURSOR; my_cursor cur_type; billrun VARCHAR2(50); my_list_of_values VARCHAR2(100); begin my_list_of_values := '''C15'',''C16'''; EDI_PLATINUM.GET_EDIPLATINUM_ACCOUNTS(my_list_of_values,my_cursor); fetch my_cursor into billrun; while my_cursor%found loop dbms_output.put_line(billrun); fetch my_cursor into billrun; end loop; close my_cursor; end; / Trying above throws a inconsistent datatype error. I am trying to test above to see why I get that missing expression error. THIS IS THE PROC: procedure GET_EDIPLATINUM_ACCOUNTS(in_list in varchar2, p_rc out sys_refcursor) IS v_select varchar2(8000); begin v_select := 'Select Cus_Parent, Parent_Name, BillRun, Folder, Map_Version From BillRun.RPT_CUSTOM_XLS Where (Delivery_Method like ''%EDI%'' Or Delivery_Method like ''%GSI%'') AND BillRun IN (' || in_list || ') Order By BillRun, Cus_Parent'; open p_rc for v_select; end GET_EDIPLATINUM_ACCOUNTS;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.