Re: help with this simple proc?

"Glen A Stromquist" <glen_stromquist_at_no.spam.yahoo.com> wrote in message news:C3Csa.21238$yv1.1637867_at_news2.telusplanet.net...
> 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:
> =========================
> declare
>
> 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
>

The code above is an anonymous block. It is NOT a procedure! A procedure definition starts with create or replace procedure.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address