Hello I just want to implement a few
Java stored procedures on Oracle 8.1.7 on Solaris. I would like to do:
exec FILE_OPEN -- opens /foo/bar/log for write
exec FILE_CLOSE -- closes
exec FILE_LOG 'h' -- writes 'h' to that file
I wrote the classes and loaded it to the server. I granted File permission on that file to read,write using dbms_java... However when I try to use these procedures I would get an IOException at FileOutputStream.writeChars(). The IOException has no other explanation so I am at a loss. I can actually open the file OK but when I write I get this exception. Any ideas on what may be wrong?