Project

General

Profile

Actions

Feature #11387

closed

Augmenter la taille du message en cas de synthèse de notifications

Added by David Lesimple over 1 year ago. Updated over 1 year ago.

Status:
Closed
Priority:
Normal
Category:
Notifications
Start date:
03/05/2020
Due date:
% Done:

100%

Estimated time:
Livraison en TEST:
Livraison en PROD:

Description

Actuellement limité à 2000 caractères, augmenter à 10000 caractères.

Actions #2

Updated by David Lesimple over 1 year ago

  • Description updated (diff)
Actions #3

Updated by David Lesimple over 1 year ago

  • Status changed from New to In progress...
  • Assignee set to David Lesimple
Actions #4

Updated by David Lesimple over 1 year ago

  • Category set to Notifications
  • Status changed from In progress... to Resolved
  • Target version set to Version 6.1
  • % Done changed from 0 to 100
Actions #5

Updated by Nicolas Eysseric over 1 year ago

  • Status changed from Resolved to Integration in progress...
Actions #6

Updated by Nicolas Eysseric over 1 year ago

  • Status changed from Integration in progress... to Closed

Validé et intégré...

Actions #7

Updated by David Lesimple over 1 year ago

Limites des bases de données pour le type VARCHAR (ou apparenté) :

- MSSQL: 8000 caractères
- Oracle: 4000 caractères

Actions #8

Updated by David Lesimple over 1 year ago

Limites des bases de données pour le type VARCHAR (ou apparenté) :

- MSSQL: 8000 caractères
- Oracle: 4000 caractères en standard, 32767 octets avec le mode étendu :
https://oracle-base.com/articles/12c/extended-data-types-12cR1

Pour activer le mode étendu sur Oracle 12c (comme toujours c'est très simple sur Oracle...) :

export ORACLE_SID=SilverTest

sqlplus / as sysdba

SQL> SHOW PARAMETER MAX_STRING_

NAME            
         TYPE     VALUE
------------------------------------ ----------- ------------------------------
max_string_size              string     STANDARD

SQL> SHUTDOWN IMMEDIATE;
Base de donnees fermee.
Base de donnees demontee.
Instance ORACLE arretee.

SQL> STARTUP UPGRADE
Instance ORACLE lancee.
..
Base de donnees montee.
Base de donnees ouverte.

SQL> alter system set MAX_STRING_SIZE='EXTENDED' SCOPE=BOTH;

Systeme modifie.

SQL> show parameter MAX_STRING_SIZE                         

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
max_string_size              string     EXTENDED

SQL> @?/rdbms/admin/utl32k.sql

Package modifie.

SQL> shutdown immediate;
Base de donnees fermee.
Base de donnees demontee.
Instance ORACLE arretee.
SQL> startup
Instance ORACLE lancee.

Total System Global Area 3221225472 bytes
Fixed Size            3715984 bytes
Variable Size          838863984 bytes
Database Buffers     2365587456 bytes
Redo Buffers           13058048 bytes
Base de donnees montee.
Base de donnees ouverte.
SQL> show parameter max_string

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
max_string_size              string     EXTENDED
SQL> exit

Actions

Also available in: Atom PDF