Explain Plan and column_name like '%FROM%'

[Gustavo]

I have this SQL in a procedure:

select distinct ooh.order_number
           , ooh.orig_sys_document_ref
           , ooh.sold_to_org_id
           , ooh.ship_from_org_id
        into v_order_number
           , v_orig_sys_document_ref
           , v_customer_id
           , v_ship_from_org_id
        from oe_order_headers_all    ooh
       where attribute20 = p_rma_process_id;

If I select it and try to Explain Plan, I get "ORA-00936: missing expression" and this SQL:

select distinct ooh.order_number
           , ooh.orig_sys_document_ref
           , ooh.sold_to_org_id
           , ooh.ship_ */from_org_id
     /*    into v_order_number
           , v_orig_sys_document_ref
           , v_customer_id
           , v_ship_from_org_id
        from oe_order_headers_all    ooh
       where attribute20 = :p_rma_process_id

Regards,
Gustavo

 

[Marco Kalter]

We'll fix it.