PLS-00553: character set name is not recognized
Bonjour,
voici mon script :
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
|
SET SERVEROUT ON
DECLARE
vInHandle utl_file.file_type;
vNewLine VARCHAR2(250);
I pls_integer := 0;
LC$Fic_in Varchar2(128) := 'db1ALRT.LOG'; -- a adapter sur votre configuration
LC$Dir_in Varchar(30) := 'C:\oracle\admin\db1\bdump';
BEGIN
vInHandle := utl_file.fopen(LC$Dir_in, LC$Fic_in, 'R');
LOOP
I:=i+1;
If I=5 then
EXIT;
END if;
BEGIN
utl_file.get_line(vInHandle, vNewLine);
DBMS_OUTPUT.ENABLE(10000);
DBMS_OUTPUT.PUT_LINE(vNewLine);
EXCEPTION
WHEN OTHERS THEN
EXIT;
END;
END LOOP;
utl_file.fclose(vInHandle);
END fopen;
/ |
cela donne l'erreur :
Code:
1 2 3 4 5 6 7
|
Input truncated to 1 characters
ERROR:
ORA-06550: line 1, column 29:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated |
Avez-vous une idée ?
D'avance merci.
PS :
Code:
1 2 3 4 5 6
|
SQL> show parameter NLS
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
nls_language string AMERICAN |