COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID PK COMMENTS
ID NUMBER No null 1 1 null
CONNECTION_ID_FK NUMBER No null 2 null the connection in which this belongs //PARENTFIELD
OBJECT_ID NUMBER No null 3 null null
OBJECT_TYPE VARCHAR2(4000 BYTE) No null 4 null null
PARAM_EXISTING NUMBER No null 5 null 1 represents a new parameter for PL/SQL that was not present in the origional. 0 represents a n existing parameter that was present in the origional
PARAM_ORDER NUMBER No null 6 null IF -1 THEN THIS PARAM IS A RETURN PARAMETER. 1 WILL BE THE FIRST PARAMETER IN THE PARAMETER LIST
PARAM_NAME VARCHAR2(4000 BYTE) No null 7 null null
PARAM_TYPE VARCHAR2(4000 BYTE) No null 8 null null
PARAM_DATA_TYPE VARCHAR2(4000 BYTE) No null 9 null null
PERCISION NUMBER Yes null 10 null null
SCALE NUMBER Yes null 11 null null
NULLABLE CHAR(1 BYTE) No null 12 null null
DEFAULT_VALUE VARCHAR2(4000 BYTE) Yes null 13 null null
SECURITY_GROUP_ID NUMBER No 0 14 null null
CREATED_ON DATE No sysdate 15 null null
CREATED_BY VARCHAR2(255 BYTE) Yes null 16 null null
LAST_UPDATED_ON DATE Yes null 17 null null
LAST_UPDATED_BY VARCHAR2(255 BYTE) Yes null 18 null null