Getting error while using UTL files

Advertisement
October 11

hi All,
I'm getting following error -
ORA-29282: invalid file ID ORA-06512: at "SYS.UTL_FILE", line 774 ORA-06512: at "IMPORT_NEW", line 781 ORA-01722: invalid number
To used UTL i have done following steps -
1. created directory
2. grant read, write to that directory from sys
but every time I'm getting above error.
Can any one tell me, where am I going wrong?
Subir

Advertisement

Replay

here is the basic code...
CREATE OR REPLACE PROCEDURE import_new
begin
logfilename :=
'DnB_Source_'
|| datasetversionid
|| '-'
|| TO_CHAR (SYSDATE, 'YYMMDDHH24MI')
|| '.log';
vsfile := UTL_FILE.fopen ('import_LOG', logfilename, 'w');
UTL_FILE.put_line
(vsfile,
'No treatments have been done, Data are already in Source area.'
UTL_FILE.put_line (vsfile, '');
UTL_FILE.put_line (vsfile,
'Run began on '
|| TO_CHAR (beginrun, 'DAY MON DD HH24:MI:SS')
UTL_FILE.put_line (vsfile,
'Run ended on '
|| TO_CHAR (endrun, 'DAY MON DD HH24:MI:SS')
UTL_FILE.fclose (vsfile);
exection
END import_dnb_new

View 6 Replies

Tags:

  1. is 15 inch laptop enough for eve online
  2. sony kdl 42w805a netflix problem
  3. Phoenix.Crisis.Tool r400
  4. error: err_wis_30270 how to restore file
  5. iphoto 8.1.2 hanging delete plist
  6. set cfl in udf text box in sap
  7. fk09 mass confirmation of vendors
  8. mp01 mpn
  9. using outline load utility
  10. barnduu
Copyrights 2019 Fcffair BigData Resource, All rights reserved