Versions Compared

Old Version 1

changes.mady.by.user Søren Duusgaard

Saved on

compared with

New Version Current

changes.mady.by.user Søren Duusgaard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Column
width33%

A

CLIENT_

NUMBER

LOG

Column NameData TypeField LengthNot Null?Data Def.Comments

ID

NUMBER

22

N

  

Constraint 'client_log_pk' added.
With vers. 10.2

CREATED_DATE

DATE

 

 

 

 

CLIENT_TYPE

VARCHAR2

20

 

  

MESSAGING_TYPE

VARCHAR2

20

 

  

CLIENT_NAME

VARCHAR2

20

 

  

CLASS_NAME

VARCHAR2

200

 

  

REQUEST

CLOB

 

 

 

 

RESPONSE

CLOB

 

 

 

 

ELAPSED

NUMBER

 

 

  

OUTCOME

VARCHAR2

50

 

 

 

REQUEST_ID

VARCHAR2

100

 

  
Code Block
CREATE INDEX CLIENT_LOG_INDEX1 ON CLIENT_LOG
(OBJECT_ID);
CREATE INDEX CLIENT_LOG_INDEX2 ON CLIENT_LOG
(CLIENT_NAME);
Column
width33%

New generic table in Vs. 10.1 for logging requests / responses from any kind of third party clients.

...