DBMS_PIPE - System Call

I've seen a lot of posts about DBMS_PIPE and using them to call C programs. However, I want to make a unix command 'happen' from a stored procedure. Specifically, I want to check if a file exists on the server and if so, delete it. I could create a script and run it, but I still need to issue an "execute" command in PL/SQL.

How do I send unix commands to the server from a stored procedure?

Do I use DBMS_PIPE or is there a different tool for this? I appreciate any advice you might be able to lend me.

eth

• o======o
  • Eric Herbert * | \\|
  • ---- ------- * < <<<\ ||
  • eriche_at_elroy.gr.hp.com * (0-0-) ||
  • 
    * * \^_/ ||
    
  • Creator of fine Spaghetti Code and * /()\ ||
  • Elusive Documentation. If you don't understand * ( ) /||\
  • it- why you probably weren't there when I wrote * || o***
  • it, were you? * // /||||\
• ||||||||