## MD_STORED_PROGRAMS

Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes

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