Rem drv: <migrate type="schema_upgrade" version="10.2.0.4"/>
Rem
Rem $Header: security_schema_upgrade.sql 16-aug-2007.08:08:09 pchebrol Exp $
Rem
Rem security_schema_upgrade.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      security_schema_upgrade.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    pchebrol    08/16/07 - Add header
Rem    pchebrol    06/22/07 - Backport shianand_core_5121288 from main
Rem    pchebrol    06/21/07 - Created
Rem

COLUMN :script_name NEW_VALUE sec_upg_file NOPRINT
VARIABLE script_name VARCHAR2(1024);

DECLARE
  l_obj_name VARCHAR2(64);
BEGIN

  BEGIN
    SELECT COLUMN_NAME INTO l_obj_name
      FROM all_tab_columns
     WHERE owner = '&&EM_REPOS_USER'
       AND table_name = 'MGMT_SEC_INFO'
       AND column_name = 'B64_LOCAL_CA';

    :script_name := '&&EM_SQL_ROOT/core/latest/admin/admin_do_nothing.sql';

  EXCEPTION
    WHEN NO_DATA_FOUND THEN
      :script_name := '&&EM_SQL_ROOT/core/10.2.0.4/security/security_tables.sql';
  END;

END;
/

SELECT :script_name FROM DUAL;

@@&&sec_upg_file