Re: execute procedure

Recompile it as follows:

ALTER PROCEDURE yep COMPILE; -- at least that is the English version

If it does not indicate perfect compilation then type:

SHO ERR -- at least that is the English version

to view the errors. You will need to fix the errors in the source code and rebuild the fixed procedure.

Daniel Morgan

Doloniak wrote:

> hello
> my problem is that when i use sql*plus to execute a procedure
> the commande is :
>
> execute yep
>
> (yep is the name of the procedure)
>
> and the answer is :
>
> ERREUR a la ligne 1 :
> ORA-06550: Ligne 1, colonne 7 :
> PLS-00905: l'objet UTILISATEUR1.YEP n'est pas valide
> ORA-06550: Ligne 1, colonne 7 :
> PL/SQL: Statement ignored
>
> and i don't understand
> can sb help me pleaaaaaase
> thanks
>
> --
> Use our news server 'news.foorum.com' from anywhere.
> More details at: http://nnrpinfo.go.foorum.com/
Received on Wed Apr 24 2002 - 16:50:10 CEST