6.97 SDO_NET.SET_LOGGING_LEVEL
Format
SDO_NET.SET_LOGGING_LEVEL( level IN NUMBER);
Description
Sets the minimum level of severity for messages to be displayed for network operations.
Parameters
Usage Notes
All messages at the specified logging level and higher levels will be written. The logging levels, from highest to lowest, are:
SDO_NET.LOGGING_LEVEL_FATAL SDO_NET.LOGGING_LEVEL_ERROR SDO_NET.LOGGING_LEVEL_WARN SDO_NET.LOGGING_LEVEL_INFO SDO_NET.LOGGING_LEVEL_DEBUG SDO_NET.LOGGING_LEVEL_FINEST
The logging level is the Java logging level from the underlying implementation of this function; therefore, to see the Java logging output on the console, execute the following statements beforehand:
SET SERVEROUTPUT ON; EXECUTE DBMS_JAVA.SET_OUTPUT(10000);
Examples
The following example sets the logging level at SDO_NET.
LOGGING_LEVEL_ERROR
, which means that only messages with a severity of SDO_NET.LOGGING_LEVEL_ERROR
or SDO_NET.LOGGING_LEVEL_FATAL
will be displayed.
EXECUTE SDO_NET.SET_LOGGING_LEVEL(SDO_NET.LOGGING_LEVEL_ERROR);
Parent topic: SDO_NET Package Subprograms