@Target({}) @Retention(RUNTIME) public @interface PLSQLParameter
A PLSQLParameter annotation is used within a NamedPLSQLStoredProcedureQuery or PLSQLRecord annotation.
Since:
EclipseLink 2.3
See Also:
  • Required Element Summary

    Required Elements
    Modifier and Type
    Required Element
    Description
    (Required) Stored procedure parameter name.
  • Optional Element Summary

    Optional Elements
    Modifier and Type
    Optional Element
    Description
    (Optional) The database data-type for the paramter.
    (Optional) The direction of the stored procedure parameter.
    int
    (Optional) The max length of the field value.
    boolean
    (Optional) Define if the parameter is required, or optional and defaulted by the procedure.
    int
    (Optional) If a numeric, the max precision value.
    (Optional) The query parameter name.
    int
    (Optional) If a numeric, the max scale value.
  • Element Details

    • direction

      Direction direction
      (Optional) The direction of the stored procedure parameter.
      Default:
      IN
    • name

      String name
      (Required) Stored procedure parameter name.
    • queryParameter

      String queryParameter
      (Optional) The query parameter name.
      Default:
      ""
    • optional

      boolean optional
      (Optional) Define if the parameter is required, or optional and defaulted by the procedure.
      Default:
      false
    • databaseType

      String databaseType
      (Optional) The database data-type for the paramter. This either one of the type constants defined in OraclePLSQLTypes, or JDBCTypes, or a custom record or table type name.
      See Also:
      Default:
      "VARCHAR_TYPE"
    • length

      int length
      (Optional) The max length of the field value.
      Default:
      255
    • scale

      int scale
      (Optional) If a numeric, the max scale value.
      Default:
      0
    • precision

      int precision
      (Optional) If a numeric, the max precision value.
      Default:
      0