Home » SQL & PL/SQL » SQL & PL/SQL » Problem with Packages (merged 3) (Oracle 10g)
Problem with Packages (merged 3) [message #432892] Fri, 27 November 2009 02:04 Go to next message
gaurav1185
Messages: 1
Registered: November 2009
Junior Member
Hello Friends

I am facing some problem with creating Packages.
I am running Oracle 10g on my side.

I have one alias defined in my system which is having two accounts , lets say one is A and other is B.

I have two Packages running on one account. Now what i have done is, I have tried to replicate the two Packages on the other account which is B. I have functions defined in both the packages.

Now what i see is one of the Packages is properly complied(Spec & Body). But I am facing the problem with other one.

The problem is

"Body PLS 00302: Component 'get_segment' must be declared"

Here 'get_segment' is a function.

If any one see what would the possible issue with these Packages, may be i missed something.

Thanks in Advance Smile
Re: Problem with Packages (merged 3) [message #432898 is a reply to message #432892] Fri, 27 November 2009 02:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- The 2 packages are not identical
- the function is not know/reacheable from the other account

Regards
Michel
Re: Problem with Packages (merged 3) [message #432901 is a reply to message #432892] Fri, 27 November 2009 02:52 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
gaurav1185 wrote on Fri, 27 November 2009 09:04
I have tried to replicate the two Packages on the other account which is B. I have functions defined in both the packages.

What does this mean? Did you "try" by typing them anew, or did you copy-paste them (which would not be "trying to replicate", but rather just replicating them)
Previous Topic: Passing :NEW as a Record
Next Topic: Oracle:Performance problem in interminent execution
Goto Forum:
  


Current Time: Tue Dec 06 14:35:48 CST 2016

Total time taken to generate the page: 0.09442 seconds