Returns a create statement for a named jar.
SELECT STATEMENT FROM TABLE(SYS_BOOT.MGMT.GENERATE_DDL_FOR_JAR(catalog_name [optional],<schema_name>,<jar_name>);
where <schema_name> is the name of the schema in which the jar was created and <jar_name> is the name of the jar.
CREATE OR REPLACE JAR "buses"."GeoIp"'
'LIBRARY 'file:plugin/geoip/geoip.jar''
'OPTIONS(0);
You can implement this function using the following code:
SELECT STATEMENT FROM TABLE(SYS_BOOT.MGMT.GENERATE_DDL_FOR_JAR('buses', 'GeoIp'));
'STATEMENT'
'CREATE OR REPLACE JAR "buses"."GeoIp"'
'LIBRARY 'file:plugin/geoip/geoip.jar''
'OPTIONS(0);'