Input Settings

Enter the SQL statement to call the procedure. The procedure can have no output parameters, simple output parameters, or one or more cursors as output parameters. The call procedure query can be constructed using substitution variables (or substitution parameters) of the form ?<fieldname>.
Example:

CALL 
queryDBUSER(?E_ID,?EMP_NAME,?HIRE_DATE);

Each substitution variable identifies a parameter whose mapped value is substituted in the variable at runtime. You can provide a value in the parameters that have Direction mapped as IN in the input. If a parameter has Direction set to OUT, it is mapped in the output. If the Direction is set to INOUT, the parameter is mapped in both input and output.

Simple output parameter example:

CALL
queryDBUSER(?E_ID,?EMP_NAME,?HIRE_DATE);

Here, E_ID is the input parameter, EMP_NAME (varchar), and HIRE_DATE (timestamp) are output parameters. The mapped value for the E_ID field is substituted in the ?E_ID substitution variables at runtime. The output parameters are EMP_NAME and HIRE_DATE.

Cursor output parameter example:

CALL 
singleCursor(?E_ID,?EMP_NAME,?H_Date,?p_recordset1);

Here, E_ID is the input parameter, EMP_NAME (varchar), HIRE_DATE (timestamp), and p_recordset1 (REFCURSOR) are output parameters. The mapped value for the E_ID field is substituted in the ?E_ID substitution variables at runtime. Simple output parameters are mapped directly in the output. For cursor output parameters, the result is returned as a string value.