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
gauravpuri2002
Messages: 24
Registered: October 2007
Location: Bangalore
Junior Member
Hi

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.

regards
Gaurav
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: 68704
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
...

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


Current Time: Mon Nov 04 06:17:24 CST 2024