Search code examples
c#oracle-databasefile-exists

Oracle procedure to check if file exists on a web server

I have a site that I call an oracle procedure and within it I create html code to put in my dynamic process in "C#". The html code creates a link to a pdf file.

Everything is working great until I was asked to put a check that the files exist on the web server and if not do not show the link. Is this possible to do in oracle? If not would I have to change my entire approach now?

Solution

  • Use UTL_FILE.FGETATTR() on the server side.

    https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/u_file.htm#i1003493