Al,
did you issue a set serveroutput on before you tried executing the
procedure to see if your proc worked ok?
your procedure looks ok, the only other thing I would check is to run the
select statement outside of the proc to be sure that records are selected
ok.
one other thing - depending on
George ...
After insert you need a commit somewhere ... preferable after the
dbms_sql.execute only then number of rows actually written to the database
will increase.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni