Re: compilation error--a procedure under system account

Oracle User wrote:
> Hi,
> I have the following procedure
> create or replace procedure t is
> begin
> select sum(reloads), sum(pins) from v$librarycache;
> end t;
> /

You must select into something. A procedure doesn't have a stdout, so you must do something with what you select.

Ken Denny Received on Fri Apr 08 2005 - 09:10:56 CDT