Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: compilation error--a procedure under system account

Re: compilation error--a procedure under system account

From: Ken Denny <ken_at_kendenny.com>
Date: 8 Apr 2005 07:10:56 -0700
Message-ID: <1112969456.140659.103240@f14g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US