> > Do you have to registered available classes as objects?
>
> It allows calling only static methods. You can check Oracle
> documentation on this part. The behavior is governed by the SQLJ
> standard (level 1). Since the SQLJ does not say anything about
> selectable procedures, we have exteded it to support also static
> methods that return ResultSet instances.

Fair enough.

> Registration of a function in Fyracle looks like this:
>
> CREATE FUNCTION java_now RETURNS INTEGER AS LANGUAGE Java NAME
> 'java.lang.System.currentTimeMillis()';
>
> Specified class must be in the classpath (configuration file on the
> server). Current version does not support dynamic deployment and
> requires server restart. This has to be changed in the future.

Yep.




btw, Oracle does have a "CREATE JAVA" statement :-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com