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