java stored procedures fast, but slow when called as SQL function

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 15 Apr 2003 08:17:48 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7038D977E@lnewton.leeds.lfs.co.uk>

Morning Gents,

>> UTL_FILE will read and write files as user
>> oracle, so different database users can access each other's files and
it
>> is important to restrict file access to a directory.

Since 9i release 2 this is no longer an issue. Rather than specifying UTL_FILE_DIR in the init.ora file, you now create an oracle directory which points at a specific folder/directory and give individual users read and/or write privs to the oracle directory. Each user can have a different directory and thus no longer need to bollox up each other's files :o)

Cheers,
Norm.

PS. When I was at college, Virtual Machine meant just that - you appeared to have the entire resources of the machine to yourself. As far as I know, the meaning hasn't changed, it has just been 'leveraged' (aaarrgh !) to mean something totally different. A Java VM is just (!) an interpreter while a VM is something to do with multi-user systems. <dons flame proof Nomex suit and waits ....>

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

Received on Tue Apr 15 2003 - 02:17:48 CDT