Edit D:\app\Administrator\product\11.2.0\dbhome

Edit D:\app\Administrator\product\11.2.0\dbhome_1\md\admin\sdosemctxh.sql

Rem
Rem $Header: sdosemctxh.sql 17-apr-2006.13:16:23 alwu Exp $
Rem
Rem sdosemctxh.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      sdosemctxh.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    alwu        04/17/06 - start
Rem    alwu        04/17/06 - start
Rem    alwu        04/17/06 - Created
Rem

create or replace package sdo_sem_ctx as
  --
  -- Constants
  --

-- Note: this context should be created using
  -- create context SDO_SEM_CTX using mdsys.SDO_SEM_CTX accessed globally;
  SDO_SEM_CTX constant varchar2(20) := 'SDO_SEM_CTX';

LOG_LEVEL   constant varchar2(20) := 'LOG_LEVEL';

--
  -- APIs
  --
  procedure set_param( name in varchar2,
                      value in varchar2);

function get_param( name in varchar2) return varchar2;

--
  -- APIs: convenient wrappers
  --
  procedure set_log_level(value in varchar2);
  function get_log_level return varchar2;
end;
/

show errors;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de