variable

Parent: version

Direct Properties:

PropertyTypeRequiredDefault ValueDetails
staticIdstringYesdata type=string; maxLen=255; textCase=UPPER

Property Groups:

  • label
  • parameter
  • value
  • displayFormatMasks
  • comments
label
PropertyTypeRequiredDefault ValueDetails
labelstringYesdata type=string; maxLen=4000
An end-user friendly name of the workflow variable.
 
label {
  label: value
}
parameter
PropertyTypeRequiredDefault ValueDetails
dataTypeenumYesvarchar2data type=string; maxLen=128; lov=STATIC
Valid values: varchar2 timestamp timestampWithLocalTimeZone timestampWithTimeZone number boolean clob
 
parameter {
  dataType: varchar2
}
value
PropertyTypeRequiredDefault ValueDetails
typeenumYesnulldata type=string; lov=STATIC
Valid values: staticValue item sqlQuery expression functionBody null
staticValuemultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = staticValue
staticValueenumYesdata type=string; lov=STATIC
Valid values: true false
Applies whentype = staticValue and dataType = boolean
itemstringYesdata type=string; maxLen=255; textCase=UPPER
Applies whentype = item
sqlQuerymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = sqlQuery
languageenumYesplsqldata type=string; lov=STATIC
Valid values: sql plsql javaScript-mle
Applies whentype = expression
sqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = expression and language = sql
plsqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = expression and language = plsql
javaScriptExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = expression and language = javaScript-mle
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whentype = functionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = functionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = functionBody and language = javaScript-mle
 
value {
  type: staticValue
  staticValue: ```
    value
  ```
  item: value
  sqlQuery: ```sql
    value
  ```
  language: sql
  sqlExpression: ```sql
    value
  ```
  plsqlExpression: ```plsql
    value
  ```
  javaScriptExpression: ```javascript-mle
    value
  ```
  plsqlFunctionBody: ```plsql
    value
  ```
  javaScriptFunctionBody: ```javascript-mle
    value
  ```
}
displayFormatMasks
PropertyTypeRequiredDefault ValueDetails
sessionStateFormatMaskstringNodata type=string; maxLen=255
Applies whendataType in (number)dataType in (timestamp)dataType in (timestampWithTimeZone)dataType in (timestampWithLocalTimeZone)
Format mask to be used to convert the workflow variable into a NUMBER or TIMESTAMP and back into a VARCHAR2 when the parameter is used in a bind variable or substitution string.
trueValuestringNodata type=string; maxLen=10
Applies whendataType = boolean
falseValuestringNodata type=string; maxLen=10
Applies whendataType = boolean
 
displayFormatMasks {
  sessionStateFormatMask: value
  trueValue: value
  falseValue: value
}
comments
PropertyTypeRequiredDefault ValueDetails
commentsmultiline stringNodata type=multiline string; maxLen=4000
 
comments {
  comments: ```
    value
  ```
}

APEXlang Example

variable sample (
    staticId: value
    label {
        label: value
    }
    parameter {
        dataType: varchar2
    }
    value {
        type: staticValue
        staticValue: ```
          value
        ```
        item: value
        sqlQuery: ```sql
          value
        ```
        language: sql
        sqlExpression: ```sql
          value
        ```
        plsqlExpression: ```plsql
          value
        ```
        javaScriptExpression: ```javascript-mle
          value
        ```
        plsqlFunctionBody: ```plsql
          value
        ```
        javaScriptFunctionBody: ```javascript-mle
          value
        ```
    }
    displayFormatMasks {
        sessionStateFormatMask: value
        trueValue: value
        falseValue: value
    }
    comments {
        comments: ```
          value
        ```
    }
)