Re: java stored procedures

thomas wrote:
<snipped>
> btw, i'm on oracle 10g,
> i'm loading the jars in the db without resolving them.

Reload them and resolve them, e.g.
loadjava -resolve -verbose *.jar

Then check the DBA_OBJECTS dictionary view for a list of JAVA objects that are not valid.

That should hopefully do for starters. I've got things like Batik and JFree loaded and working like that (for doing dynamic SVG streams for web graphing via PL/SQL wrappers for use by MOD_PLSQL). Not without some issues as 10G on Linux generates "wrong" SVG (which seems to be due to invalid graphic/canvas coord systems), whereas the same 10G version and code and jars work fine on WinXP.

--
Billy