Re: Java classes that manipulate files - Running in database

From: Johan Louwers <johan.louwers_at_spam-terminalcult.org>
Date: Tue, 09 Jan 2007 21:27:09 +0100
Message-ID: <iKadnULrsrJiZz7YnZ2dnUVZ8taknZ2d@casema.nl>

Carlos wrote:

> Luch ha escrito:
>

>> We use some Java classes/functions that manipulate files. Example: The

--SNIP SNIP --

>> as a paramater?

>
> Not necessarily.
> You can manage files with java classes loaded in the DB wrapped in
> PL/SQL code (packages, procedures, functions). You will need rights to
> read/write files in the directories (via DBMS_JAVA) to manage them.
>
> HTH.
>
> Cheers.
>
> Carlos.

You could even re-code the Apache FOP JAVA code with .NET code which you also can store in the database. Calling .NET code inside the database is available from Oracle Database 10g Release 2. You can find more information about .NET in the oracle database at the following locations:

http://www.oracle.com/technology/tech/dotnet/ode/index.html http://www.oracle.com/technology/pub/articles/mastering_dotnet_oracle/williams_sps.html

However, I think you want to stay with the standard Apache FOP code so I would suggest you create a "caller" in Pl/SQL which calls FOP. Meaning your .NET code calls a PL/SQL stored procedure which calls a JAVA function.

-- 
Regards, Johan Louwers
Website: http://www.terminalcult.org
Weblog:  http://johanlouwers.blogspot.com
E-mail: Johan.Louwers(at)terminalcult(dot)org

Received on Tue Jan 09 2007 - 14:27:09 CST