Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help with this simple proc?
Glen A Stromquist wrote:
> 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
>
"proc_name" is the name of the file containing the code.
You do NOT have a "PROCEDURE" called "PROC_NAME".
Received on Fri May 02 2003 - 18:24:35 CDT