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 -> Re: How do I use views in a stored procedure?

Re: How do I use views in a stored procedure?

From: Vaughan Mc Carthy <vaughanm_at_medscheme.co.za>
Date: Thu, 13 Aug 1998 09:06:53 +0200
Message-ID: <6qu39t$qhu$1@hermes.is.co.za> 





Thanks


I eventually got around the problem, by granting select on the base tables
to system, as sys. I then created a view on these base tables as system and
called it another name. I then used these views in my stored procedure.
Vaughan



Received on Thu Aug 13 1998 - 02:06:53 CDT












Original text of this message













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