NLS_LANGUAGE, NLS_TERRITORY, NLS_CHARACTERSET คืออะไร

Mathurada Ekkapat

·

Follow

1 min read

·

Apr 9, 2018

--

Share

NLS_LANGUAGE, NLS_TERRITORY, NLS_CHARACTERSET-- Get NLS_LANGUAGE database parameter for this importing procedure.
BEGIN
  SELECT "VALUE" 
  INTO v_language_db
  FROM NLS_DATABASE_PARAMETERS
  WHERE PARAMETER = 'NLS_LANGUAGE';EXCEPTION
    WHEN NO_DATA_FOUND THEN 
      LOG_IMPORT_DEVIATE_HISTORY( 
         $PLSQL_UNIT, 
         'No data found while getting NLS_LANGUAGE database     
         parameters for this importing procedure.' 
      );            
      RAISE;
    WHEN OTHERS THEN 
      LOG_IMPORT_DEVIATE_HISTORY( 
        $$PLSQL_UNIT,  
        'Throws exception and exit with code:'||SQLCODE
        ||' message:'||SQLERRM
        ||' before getting NLS_LANGUAGE database parameters 
        for this importing procedure.'
      );
      RAISE;
END;
    
-- Get NLS_TERRITORY database parameter for this importing procedure.
BEGIN
  SELECT "VALUE" 
  INTO v_territory_db
  FROM NLS_DATABASE_PARAMETERS
  WHERE PARAMETER = 'NLS_TERRITORY';
        
  EXCEPTION
    WHEN NO_DATA_FOUND  THEN 
      LOG_IMPORT_DEVIATE_HISTORY(
        $$PLSQL_UNIT,
        'No data found while getting NLS_TERRITORY database    
        parameters for this importing procedure.'
      );            
      RAISE;
    WHEN OTHERS THEN 
      LOG_IMPORT_DEVIATE_HISTORY(
        $$PLSQL_UNIT,
        'Throws exception and exit with code:'||SQLCODE
        ||' message:'||SQLERRM
        ||' before getting NLS_TERRITORY database parameters 
        for this importing procedure.'
      );
      RAISE;
END;
    
-- Get NLS_CHARACTERSET database parameter for this importing procedure.
BEGIN
  SELECT "VALUE" 
  INTO v_charset_db
  FROM NLS_DATABASE_PARAMETERS
  WHERE PARAMETER = 'NLS_CHARACTERSET';

  EXCEPTION
    WHEN NO_DATA_FOUND THEN 
      LOG_IMPORT_DEVIATE_HISTORY(
        $$PLSQL_UNIT,
        'No data found while getting NLS_CHARACTERSET database 
        parameters for this importing procedure.'
      );            
      RAISE;
    WHEN OTHERS THEN 
      LOG_IMPORT_DEVIATE_HISTORY( 
        $$PLSQL_UNIT, 
        'Throws exception and exit with code:'||SQLCODE
        ||' message:'||SQLERRM
        ||' before getting NLS_CHARACTERSET database parameters 
        for this importing procedure.
      ');
      RAISE;
END;