sql - 错误 PLS-00382 (283: 17)：PLS-00382：表达式类型错误

Question

将 package_status 添加到 get_all_del_sku_sum 过程时，我收到以下错误：[错误] PLS-00382 (283: 17): PLS-00382: 表达式类型错误。我究竟做错了什么？

procedure get_all_del_sku_sum(
            p_str               in   number,
            p_to_date           in   date,
            p_cursor            out sku_qty_sum_ref)  is

        v_cursor            sku_qty_sum_ref;
        v_from_date         date;
        v_request_key        varchar2(100);

        begin

            v_from_date := trunc(p_to_date - 30);
            v_request_key:= p_str || '_' || p_to_date || '_' || current_timestamp;

             if (getTempTableRecCnt(v_request_key) = 0) then
                build_sku_qty_temp(p_str,v_from_date,p_to_date,v_request_key);
           end if;

            open v_cursor for
                select dept_id,dept_name,prdc_code,prdc_desc,brand_id,brand_name,sku_style,str_no,sku_no,package_status,color_code,color_name,null,sum(sku_qty)
                    from shp_trk_temp_wrk
                    where request_key = v_request_key
                    group by dept_id,dept_name,prdc_code,prdc_desc,brand_id,brand_name,sku_style,str_no,sku_no,package_status,color_code,color_name
                    order by dept_id,sku_no;

            p_cursor := v_cursor;

        end  get_all_del_sku_sum;

标签： sqloracleplsql