ora-06550 identifier 'UTL FILE' must be declared
DECLARE CURSOR C1 IS
SELECT
NOTE_1 NOMEF
,NOTE_2 NOMEP
,NOTE_3 NOMEQ
FROM
ORCRA
WHERE
COD_DITTA='01'
AND CAU_MOVIM='PRC'
AND NUM_MOVIMENTO='0'
AND NVL(NOTE_1,'*')<>'*'
;
RIGA_E VARCHAR2(2000);
FILEEXP VARCHAR2(12);
FILE_HANDLE UTL_FILE.FILE_TYPE;
BEGIN
FILEEXP:='CPONYX.BAT';
FILE_HANDLE := UTL_FILE.FOPEN('C:\GLOBE',FILEEXP,'W');
FOR V_ROW IN c1
LOOP
RIGA_E:='COPY C:\SMARTJOB\ONYX\'||V_ROW.NOMEF||' C:\ONYXGRAPHICS\POSTERSHOP\INPUT\'||V_ROW.NOMEP||'\'||V_ROW.NOMEQ;
UTL_FILE.PUT_LINE(FILE_HANDLE,RIGA_E);
END LOOP;
UTL_FILE.FCLOSE(FILE_HANDLE);
COMMIT;
END
;
Launching this pl-sql script on oracle10g it answers me the error:
ora-06550 identifier 'UTL FILE' must be declared
Note that in
SHOW PARAMETERS
it responds:
...
...
utl_file_dir string *
...
...
Thanks!