Home » SQL & PL/SQL » SQL & PL/SQL » Package Not Getting Compiled (merged 3) (Oracle, 10g, Windows Server 2003)
Package Not Getting Compiled (merged 3) [message #433399] Wed, 02 December 2009 02:40 Go to next message
getritesh
Messages: 235
Registered: July 2006
Location: INDIA
Senior Member

Hello,

Following is the package i'm trying to create

Create Or Replace Package package_cusip As
  Type ref_cur_cusip Is Ref Cursor;
  Procedure proc_cusip(p_cusip_cur OUT ref_cur_cusip,
                       p_chk IN Number,
                  p_name_issuer IN GINGER.SP_ISSUE_MATURITY.NM_ISSUER%Type);
   End package_cusip;


Package package_cusip is referring table SP_ISSUE_MATURITY from GINGER schema and schema on which i'm trying to compile this package is MOSSDBO, but i'm able to describe the table as shown below


SQL> DESC GINGER.SP_ISSUE_MATURITY



Problem i'm facing is that i'm not able to compile this package
on MOSSDBO


Is there any privelege problem for the table or something else?
Also it not showing any errors, it just says

Warning: Package created with compilation errors.



Please provide some solution

Regards,
Ritesh


[EDITED by LF: topics were merged; a more informative message had been copied over the original one as "duplicates" have been deleted]

[Updated on: Wed, 02 December 2009 03:13] by Moderator

Report message to a moderator

Re: Package not getting compiled [message #433404 is a reply to message #433399] Wed, 02 December 2009 02:47 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
SELECT * FROM USER_ERRRORS WHERE NAME = 'PACKAGE_CUSIP'
Re: Package not getting compiled [message #433410 is a reply to message #433404] Wed, 02 December 2009 03:36 Go to previous messageGo to next message
getritesh
Messages: 235
Registered: July 2006
Location: INDIA
Senior Member

SQL> SELECT NAME,TEXT FROM USER_ERRORS WHERE NAME = 'PACKAGE_CUSIP';

NAME
------------------------------
TEXT
--------------------------------------------------------------------------------
PACKAGE_CUSIP
PLS-00201: identifier 'GINGER.SP_ISSUE_MATURITY' must be declared

PACKAGE_CUSIP
PL/SQL: Declaration ignored




Here SP_ISSUE_MATURITY is a valid table in GINGER schema but still it says invalid identifier.

Please tell me reason for the above error
Re: Package not getting compiled [message #433413 is a reply to message #433410] Wed, 02 December 2009 03:41 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You'll need to grant SELECT on GINGER.SP_ISSUE_MATURITY to the user that is compiling the package.This needs to be an explicit grant, and not one via a Role
Previous Topic: Using Trigger to maintain history
Next Topic: Set Alert on a Table
Goto Forum:
  


Current Time: Mon Sep 26 12:50:45 CDT 2016

Total time taken to generate the page: 0.06469 seconds