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;
END;
/