Tuesday, April 29, 2025

Breaking News
>> Securing and encrypt View State and Cookies values  >> Page has one or more controls that do not correspond with   >> “The Controls collection cannot be modified because the control contains code blocks”  >> How to fix "Validation(): Element 'xxxx' is not supported  >> How to create a new session in ASP.NET programmatically  >> MySQL Database Backup using mysqldump command    

Editors Picks

Tuesday, December 13, 2011

write log file from procedure in oracle

 create directory logfile as 'C:\log_file'; -- must have priv to do this

declare
  SFile utl_file.file_type;
begin
  SFile := utl_file.fopen(logfile ,'sunil','w'); -- w is write. This returns file handle
  utl_file.put(SFile,'Start write th log on log file'); -- note use of file handle vFile
  utl_file.fclose(SFile); -- note use of file handle vFile
end;

No comments :

Post a Comment

Contact Us

Name

Email *

Message *