packages sess.get_context_date

sess.get_context_date

Repository spec: sess.get_context_date, body: sess.get_context_date

See sess.set_context for examples.

Signature

FUNCTION get_context_date (
    in_name     VARCHAR2,
    in_raise    VARCHAR2    := 'Y'  -- boolean for SQL
)
RETURN DATE;

Show code (15 lines)

FUNCTION get_context_date (
    in_name     VARCHAR2,
    in_raise    VARCHAR2    := 'Y'  -- boolean for SQL
)
RETURN DATE AS
BEGIN
    RETURN TO_DATE(SYS_CONTEXT(sess.app_namespace, UPPER(in_name)), sess.format_date_time);
EXCEPTION
WHEN OTHERS THEN
    IF in_raise = 'Y' THEN
        RAISE_APPLICATION_ERROR(tree.app_exception_code, 'GET_CONTEXT_FAILED', TRUE);
    END IF;
    --
    RETURN NULL;
END;