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. Nokia 503 marathi lengveg read softwear
  2. ipod touch 4 dont recognise ppc g5
  3. logic 9 for windows 7 200mbs
  4. bapi_po_create1 extension
  5. highesta4n
  6. itunes download 10.5
  7. lateru2t
  8. ibooks 3.1 ipa download
  9. classbx8
  10. killpi8
Copyrights 2019 Fcffair BigData Resource, All rights reserved