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 -> Table not accessible through Stored Proc

Table not accessible through Stored Proc

From: raghu <raghu_vnin_at_yahoo.com>
Date: 24 Jan 2006 09:40:46 -0800
Message-ID: <1138124446.895693.14620@g43g2000cwa.googlegroups.com> 





I am able to run select queries on a table through sql and anonymous
pl/sql scripts. But cannot run the same query through a stored
procedure. I get the error 'PL/SQL: ORA-00942: table or view does not
exist'.


What might be the problem?



Thanks.
Received on Tue Jan 24 2006 - 11:40:46 CST












Original text of this message













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