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

Home -> Community -> Usenet -> c.d.o.server -> How do I use views in a stored procedure?

How do I use views in a stored procedure?

From: Vaughan Mc Carthy <vaughanm_at_medscheme.co.za>
Date: Wed, 12 Aug 1998 11:36:32 +0200
Message-ID: <6qrnmm$4rj$1@hermes.is.co.za> 





I want to create a procedure as system, with a select from dba_segments,
which is a view. Whenever I try to compile this procedure, I get the
following error: PLS-00201: identifier 'SYS.DBA_SEGMENTS' must be declared
How do I get around this problem?



Vaughan Mc Carthy


Received on Wed Aug 12 1998 - 04:36:32 CDT












Original text of this message













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