Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> help with this simple proc?
I am trying to write a simple proc to call from an access form to
populate a table with random entries. It is as follows:
num1 number;
begin
delete from table2;
commit;
insert into table2
select * from (select col1,col2 from
table1 where col3 is not null
order by dbms_random.value) where rownum <= %num1;
commit;
end;
It runs fine from sqlplus when I enter "@proc_name", but wont run if I enter " exec proc_name" nor will it compile. As you can see I haven't spent a lot of time writing PL/SQL - can anyone help here?
TIA Received on Fri May 02 2003 - 17:12:50 CDT