| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Support utilities for Java such as setting the host and port of the proxy server for internet access.
This package, and the user that owns it, are not installed by default by OUI or DBCA. |
| AUTHID |
CURRENT_USER |
| Constants |
| Name |
Data Type |
Value |
| Logging levels |
| LOGGING_LEVEL_OFF |
INTEGER |
0 |
| LOGGING_LEVEL_SEVERE |
INTEGER |
1 |
| LOGGING_LEVEL_WARNING |
INTEGER |
2 |
| LOGGING_LEVEL_INFO |
INTEGER |
3 |
| LOGGING_LEVEL_FINE |
INTEGER |
4 |
| LOGGING_LEVEL_FINER |
INTEGER |
5 |
| LOGGING_LEVEL_FINEST |
INTEGER |
6 |
| LOGGING_LEVEL_ALL |
INTEGER |
7 |
| Predelivered category ids and names |
| EPC_ENCODING_CATEGORY_ID |
BINARY_INTEGER |
1 |
| EPC_ENCODING_CATEGORY_NAME |
VARCHAR2(32) |
'EPC' |
|
| Dependencies |
| DBMS_LOG |
DUAL |
MGD$VARCHAR2S |
| DBMS_OUTPUT |
MGD$CLOBS |
|
|
| Documented |
Yes: Packages and Types Reference |
| Exceptions |
| Error Code |
Reason |
| ORA-55200 |
TDTJavaException |
| ORA-55201 |
TDTCategoryNotFound |
| ORA-55202 |
TDTSchemeNotFound |
| ORA-55203 |
TDTLevelNotFound |
| ORA-55204 |
TDTOptionNotFound |
| ORA-55205 |
TDTFieldValidationException |
| ORA-55206 |
TDTUndefinedField |
| ORA-55207 |
TDTRuleEvaluationFailed |
| ORA-55208 |
TDTTooManyMatchingLevels |
|
| First Available |
11.2 |
| Pragma |
PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE); |
| Security Model |
Owned by MGDSYS with no privileges granted created by {ORACLE_HOME}/rdbms/admin/mgdsys.sql |
| Source |
{ORACLE_HOME}/rdbms/admin/mgdus.sql
{ORACLE_HOME}/rdbms/admin/prvtmgdub.plb
Install from $ORACLE_HOME/mgw/admin/catmgw.sql |
| Subprograms |
|
| |
| ADD_SCHEME |
| Adds a tag data translation scheme to an existing category |
dbms_mgd_id_utl.add_scheme(category_id IN VARCHAR2, tdt_xml IN CLOB); |
| TBD |
| |
| CREATE_CATEGORY |
| Creates a new category, or a new version of a category |
dbms_mgd_id_utl.create_category(
category_name IN VARCHAR2,
category_version IN VARCHAR2,
agency IN VARCHAR2,
uri IN VARCHAR2)
RETURN VARCHAR2; |
| TBD |
| |
| EPC_TO_ORACLE_SCHEME |
| Converts EPCGlobal tag data translation xml to Oracle tag data translation XML |
dbms_mgd_id_utl.epc_to_oracle_schema(xmlScheme IN CLOB) RETURN CLOB; |
| TBD |
| |
| GET_CATEGORY_ID |
| Returns the category id for the input category name and category version |
dbms_mgd_id_utl.get_category_id(
category_name IN VARCHAR2,
category_version IN VARCHAR2)
RETURN VARCHAR2; |
SELECT mgdsys.dbms_mgd_id_utl.get_category_id('EPC', '1'); |
| |
| GET_COMPONENTS |
| Returns a list of semicolon separated component names, separated for the scheme |
dbms_mgd_id_utl.get_components(
category_id IN VARCHAR2,
scheme_name IN VARCHAR2)
RETURN VARCHAR2; |
| TBD |
| |
| GET_ENCODING |
| Returns a list of semicolon separated encodings (formats) for the scheme |
dbms_mgd_id_utl.get_encoding(
category_id IN VARCHAR2,
scheme_name IN VARCHAR2)
RETURN VARCHAR2; |
| TBD |
| |
| GET_JAVA_LOGGING_LEVEL |
| Returns the Java trace level of the logging level for tracing MGD |
dbms_mgd_id_utl.java_plsql_logging_level RETURN INTEGER; |
SELECT mgdsys.dbms_mgd_id_utl.get_java_logging_level; |
| |
| GET_PLSQL_LOGGING_LEVEL |
| Returns the PL/SQL trace level of the logging level for tracing mgd |
dbms_mgd_id_utl.get_plsql_logging_level RETURN INTEGER; |
SELECT dbms_mgd_id_utl.get_plsql_logging_level; |
| |
| GET_SCHEME_NAMES |
| Returns a list of semicolon separated scheme names for the specified category |
dbms_mgd_id_utl.get_scheme_names(category_id IN VARCHAR2) RETURN VARCHAR2; |
| TBD |
| |
| GET_TDT_XML |
| Returns tag data translation XML for the specified scheme |
dbms_mgd_id_utl.get_tdt_xml(
category_id IN VARCHAR2,
scheme_name IN VARCHAR2)
RETURN CLOB; |
| TBD |
| |
| GET_VALIDATOR |
| Returns the tag data translation schema |
dbms_mgd_id_utl.get_validator RETURN CLOB; |
SELECT dbms_mgd_id_utl.get_validator; |
| |
| REFRESH_CATEGORY |
| Refreshes the metadata information on the java stack for the specified category |
dbms_mgd_id_utl.refresh_category(category_id IN VARCHAR2); |
exec dbms_mgd_id_utl.refresh_category('2');
PL/SQL procedure successfully completed. |
| |
| REMOVE_CATEGORY |
Removes a category. If version is null, all versions for this category will be removed.
Overload 1 |
dbms_mgd_id_utl.remove_category(
category_name IN VARCHAR2,
category_version IN VARCHAR2); |
exec dbms_mgd_id_utl.remove_category('EPC');
PL/SQL procedure successfully completed. |
| Overload 2 |
dbms_mgd_id_utl.remove_category(category_id IN VARCHAR2); |
| TBD |
| |
| REMOVE_PROXY |
| Unset the host and port of the proxy server |
dbms_mgd_id_utl.remove_proxy; |
exec dbms_mgd_id_utl.remove_proxy;
PL/SQL procedure successfully completed. |
| |
| REMOVE_SCHEME |
| Removes a tag data translation scheme from a category |
dbms_mgd_id_utl.remove_scheme(
category_id IN VARCHAR2,
scheme_name IN VARCHAR2); |
| TBD |
| |
| SET_JAVA_LOGGING_LEVEL |
| Sets the Java logging level for tracing mgd returning the current trace level |
dbms_mgd_id_utl.set_plsql_logging_level(level IN INTEGER); |
exec dbms_mgd_id_utl.set_plsql_logging_level(dbms_mgd_id_utl.logging_level_finest);
PL/SQL procedure successfully completed. |
| |
| SET_PLSQL_LOGGING_LEVEL |
| Set the PL/SQL logging level for tracing mgd returning the current trace level |
dbms_mgd_id_utl.set_plsql_logging_level(level IN INTEGER); |
exec dbms_mgd_id_utl.set_plsql_logging_level(dbms_mgd_id_utl.logging_level_finest);
PL/SQL procedure successfully completed. |
| |
| SET_PROXY |
| Sets the host and port of the proxy server for internet access |
dbms_mgd_id_utl.set_proxy(
proxyHost IN VARCHAR2,
proxyPort IN VARCHAR2); |
| TBD |
| |
| VALIDATE_SCHEME |
| Validates the input tag data translation xml against the tag tag data translation schema |
dbms_mgd_id_utl.validate_scheme(xmlScheme IN CLOB) RETURN VARCHAR2; |
Usage documented in {ORACLE_HOME}/rdbms/admin/mgdtrg.sql |