Re: help with this simple proc?

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 3 May 2003 08:20:31 GMT
Message-ID: <b8vu4e$dd3p2$1@ID-82536.news.dfncis.de>

> 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?

%num1 is a misnomer and should read num1.

Probably, you aren't granted insert or select rights directly on table1 and/or table2, only via a role.

Always post error messages.

hth
Rene Nyffenegger

-- 
  Projektleitung und Entwicklung in Oracle/C++/C# Projekten
  http://www.adp-gmbh.ch/cv.html

Received on Sat May 03 2003 - 03:20:31 CDT