createPlSqlTableTypeCommand = OMBCREATE ( PLSQL_TABLE_TYPE "QUOTED_STRING" SET "setPropertiesClause" ) setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")" propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" } propertyValueList = "propertyValue" { "," "propertyValue" } propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" )
Sets properties (core, logical, physical, user-defined) for Table Type Valid properties are shown below:
Basic properties for PLSQL_TABLE_TYPE: Name: BUSINESS_NAME Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: Empty string Business name of the Table Type Name: DESCRIPTION Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: Empty string Description of the Table Type Name: RETURN_TYPE Type: STRING(20) Valid Values: NUMBER, VARCHAR2, VARCHAR, DATE, FLOAT Default: Empty string Return type of the Table Type. This can be a scalar type or a PLSQL Record Type.