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;
>/
>
Mark McCasland
Midlothian, TX USA