Home » Developer & Programmer » Forms » directory path as hyperlink in e-mail (environment: Oracle Database 10g Enterprise Edition Release - 64bit Production)
directory path as hyperlink in e-mail [message #412630] Fri, 10 July 2009 03:44 Go to next message
Messages: 70
Registered: March 2005
Location: delhi

I am sending mail from pl/sql. Sending the path against directory_name in oracle directory.

my pseudo code looks like


lv_dir_win_path VARCHAR2(100) ;
lv_filename VARCHAR2(100) := 'xyz.txt';

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

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
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Try putting 'http:\' in from of the file name.

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

Current Time: Wed Aug 16 14:21:08 CDT 2017

Total time taken to generate the page: 0.17685 seconds