SQL & PL/SQL

Hi all,

I have a problem with this function. I have built and pl/sql program in order to send an email wich includes "pdf" file.

I have found that bfilename function works fine when you want to send a pdf file.

However, when I execute this query

SELECT bfilename('/usr/tmp', 'pdf_report.pdf') dato
FROM dual;

The result shows in the screen : /usr/tmp//pdf_report.pdf (NoExist)

I don't know why the path includes double "//".

Then, I wanted to open the file in this way

bfile_len := dbms_lob.getlength(bfile_handle);
pos := 1;
dbms_lob.open(bfile_handle,dbms_lob.lob_readonly);

an error occurs :

ORA-22285: non-existent directory or file for GETLENGTH operation.

I infere that the problem is "//" but I don't know why it happened.

Can I use another function in order to send a pdf file inside an email ? Or can I change a blob type column in order to replace "/" insted of "//" ?.

I appreciate your help.

Best Regards,
Mariano.-