The only possible glitch I see is that maybe you were not granted a
privilege to the file you are accessing. Otherwise, I am likewise
stumped as everything here seems to be in order.
-----Original Message-----
From: Subramani Ramesh
[mailto:oracledba-ezmlmshield-x96880830.[Email address protected]
Sent: Monday, December 31, 2007 12:29 AM
To: LazyDBA Discussion
Subject: utl_file not declared
hai all,
declare
v_handle utl_file.file_type;
begin v_handle:=utl_file.fopen('c:\pro\','a.txt','W');
utl_file.put_line(v_handle,'line one some text....');
utl_file.put_line(v_handle,'line two some text.....');
utl_file.fclose(v_handle);
end;
when i execute this anonymous block I am getting this error, can anyone
help out from this problem
PLS-00201: identifier 'UTL_FILE' must be declared
Thanks & Regards
--------------------------------------------------------
Ramesh Subramani
Oracle SOG Practice
Syntel Inc.
> Consider IT Done
N <0441-3109>
M <+91-9965040805>
E <[Email address protected]
Confidential: This electronic message and all contents contain
information from Syntel, Inc. which may be privileged, confidential or
otherwise protected from disclosure. The information is intended to be
for the addressee only. If you are not the addressee, any disclosure,
copy, distribution or use of the contents of this message is prohibited.
If you have received this electronic message in error, please notify the
sender immediately and destroy the original message and all copies.
Confidential: This electronic message and all contents contain
information from Syntel, Inc. which may be privileged, confidential or
otherwise protected from disclosure. The information is intended to be
for the addressee only. If you are not the addressee, any disclosure,
copy, distribution or use of the contents of this message is prohibited.
If you have received this electronic message in error, please notify the
sender immediately and destroy the original message and all copies.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page