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

Home -> Community -> Usenet -> comp.databases.oracle -> PLS-00201 and ORA-00942 when creating a package

PLS-00201 and ORA-00942 when creating a package

From: Per Magnus L?vold <pmlovold_at_broadpark.no>
Date: 5 Jan 2004 02:34:41 -0800
Message-ID: <a0c31732.0401050234.b1307ba@posting.google.com> 






Hi,


I am trying to create a package under the apps schema, and I keep
getting PLS-00201 and ORA-00942 when refering to types from other
apps-packages and other views / tables.



I even get this error when calling a quite simple:
MY_NUM := FND_PROFILE.VALUE('MY_PROFILE_NAME');


Any ideas what I can be doing wrong?


This same code was originally part of a trigger code, and worked just
fine.



-Per Magnus
Received on Mon Jan 05 2004 - 04:34:41 CST












Original text of this message













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