@StoredProcedureParameter

Use @StoredProcedureParameter within a NamedStoredProcedureQuery annotation.

Annotation Elements

Table 2-63 describes this annotation's elements.

Table 2-63 @StoredProcedureParameter Annotation Elements

Annotation Element Description Default

queryParameter

(Required) The query parameter name

  

direction

(Optional) The direction of the stored procedure parameter:

  • IN – Input parameter

  • IN_OUT – Input and output parameters

  • OUT – Output parameter

  • OUT_CURSOR – Output cursor

IN

jdbcType

(Optional) JDBC type code. This depends on the type returned from the procedure.

-1

jdbcTypeName

(Optional) JDBC type name. This may be required for ARRAY or STRUCT types.

  

name

(Optional) Stored procedure parameter name

  

optional

(Optional) Specify if the parameter is required, or optional and defaulted by the procedure.

false

type

(Optional) Type of Java class desired back from the procedure. This depends on the type returned from the procedure.

void.class

Examples

See "@NamedStoredProcedureQuery" for an example using the @StoredProcedureParameter annotation.

See Also

For more information: