Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-06550 identifier 'UTL FILE' must be declared

globesysMay 2 2006 — edited May 2 2006
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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 30 2006
Added on May 2 2006
1 comment
385 views