| directory path as hyperlink in e-mail [message #412630] |
Fri, 10 July 2009 03:44  |
subusona
Messages: 70
Registered: March 2005
Location: delhi
|
Member |
|
|
I am sending mail from pl/sql. Sending the path against directory_name in oracle directory.
my pseudo code looks like
declare
lv_dir_win_path VARCHAR2(100) ;
lv_filename VARCHAR2(100) := 'xyz.txt';
begin
SELECT directory_path INTO lv_dir_win_path
FROM all_directories
WHERE directory_name = 'WIN_DIR';
Mailto(mail_to => abc@who.com,
subject => 'blah blah ',
body => 'AUDIT REPORT AS ON :'||TO_CHAR(SYSDATE,'Mon/dd/yyyy')||CHR(13)||
'Please click the following link for report review:'||CHR(13)||
lv_directory_win_path||'\'||lv_filename;-- wants this one as a hyperlink in mail
end;
I want the above link as a hyperlink so that when the click on the path he is guided to the file location.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
