|Subject||Re: Java Stored Procedures|
> 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.
Registration of a function in Fyracle looks like this:
CREATE FUNCTION java_now RETURNS INTEGER AS LANGUAGE Java NAME
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.