parameter

Parent: activity

Applies whentype in (PLSQL_PACKAGE)type in (PLSQL_PROCEDURE_FUNCTION)

Direct Properties:

PropertyTypeRequiredDefault ValueDetails
typeenumYesparameterdata type=string; lov=STATIC
Valid values: parameter functionResult
namestringYesp_data type=string; maxLen=255
Applies whentype = parameter
Enter the name of a parameter declared in the selected procedure or function.

Property Groups:

  • parameter
  • value
  • advanced
  • comments
parameter
PropertyTypeRequiredDefault ValueDetails
directionenumYesindata type=string; lov=STATIC
Valid values: in out inOut
Applies whentype = parameter
dataTypeenumYesvarchar2data type=string; lov=STATIC
Valid values: varchar2 clob number plsqlInteger boolean date timestamp timestampWithLocalTimeZone timestampWithTimeZone intervalYearToMonth intervalDayToSecond blob char rowid custom
dataTypeNamestringYesdata type=string; maxLen=32767
Applies whendataType = custom
hasDefaultbooleanYesfalsedata type=boolean
Applies whentype = parameter and direction = in
ignoreOutputbooleanYesfalsedata type=boolean
Applies whentype = parameter and direction in (inOut)type = parameter and direction in (out)
parameter {
  direction: in
  dataType: varchar2
  dataTypeName: value
  hasDefault: false
  ignoreOutput: false
}
value
PropertyTypeRequiredDefault ValueDetails
typeenumYesdata type=string; lov=STATIC
Valid values: staticValue item sqlQuery expression functionBody preference apiDefault null
Applies whentype = parameter and direction in (in) and direction in (inOut) and ignoreOutput = truetype = parameter and direction in (in) and direction in (out) and ignoreOutput = truetype = parameter and direction in (inOut) and ignoreOutput = truetype = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true
staticValuemultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type = staticValuetype = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type = staticValuetype = parameter and direction in (inOut) and ignoreOutput = true and type = staticValuetype = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type = staticValue
staticValueenumYesdata type=string; lov=STATIC
Valid values: true false
Applies whentype = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type = staticValue and dataType = booleantype = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type = staticValue and dataType = booleantype = parameter and direction in (inOut) and ignoreOutput = true and type = staticValue and dataType = booleantype = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type = staticValue and dataType = boolean
sqlQuerymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type = sqlQuerytype = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type = sqlQuerytype = parameter and direction in (inOut) and ignoreOutput = true and type = sqlQuerytype = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type = sqlQuery
itemstringYesdata type=string; maxLen=255; textCase=UPPER
Applies whentype = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type = itemtype = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type = itemtype = parameter and direction in (inOut) and ignoreOutput = true and type = itemtype = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type = itemtype = parameter and direction in (inOut) and ignoreOutput = falsetype = parameter and direction in (out) and ignoreOutput = false
languageenumYesplsqldata type=string; lov=STATIC
Valid values: sql plsql javaScript-mle
Applies whentype = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type = expressiontype = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type = expressiontype = parameter and direction in (inOut) and ignoreOutput = true and type = expressiontype = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type = expression
sqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type = expression and language = sqltype = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type = expression and language = sqltype = parameter and direction in (inOut) and ignoreOutput = true and type = expression and language = sqltype = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type = expression and language = sql
plsqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type = expression and language = plsqltype = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type = expression and language = plsqltype = parameter and direction in (inOut) and ignoreOutput = true and type = expression and language = plsqltype = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type = expression and language = plsql
javaScriptExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type = expression and language = javaScript-mletype = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type = expression and language = javaScript-mletype = parameter and direction in (inOut) and ignoreOutput = true and type = expression and language = javaScript-mletype = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type = expression and language = javaScript-mle
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whentype = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type = functionBodytype = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type = functionBodytype = parameter and direction in (inOut) and ignoreOutput = true and type = functionBodytype = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type = functionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type = functionBody and language = plsqltype = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type = functionBody and language = plsqltype = parameter and direction in (inOut) and ignoreOutput = true and type = functionBody and language = plsqltype = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type = functionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type = functionBody and language = javaScript-mletype = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type = functionBody and language = javaScript-mletype = parameter and direction in (inOut) and ignoreOutput = true and type = functionBody and language = javaScript-mletype = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type = functionBody and language = javaScript-mle
plsqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type = expression and dataType = customtype = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type = expression and dataType = customtype = parameter and direction in (inOut) and ignoreOutput = true and type = expression and dataType = customtype = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type = expression and dataType = custom
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whentype = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type = functionBody and dataType = customtype = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type = functionBody and dataType = customtype = parameter and direction in (inOut) and ignoreOutput = true and type = functionBody and dataType = customtype = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type = functionBody and dataType = custom
preferencestringYesdata type=string; maxLen=255; textCase=UPPER
Applies whentype = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type = preferencetype = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type = preferencetype = parameter and direction in (inOut) and ignoreOutput = true and type = preferencetype = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type = preference
formatMaskstringNodata type=string; maxLen=255
Applies whendataType in (number) and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (staticValue)dataType in (number) and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (item)dataType in (number) and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (preference)dataType in (number) and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (staticValue)dataType in (number) and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (item)dataType in (number) and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (preference)dataType in (number) and type = parameter and direction in (inOut) and ignoreOutput = true and type in (staticValue)dataType in (number) and type = parameter and direction in (inOut) and ignoreOutput = true and type in (item)dataType in (number) and type = parameter and direction in (inOut) and ignoreOutput = true and type in (preference)dataType in (number) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (staticValue)dataType in (number) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (item)dataType in (number) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (preference)dataType in (number) and type = parameter and direction in (inOut) and ignoreOutput = falsedataType in (number) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = falsedataType in (number) and type = parameter and direction in (out) and direction in (inOut) and ignoreOutput = falsedataType in (number) and type = parameter and direction in (out) and ignoreOutput = falsedataType in (number) and type = functionResultdataType in (date) and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (staticValue)dataType in (date) and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (item)dataType in (date) and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (preference)dataType in (date) and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (staticValue)dataType in (date) and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (item)dataType in (date) and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (preference)dataType in (date) and type = parameter and direction in (inOut) and ignoreOutput = true and type in (staticValue)dataType in (date) and type = parameter and direction in (inOut) and ignoreOutput = true and type in (item)dataType in (date) and type = parameter and direction in (inOut) and ignoreOutput = true and type in (preference)dataType in (date) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (staticValue)dataType in (date) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (item)dataType in (date) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (preference)dataType in (date) and type = parameter and direction in (inOut) and ignoreOutput = falsedataType in (date) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = falsedataType in (date) and type = parameter and direction in (out) and direction in (inOut) and ignoreOutput = falsedataType in (date) and type = parameter and direction in (out) and ignoreOutput = falsedataType in (date) and type = functionResultdataType in (timestamp) and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (staticValue)dataType in (timestamp) and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (item)dataType in (timestamp) and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (preference)dataType in (timestamp) and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (staticValue)dataType in (timestamp) and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (item)dataType in (timestamp) and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (preference)dataType in (timestamp) and type = parameter and direction in (inOut) and ignoreOutput = true and type in (staticValue)dataType in (timestamp) and type = parameter and direction in (inOut) and ignoreOutput = true and type in (item)dataType in (timestamp) and type = parameter and direction in (inOut) and ignoreOutput = true and type in (preference)dataType in (timestamp) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (staticValue)dataType in (timestamp) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (item)dataType in (timestamp) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (preference)dataType in (timestamp) and type = parameter and direction in (inOut) and ignoreOutput = falsedataType in (timestamp) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = falsedataType in (timestamp) and type = parameter and direction in (out) and direction in (inOut) and ignoreOutput = falsedataType in (timestamp) and type = parameter and direction in (out) and ignoreOutput = falsedataType in (timestamp) and type = functionResultdataType in (timestampWithTimeZone) and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (staticValue)dataType in (timestampWithTimeZone) and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (item)dataType in (timestampWithTimeZone) and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (preference)dataType in (timestampWithTimeZone) and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (staticValue)dataType in (timestampWithTimeZone) and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (item)dataType in (timestampWithTimeZone) and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (preference)dataType in (timestampWithTimeZone) and type = parameter and direction in (inOut) and ignoreOutput = true and type in (staticValue)dataType in (timestampWithTimeZone) and type = parameter and direction in (inOut) and ignoreOutput = true and type in (item)dataType in (timestampWithTimeZone) and type = parameter and direction in (inOut) and ignoreOutput = true and type in (preference)dataType in (timestampWithTimeZone) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (staticValue)dataType in (timestampWithTimeZone) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (item)dataType in (timestampWithTimeZone) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (preference)dataType in (timestampWithTimeZone) and type = parameter and direction in (inOut) and ignoreOutput = falsedataType in (timestampWithTimeZone) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = falsedataType in (timestampWithTimeZone) and type = parameter and direction in (out) and direction in (inOut) and ignoreOutput = falsedataType in (timestampWithTimeZone) and type = parameter and direction in (out) and ignoreOutput = falsedataType in (timestampWithTimeZone) and type = functionResultdataType in (timestampWithLocalTimeZone) and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (staticValue)dataType in (timestampWithLocalTimeZone) and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (item)dataType in (timestampWithLocalTimeZone) and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (preference)dataType in (timestampWithLocalTimeZone) and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (staticValue)dataType in (timestampWithLocalTimeZone) and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (item)dataType in (timestampWithLocalTimeZone) and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (preference)dataType in (timestampWithLocalTimeZone) and type = parameter and direction in (inOut) and ignoreOutput = true and type in (staticValue)dataType in (timestampWithLocalTimeZone) and type = parameter and direction in (inOut) and ignoreOutput = true and type in (item)dataType in (timestampWithLocalTimeZone) and type = parameter and direction in (inOut) and ignoreOutput = true and type in (preference)dataType in (timestampWithLocalTimeZone) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (staticValue)dataType in (timestampWithLocalTimeZone) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (item)dataType in (timestampWithLocalTimeZone) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (preference)dataType in (timestampWithLocalTimeZone) and type = parameter and direction in (inOut) and ignoreOutput = falsedataType in (timestampWithLocalTimeZone) and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = falsedataType in (timestampWithLocalTimeZone) and type = parameter and direction in (out) and direction in (inOut) and ignoreOutput = falsedataType in (timestampWithLocalTimeZone) and type = parameter and direction in (out) and ignoreOutput = falsedataType in (timestampWithLocalTimeZone) and type = functionResult
trueValuestringNodata type=string; maxLen=10
Applies whendataType = boolean and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (item)dataType = boolean and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (preference)dataType = boolean and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (item)dataType = boolean and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (preference)dataType = boolean and type = parameter and direction in (inOut) and ignoreOutput = true and type in (item)dataType = boolean and type = parameter and direction in (inOut) and ignoreOutput = true and type in (preference)dataType = boolean and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (item)dataType = boolean and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (preference)dataType = boolean and type = parameter and direction in (inOut) and ignoreOutput = falsedataType = boolean and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = falsedataType = boolean and type = parameter and direction in (out) and direction in (inOut) and ignoreOutput = falsedataType = boolean and type = parameter and direction in (out) and ignoreOutput = falsedataType = boolean and type = functionResult
falseValuestringNodata type=string; maxLen=10
Applies whendataType = boolean and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (item)dataType = boolean and type = parameter and direction in (in) and direction in (inOut) and ignoreOutput = true and type in (preference)dataType = boolean and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (item)dataType = boolean and type = parameter and direction in (in) and direction in (out) and ignoreOutput = true and type in (preference)dataType = boolean and type = parameter and direction in (inOut) and ignoreOutput = true and type in (item)dataType = boolean and type = parameter and direction in (inOut) and ignoreOutput = true and type in (preference)dataType = boolean and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (item)dataType = boolean and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = true and type in (preference)dataType = boolean and type = parameter and direction in (inOut) and ignoreOutput = falsedataType = boolean and type = parameter and direction in (inOut) and direction in (out) and ignoreOutput = falsedataType = boolean and type = parameter and direction in (out) and direction in (inOut) and ignoreOutput = falsedataType = boolean and type = parameter and direction in (out) and ignoreOutput = falsedataType = boolean and type = functionResult
value {
  type: staticValue
  staticValue: ```
    value
  ```
  sqlQuery: ```sql
    value
  ```
  item: value
  language: sql
  sqlExpression: ```sql
    value
  ```
  plsqlExpression: ```plsql
    value
  ```
  javaScriptExpression: ```javascript-mle
    value
  ```
  plsqlFunctionBody: ```plsql
    value
  ```
  javaScriptFunctionBody: ```javascript-mle
    value
  ```
  preference: value
  formatMask: value
  trueValue: value
  falseValue: value
}
advanced
PropertyTypeRequiredDefault ValueDetails
displaySequenceintegerYesdata type=integer; maxLen=32767
advanced {
  displaySequence: 42
}
comments
PropertyTypeRequiredDefault ValueDetails
commentsmultiline stringNodata type=multiline string; maxLen=4000
comments {
  comments: ```
    value
  ```
}

APEXlang Example

parameter sample (
    type: parameter
    name: value
    parameter {
        direction: in
        dataType: varchar2
        dataTypeName: value
        hasDefault: false
        ignoreOutput: false
    }
    value {
        type: staticValue
        staticValue: ```
          value
        ```
        sqlQuery: ```sql
          value
        ```
        item: value
        language: sql
        sqlExpression: ```sql
          value
        ```
        plsqlExpression: ```plsql
          value
        ```
        javaScriptExpression: ```javascript-mle
          value
        ```
        plsqlFunctionBody: ```plsql
          value
        ```
        javaScriptFunctionBody: ```javascript-mle
          value
        ```
        preference: value
        formatMask: value
        trueValue: value
        falseValue: value
    }
    advanced {
        displaySequence: 42
    }
    comments {
        comments: ```
          value
        ```
    }
)