HLP: how to check if file exists ?

Hello !

I want to know how you can check in PL/SQL if a file excists or not. BUT without using the UTL_FILE package, ie. without doing something like the following :

    fhFile := UTL_FILE.FOPEN('c:\test\', 'test.txt', 'r');    

EXCEPTION
  WHEN UTL_FILE.invalid_operation THEN ...

Because with this solution I have to copy a lot of code under the THEN in the EXCEPTION, and that's a waiste of time.

I need something like this :

  IF fileExists('c:\test\', 'test.txt') THEN   ...

Does something like this exists ?

Mich Received on Mon Nov 24 1997 - 00:00:00 CST