写完之后，提示在这个SELECT语句中需要一个INTO子句：

create or replace procedure test is

begin

  select 

      -- lot.lot_status            "JSSIStatus",

       prod.cust_code            "Cust",

       prod.prod_name            "DeviceName",

       lot.cust_lot              "CustomerLot",

       lot.lot_code              "LotId",

       prod.package_class        "Process",

       prod.package_type         "Package",

       npi.design_structure_code "ProcessCode",

       prod.wafer_size           "Size",

       lps.trackout_qty          "WaferQty",

       lps.trackout_qty_die      "DieQty",

       dim.step_code             as "Stage",

       flow.stage_code           as "Route",

       lps.step_code             as "StepCode",

       lps.step_name             as "StepName",

       mo.mo_date                "InputDate",

       mo.delivery_date          "DueDate",

       --lot.dummy_flag "Dummy",

       mo.dummy_flag "Dummy",

       mo.order_type "OrderType",

       ROUND(TO_NUMBER(lps.trackin_date - lps.arrive_date) * 24, 2) "WaitTime",

       '' "HoldTime",

       '' "HandleTime",

       ROUND(TO_NUMBER(lps.trackout_date - lps.trackin_date) * 24, 2) "OpCT",

       ROUND(TO_NUMBER(step.sam_qty), 2) "StandardCT",

       '' "DispatchTime",

       lps.trackin_date "StartTime",

       lps.trackout_date "EndTime",

       mo.factory_code "FAB"

  from lot_process_step lps

  left join lot_info lot

    on lps.lot_id = lot.row_id

  left join mo_order mo

    on lot.mo_id = mo.row_id

   and mo.del_flag = 0

  left join md_product prod

    on lot.prod_id = prod.row_id

   and prod.del_flag = 0

  left join npi_define npi

    on npi.prod_id = prod.row_id

   and npi.del_flag = 0

  left join md_process_ver_flow flow

    on lps.process_ver_flow_id = flow.row_id

   and flow.del_flag = 0

  left join md_step step

    on lps.step_id = step.row_id

   and step.del_flag = 0

  left join md_step_dim dim

    on step.par_row_id = dim.row_id

   and dim.del_flag = 0

   and dim.active_flag = 'Y'

   and dim.dim_type = 'Stage'

 where lps.del_flag = 0

   and lot.del_flag = 0

   and prod.process_biz_type in ('W', 'C', 'B')

   and lps.step_status = 'TrackOut'

  -- and lot.lot_code = 'CLH2128015N1'

order by lot.lot_code, lps.line_num;

end test;

请问这是什么问题