I am confused. You have created test tables with a numeric column, but the insert treats it as a character.

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