Order by Problem on 8i

Hi I am faced with a problem ...

If I run the following code on Oracle 8i the create procedure fails. I can't figure out why because the command alone works!!!

Note that this works on 9i (is this a confirmed bug with a patch or anything!!!?!?)

TIA CREATE TABLE TEST1(
        test1 number(1));

CREATE TABLE TEST2(
        test1 number(1));

insert into test1 (test1) select test1

	FROM 
   	    test2
  	WHERE 
   	    test1='ss'
	ORDER BY test1;

CREATE PROCEDURE TEST
IS
BEGIN
insert into test1 (test1) select test1

	FROM 
   	    test2
  	WHERE 
   	    test1='ss'
	ORDER BY test1;