Java Function in Oracle function
Posted on 2011-10-17
I have a rather urgent problem.
I have a java function which is called inside an oracle (11g r2) procedure.
Now there is a problem inside that java function. I think I have fixed the java code but now to test it.
The definition of that function is myfunc(inClob CLOB, outBlob BLOB);
Now my problem is that while I have some knowledgeof Java and a bit of SQL combining and testing it is a bit ourside my scope and I do not have access to the oracle calling code so I can not run anything there.
As far as I understand it the inClob contains some simple text and the outBlob contains the modified data.
The modified data will be written to a file.
What I now need help isis either some example SQL code of how to save that modified java code into the database and how to call it so that it writes out a file or if that is too complex then how do I texst the clob and blob parameters inside java as they are both just interfaces and the serialblob is also not helping.
Any suggestions or ideas are greately appreciated.