COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID PK COMMENTS
ID NUMBER No null 1 null Primary Key
SCHEMA_ID_FK NUMBER No null 2 null Schema to which this object belongs. Note that the PACKAGE_ID_FK (if present also leads us to the relevant schema), however a stored program may or may not belong in a package. If it is in a package, then the SCHEMA_ID_FK and the SCHEME_ID_FK in the parent package should match //PARENTFIELD
PROGRAMTYPE VARCHAR2(20 BYTE) Yes null 3 null Java/TSQL/PLSQL, etc.
NAME VARCHAR2(4000 BYTE) Yes null 4 null Name of the stored program //OBJECTNAME
PACKAGE_ID_FK NUMBER Yes null 5 null The package to which this object belongs
NATIVE_SQL CLOB Yes null 6 null The SQL used to create this object at source
NATIVE_KEY VARCHAR2(4000 BYTE) Yes null 7 null A unique indetifier for this object at source
LANGUAGE VARCHAR2(40 BYTE) No null 8 null //PUBLIC
COMMENTS VARCHAR2(4000 BYTE) Yes null 9 null null
SECURITY_GROUP_ID NUMBER No 0 10 null null
CREATED_ON DATE No sysdate 11 null null
CREATED_BY VARCHAR2(255 BYTE) Yes null 12 null null
LAST_UPDATED_ON DATE Yes null 13 null null
LAST_UPDATED_BY VARCHAR2(255 BYTE) Yes null 14 null null