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 -> pl/sql curser will not select from another schema ????

pl/sql curser will not select from another schema ????

From: Anders Hattestad <hattis_at_bigfoot.com>
Date: 1997/09/17
Message-ID: <34200529.285E@bigfoot.com>#1/1 







Hi!



I have a litle problem. 


I'm making a litle sql/pl code. I'm logged on as system with dba privl.
when the I trie to compaile my code I get a error saying:
PLS-00201: identifier 'TRAFTEKS.STED_DEFS' must be declared
CURSOR c1 IS


 select dato from TRAFTEKS.STED_DEFS;



It works from sql*plus.



I have looked at Deja News and one person sayd it my be a premision
problem. Thats not the case here. 



Have anyone a tip?



Anders
Received on Wed Sep 17 1997 - 00:00:00 CDT












Original text of this message













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