Re: execute procedure

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 24 Apr 2002 18:51:28 +0200
Message-ID: <hfodcuocssb9i5j3m49v63p90uvko7n4d8_at_4ax.com>


On 24 Apr 2002 10:23:10 GMT, Doloniak <sett.777_at_caramail.com> 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

The procedure yep has syntax errors and didn't compile

issue
select * from dba_errors where owner = 'UTILISATEUR1' and name = 'YEP' to retrieve them.
Then resolve the errors and recompile.
If you developed this procedure on the fly select text
from dba_source
where owner = 'UTILISATEUR1'
ANd NAME = 'YEP'
order by line
to get it out the database
or download a tool like TOAD (www.toadsoft.com)

regards

[Quoted] Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Apr 24 2002 - 18:51:28 CEST

Original text of this message