Re: insertion using stored procedure in oracle.

This sounds like a homework assignment and homework should be done by the person it is assinged to.

You can find examples of everything you need in the PL/SQL manaul. The manuals are available via
http://www.oracle.com/technology/documentation/index.html

>From your description I am not sure if you need to insert all the rows
from one table into another or only the row that match the input parameters but you need to look up the following:

create or replace procedure
cursor
Loop
IF

Some examples:
procedure compare_struct (
  p_db1 in varchar2
 ,p_db2 in varchar2
) is

--

cursor c_drv is
  select distinct
    owner
   ,table_name
  from
    compare_struct cs
  where cs.database = v_db1;
--
r_drv           c_drv%rowtype;

HTH -- Mark D Powell --