I have a situation where I need to execute some code, which for a number of reasons (which I will not do here) is better done in Java than in PL / SQL. As I see, there are two options:
Create a jar with all my compiled code and other supporting files / other banks, load the jar into Oracle (we will run 10g) and run Java from the stored procedure.
- Pros: Java code integrates very well with the rest of the system, can be called from existing PL / SQL.
- Cons: I have very little experience working with Java in Oracle.
Leave Java in a separate jar and execute it through shell scripts.
- Pros: I already wrote Java, so I am familiar with it.
- Cons: Poor integration with everything else is likely to require additional manual steps to run and manage.
Java code will have to read XML data from Oracle tables and write data (non-XML) to other tables, so the amount of database integration made me think that loading Java code into the database might be a good idea, but I'm just not sure. ..
How do people download and run Java code from Oracle? How easy is it to test and debug? Are there any special tools? Any "gotchas" that I should know about?
source
share