a critical question on UTL_FILE package
I need some help on a very critical thing that i'm working on, it' urgent and important for me to get along with my project..
I have an oracle database on a Unix box, and I have written a stored procedure which external applications residing on a mainframe access it using gateway. when external applications call my stored procedure i should be able to generate a log, i was successful in generating a log with some useful information in it using the UTL_FILE package provided by Oracle, but the problem with it is the file will get created on the same box where database is residing, but my requriement is that I should create the file on a different box (development box - it's UNIX box too!), b'coz generally it's hard to get space for your log files on production box once, the code goes to production.....
so, question is, can we create a file using UTL_FILE package on a different box other than the box where database resides ? (let's say both boxes are on a network..and can be accessed from each other through ftp)
it YES how can i do this ? if NO any other alternative other than using UTL_FILE package ? can i use ftp techniques through UTL_FILE ? or sockets something like that ? or Java stored procedures ? any idea ?
I need this very urgently...I will appreciate anyone's response or ideas on this ..
PLEASE ..you can also contact me alternatively through srini_ur_friend@yahoo.com
thanks a lot in advance...
srini.