|
|
| Re: File Name TEXT_IO How Can i Create this Please Help Me. [message #87727 is a reply to message #87725] |
Fri, 04 February 2005 02:19  |
Anil Pushkar
Messages: 4
Registered: February 2005
|
Junior Member |
|
|
you use DDE package from oracle form if you use orcale form.
or use
declare
v_file_name varchar(300):='temp';
out_file_exe text_io.file_type;
begin
out_file_exe := Text_io.Fopen('c:'||lower(v_file_name)||'.xls', 'w');
text_io.put_line(out_file_exe,to_char(sysdate,'DD-MON-YYYY, HH24:MI:SS '));
text_io.fclose(out_file_exe);
EXCEPTION WHEN OTHERS THEN
message('Msg for File - '||sqlcode ||': '||sqlerrm ); message('Msg for File - '||sqlcode ||': '||sqlerrm );
end;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
