Link to home
Start Free TrialLog in
Avatar of castelno
castelno

asked on

Oracle WebDB :"component must be declared"

I'm using Oracle WebDB running with Oracle 8i.
I can't execute some procedures in my schema because Webdb
says :
" ORA-06550:line 1, column 55:
  PLS-00302:component <component> must be declared
  ORA-06550:line 1, column 51:
  PL/SQL:Statement ignored
 
  variables in form not in procedure:
  non-default variables in procedure not in form "

I don't understood at all !
Thanks,
Noemie.

ASKER CERTIFIED SOLUTION
Avatar of meowsh
meowsh

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of castelno
castelno

ASKER

I have created a synonym and granted privileges but it isn't the solution here.

The problem is that the components - suddently - became "invalid".
The re-compilation of them says :
"  ORA-06550:line 1, column 55:
   PLS-00302:component <component> must be declared
   ORA-06550:line 1, column 51:
   PL/SQL:Statement ignored
                           
   variables in form not in procedure:
   non-default variables in procedure not in form " 

Thanks,
Noemie.