Home » Developer & Programmer » Forms » directory path as hyperlink in e-mail (environment: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production)
directory path as hyperlink in e-mail [message #412630] Fri, 10 July 2009 03:44 Go to next message
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.
Re: directory path as hyperlink in e-mail [message #413260 is a reply to message #412630] Wed, 15 July 2009 00:57 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Try putting 'http:\' in from of the file name.

David
Previous Topic: How can I set the moving text on form
Next Topic: migration from oracle 9i to 10g
Goto Forum:
  


Current Time: Sat Dec 10 18:24:07 CST 2016

Total time taken to generate the page: 0.05203 seconds