Creation d une SP

Bonjour,

j ai un souci de compilation mais je pige pas pourquoi:

"warning : Procedure created with compilations errors"

SQL> exec C_EXEC_PURGES_WMOS
BEGIN C_EXEC_PURGES_WMOS; END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object WMS.C_EXEC_PURGES_WMOS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


SQL> call C_EXEC_PURGES_WMOS
2 ;
call C_EXEC_PURGES_WMOS
*
ERROR at line 1:
ORA-06576: not a valid function or procedure name


C_EXEC_PURGES_WMOS 171896 PROCEDURE 2015-10-21 16:20:08 2015-10-21 16:28:19 2015-10-21:16:28:19 INVALID N N N 1



Mon code:
------------------------------------

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39

create or replace procedure C_EXEC_PURGES_WMOS ( ) as   BEGIN   set serveroutput on; begin wm_archive_pkg.ui_purge('1'); wm_archive_pkg.ui_purge('2'); wm_archive_pkg.ui_purge('4'); wm_archive_pkg.ui_purge('8'); wm_archive_pkg.ui_purge('10'); wm_archive_pkg.ui_purge('11'); wm_archive_pkg.ui_purge('12'); wm_archive_pkg.ui_purge('14'); wm_archive_pkg.ui_purge('15'); wm_archive_pkg.ui_purge('18'); wm_archive_pkg.ui_purge('25'); wm_archive_pkg.ui_purge('27'); wm_archive_pkg.ui_purge('29'); wm_archive_pkg.ui_purge('32'); wm_archive_pkg.ui_purge('33'); wm_archive_pkg.ui_purge('34'); wm_archive_pkg.ui_purge('35'); wm_archive_pkg.ui_purge('36'); wm_archive_pkg.ui_purge('37'); wm_archive_pkg.ui_purge('38'); wm_archive_pkg.ui_purge('40'); wm_archive_pkg.ui_purge('41'); wm_archive_pkg.ui_purge('42'); wm_archive_pkg.ui_purge('43'); wm_archive_pkg.ui_purge('44'); end ;   EXCEPTION WHEN others THEN RAISE; END C_Exec_Purges_WMOS;   /

---

si quelqu'un voit le souci? merci d'avance.

fais un SHOW ERROR; après la compilation de la procédure.

Déjà "set serveroutput on;" ce n'est pas du plsql.

Citation:

---

Envoyé par McM

fais un SHOW ERROR; après la compilation de la procédure.

Déjà "set serveroutput on;" ce n'est pas du plsql.

---

voila :
Warning: Procedure created with compilation errors.

SQL>
SQL> show errors;
Errors for PROCEDURE C_EXEC_PURGES_WMOS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1/32 PLS-00103: Encountered the symbol ")" when expecting one of the
following:
<an identifier> <a double-quoted delimited-identifier>
current delete exists prior

j'ai simplifié comme ca
ca passe:

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

create or replace procedure C_EXEC_PURGES_WMOS IS BEGIN wm_archive_pkg.ui_purge('1'); wm_archive_pkg.ui_purge('2'); wm_archive_pkg.ui_purge('4'); wm_archive_pkg.ui_purge('8'); wm_archive_pkg.ui_purge('10'); wm_archive_pkg.ui_purge('11'); wm_archive_pkg.ui_purge('12'); wm_archive_pkg.ui_purge('14'); wm_archive_pkg.ui_purge('15'); wm_archive_pkg.ui_purge('18'); wm_archive_pkg.ui_purge('25'); wm_archive_pkg.ui_purge('27'); wm_archive_pkg.ui_purge('29'); wm_archive_pkg.ui_purge('32'); wm_archive_pkg.ui_purge('33'); wm_archive_pkg.ui_purge('34'); wm_archive_pkg.ui_purge('35'); wm_archive_pkg.ui_purge('36'); wm_archive_pkg.ui_purge('37'); wm_archive_pkg.ui_purge('38'); wm_archive_pkg.ui_purge('40'); wm_archive_pkg.ui_purge('41'); wm_archive_pkg.ui_purge('42'); wm_archive_pkg.ui_purge('43'); wm_archive_pkg.ui_purge('44'); END; /

---

Salut @oracle13400

Du coup, tu n'as plus de problème ?

salut
non merci ca tourne en prod :)

C'est le principal :D

++