Re: component must be declared ...

<castelno_at_my-deja.com> schreef in berichtnieuws 7p9470$31i$1_at_nnrp1.deja.com...
> Hi,
>
> I have a problem with Oracle
> WebDB running with Oracle 8i.
>
> When i execute some procedures in my
> specific schema, WebDB tells me :
>
>
> "ORA-06550 : line 1, column 55 :
> PLS-00302 : the 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 what's happenned.
> And you ?
>
> Thanks,
> Noemie.

Hi Noemie,

You're not very clear about your problem, but I suspect that you are calling some procedures or functions that you created yourself that are: - not spelled correctly
- made in another schema, and you forgot to grant the proper rights to other users
- created the functions/procedures to be in a package, and forgot to include them into the package you meant them to be in. (This is very much possible if you created the functions/procedures in the RON in designer) - in an supposed standard package, but not installed (correctly). - called in a block structure, but incorrectly placed

So you'll have to make sure you correctly spelled the component, that the declaration of the component is correct, and that the declaration is placed correctly in the block structure. I have the same little problems all the time since I'm fairly new in programming with PL/SQL, but most of these result from spelling and declaration problems...

Hope this helps,

Bastiaan Schaap
Desyde Baarn Received on Tue Aug 17 1999 - 08:52:45 CEST