Home » SQL & PL/SQL » SQL & PL/SQL » compnent "gettimeband" must be declared (oracle 10g)
compnent "gettimeband" must be declared [message #364625] Tue, 09 December 2008 05:57 Go to next message
Messages: 24
Registered: October 2007
Location: Bangalore
Junior Member

i am having a package procedure vru.load_calls.load_vru_detail which is calling a function vru.gettimeband and both the package
vru.load_calls and function vru.gettimeband are in same schema vru and vrumaint user has been granted execute priviledge to vru.gettimeband and vru.load_calls package.

while calling vru.load_calls.load_vru_detail its is throwing error compnent "gettimeband" must be declared

so what can be the issue.

Re: compnent "gettimeband" must be declared [message #364626 is a reply to message #364625] Tue, 09 December 2008 06:04 Go to previous message
Michel Cadot
Messages: 63924
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As we have neither your environment nor your code we can't say more than a general answer:
- wrong spelling
- object does not exist
- you don't have access to object
- wrong synonym

Previous Topic: commit inside a trigger (merged 3)
Next Topic: Excel "WORKDAY" function in Oracle PL/SQL
Goto Forum:

Current Time: Wed Oct 26 06:57:30 CDT 2016

Total time taken to generate the page: 0.15476 seconds