How to write to a file in java when the code is deployed in oracle

Posted on 2001-06-11
Last Modified: 2010-03-31
I have a java program that I have deployed with jDeveloper to Oracle database. Is it possible to write to a file in java (fileoutputstream) when the code is in oracle. I use a pl/sql to call the program. Can I use UTL file when I am not writing to the file in the pl/sql?

Question by:bjornhel

Expert Comment

ID: 6177360
If the code is running in your Oracle Database, I am pretty sure that it is a misdesign if you need a file to write to now. You have a database. Can't you just store your data there?

Accepted Solution

graf27 earned 50 total points
ID: 6180856
of corse, it is possible. we have tested the package inside the jserv environment. so you can create, delete files outside the oracle database. sometimes i also use the jserv engine to write i.e logs from different instances to one system-file.
To call your java-programm inside the database, you need a pl/sql wrapper function/package.
If you hava one database instance, you can call directly the utl_file package to write files in the system environment. but therefore you must first create an directory link.
LVL 14

Expert Comment

ID: 9027539
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

[points to graf27]

Please leave any comments here within the next seven days.
EE Cleanup Volunteer
If you feel that your question was not properly addressed, or that none of the comments received were appropriate answers, please post your concern in THIS thread.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
servlet filter example 37 71
throw exception 21 58
Which non-HTML GUI front end to use with Java? 3 24
Crystal Reports Licensing Questions 4 34
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question