Re: Removing Apostraphes From Uploaded Attachment Files

Hi:
you can remove in pl/sql the apostrope witn "replace instruction":

declare
  file_name varchar2(100):= "name of the uploaded file" begin
  file_name := replace(file_name , chr(39)); -- 39 is the ascii code of ( ' )
end;
/

I hope it's usefull to you.
Regards,
Isa Received on Tue Aug 30 2005 - 06:46:54 CDT