stored proc error

[Chandra]

if i run this query from SQL prompt it is working fine.
if i put it in stored procedure i am getting error. especialley if i put the ORDER BY clause i am getting.

_______________________________________
INSERT INTO north_east
SELECT min_num,configfile_id,correct_file,event_dt
FROM sub_status
WHERE rownum < v_trashhold
AND event_dt < (sysdate - 5)
AND event != 'D'
AND active_file != correct_file
AND market_num = v_market_num
AND region_id = 2
ORDER BY event_dt;
SQL> show errors;
Errors for PROCEDURE SP_MASS_PUSH:

LINE/COL ERROR
-------- -----------------------------------------------------------------
39/6 PLS-00103: Encountered the symbol "ORDER" when expecting one of
the following:
* & - + ; / at mod rem return returning
and or group having intersect minus start union where connect
||
The symbol "group was inserted before "ORDER" to continue.
__________________________

Thanks for your idea.

[Shestakov]

Can you post all text of procedure?
This is seems like parser bug.