Java Stored Procedure in Oracle

[Tom Kat]

hi all
i am new to java stored procedures and have some doubts which are as follows
1. Can a java stored procedure running in an oracle 8i(8.1.7) server "read from and write to" an ASCII file stored in the file system of the machine(on which oracle 8i server is running).
2. If it can be done then what are the settings that need to be done. By settings, I mean the access privileges and rights that the user shud be having.
I have an oracle(8.1.7) server and client running on Win 2k on P4 dual processor box
Please Help
Thanks in advance
Gaurav

[Geeta Ramasami]

Hi,
U can write the java class which writes to a file in the server using filesystem object.Using the loadjava utility u can load the java file to the oracle database to the appropriate schema.The users pertaining to the schema will have access to the java file loaded into oracle DB.In the BE u can write a stored procedure which calls the java class which writes a file.
Is this the one u r looking in for?
Cheers
Geeta

[Tom Kat]

hey geeta thanks a lot for the reply..
but it was a 2 weeks 2 late...now i m quiet comfortable with writing, loading and publishing java stored procedures. But m still facing some problems with the portability of my procedures.
The problem is that i've written a java stored procedure that reads from a file and another that writes to a file. I m using windows 2000 professional and oracle server is on win2k client. on win2k these procedures are running fine..but when i m trying to execute these procedures in Solaris environment i.e. oracle 8.1.7 server running on a solaris box(5.8) it doesnt executes and gives error. loading and publishing dont throw any error only execution throws error. can u help me out?? :roll: