On Mon, Oct 3, 2011 at 2:05 PM, J.V. <jvsrvcs(at)gmail(dot)com> wrote:
> Is it possible within a stored function to:
> 1) Access the file system (to rename a file for example)
> 2) Call a java program
>
For both of these:
1) yes, if you use an untrusted program and
2) These are dangerous because they are operations that exist outside
the transactional control of the RDBMS, so it's usually better to look
to other ways of doing this, like NOTIFY and LISTEN.....
Best Wishes,
Chris Travers