Home » SQL & PL/SQL » SQL & PL/SQL » Strange PLS-00302 behavoir (Oracle 10.2.0.3)
Strange PLS-00302 behavoir [message #403928] Tue, 19 May 2009 10:14 Go to next message
bragggf
Messages: 3
Registered: May 2009
Junior Member
There may have a quick solution to this issue but it has me perplexed.

I have a package of procedures that compiles just fine, with one of the procedures exposed in the header.

However, when I call this procedure from a PL/SQL unit test script I get the following:

ERROR at line 19:
ORA-06550: line 19, column 15:
PLS-00302: component 'SHOT_HISTORY' must be declared
ORA-06550: line 19, column 3:
PL/SQL: Statement ignored

I will get this error even if I am logged in as sysdba.

The packaged proc is in all_arguments, I can describe the package and see the published procs. I have 3 other db instances running the schemas involved and have no issues. Grants are identical between instances.

Any clues?
Re: Strange PLS-00302 behavoir [message #403929 is a reply to message #403928] Tue, 19 May 2009 10:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I will get this error even if I am logged in as sysdba.


This is your first error.

- Never ever use SYS but for maintenance purpose (startup, shutdown, backup, recover)
- SYS is special
- SYS is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS" and you'll see the immediate answer)
- SYS does not act like any other user
- When you use SYS Oracle deactivates some code path and activates others
- Whatever you do with SYS will neither validate nor invalidate the same thing with any other user.

NEVER EVER use SYS for anything that can be done by another user.
Use SYS ONLY for something that can't be done by someone else.


Then without any information, there is no answer.

Regards
Michel
Re: Strange PLS-00302 behavoir [message #403933 is a reply to message #403928] Tue, 19 May 2009 10:22 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Any clues?
I have fewer clues than you & it appears you may be clueless.
Why do you expect folks to debug code they can not see because you choose to not post it?

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed
Re: Strange PLS-00302 behavoir [message #403936 is a reply to message #403928] Tue, 19 May 2009 10:38 Go to previous messageGo to next message
bragggf
Messages: 3
Registered: May 2009
Junior Member
An old public synonym was the culprit, which should have never existed on the given instance. Thus, when I 'described' the procedure it would resolve the name from the public synonym but the unit test script referenced the schema.object_name
Re: Strange PLS-00302 behavoir [message #403938 is a reply to message #403933] Tue, 19 May 2009 10:44 Go to previous messageGo to next message
bragggf
Messages: 3
Registered: May 2009
Junior Member
Is this your standard reply? Is there a reason to insult?

Do we always need to post the code and waste the time of others (not my time - the time of other list members) if it is obviously not a code issue? In this case I knew it was some flavor of a permissions/grants issue but certainly not a code issue.

now can go back and be adults?
Re: Strange PLS-00302 behavoir [message #404016 is a reply to message #403928] Wed, 20 May 2009 01:30 Go to previous messageGo to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

@bragggf

well said, i have seen his posts from 600 to 18XX just like that !! i think now you know why !

Re: Strange PLS-00302 behavoir [message #404031 is a reply to message #404016] Wed, 20 May 2009 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ashoka_bl wrote on Wed, 20 May 2009 08:30
@bragggf

well said, i have seen his posts from 600 to 18XX just like that !! i think now you know why !

Does not your answer belong to the same category?

Regards
Michel

Re: Strange PLS-00302 behavoir [message #404055 is a reply to message #403928] Wed, 20 May 2009 03:56 Go to previous messageGo to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

@Michel,

I dont want it to be a arguement kind of thing, but Honestly i wont SPAM here, i will not as well.

The question that has asked by many people doesn't always require that they need to Publish everything, I have seen some Gurus answering without them.

And i also observed that Blackswan always answer ( !!!!) harshly and will dfntly make other people to take backstep to answer or to post.

Regards,
Ashoka BL
Re: Strange PLS-00302 behavoir [message #404353 is a reply to message #404055] Thu, 21 May 2009 08:25 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Hi ashoka_bl

Fully agree with
Quote:
And i also observed that Blackswan always answer ( !!!!) harshly and will dfntly make other people to take backstep to answer or to post.

Laughing

regards,
Delna
Re: Strange PLS-00302 behavoir [message #404356 is a reply to message #404353] Thu, 21 May 2009 08:35 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'm right alongside this one.
There is helpful advice in quite a few of his posts, but many of them are unhelpful, sometimes insulting, and quite likely to drive posters away from the site.
Re: Strange PLS-00302 behavoir [message #404357 is a reply to message #404353] Thu, 21 May 2009 08:40 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The answers do not now belong in anything with the topic, so it is locked.
If you have anything to say on someone's post, create a topic in "Suggestions & Feedback" forum, it is there for this.

Regards
Michel
Previous Topic: Need to optimize query
Next Topic: Float
Goto Forum:
  


Current Time: Sat Dec 03 01:07:03 CST 2016

Total time taken to generate the page: 0.10185 seconds