Discussion :

[oracle13400]

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 :

Sélectionner tout - Visualiser dans une fenêtre à part

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.

[McM]

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

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

[oracle13400]

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

[oracle13400]

j'ai simplifié comme ca
ca passe:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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;
/

[lachik]

Salut @oracle13400

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

[oracle13400]

salut
non merci ca tourne en prod

[lachik]

C'est le principal

++