rs_script_call_parameters
The following table lists the columns for the rs_script_call_parameters view. The equivalent jcs_script_call_parameters view is available for backward compatibility reasons. The difference between the two is the data type of the date/time columns; the rs_* views use TIMESTAMP WITH TIME ZONE while the jcs_* views use DATE.
| Column | Datatype | Description |
| OWNER | VARCHAR2 | The owner of the script |
| SCRIPT_NAME | VARCHAR2 | The name of the script |
| SCRIPT_ID | NUMBER | The id of the script |
| STEP_NAME | VARCHAR2 | The name of the step this call parameter belongs to |
| STEP_ID | NUMBER | The id (sequence number) of the step this call parameter belongs to |
| CALL_ID | NUMBER | The id (sequence number) of the call this parameter belongs to |
| PARAMETER_ID | VARCHAR2 | OBSOLETE |
| PARAMETER_NAME | VARCHAR2 | The name of the called parameter |
| R_SCRIPT_ID | NUMBER | The id of the called script |
| R_PARAMETER_ID | NUMBER | The id of the called parameter |
| TYPE | VARCHAR2 | The type of definition for this parameter |
| EXPRESSION | VARCHAR2 | The actual expression when the type is EXPRESSION |
| CHAINED_STEP_ID | NUMBER | The referred stepid when the type is CHAINVAL |
| CHAINED_STEP_NAME | VARCHAR2 | The referred name of the step when the type is CHAINVAL |
| CHAINED_CALL_ID | NUMBER | The referred call (sequence number) when the type is CHAINVAL |
| CHAINED_SCRIPT_ID | NUMBER | The referred script id when the type is CHAINVAL |
| CHAINED_PARAMETER_ID | NUMBER | The referred parameter id when the type is CHAINVAL |
| CHAINED_PARAMETER_NAME | VARCHAR2 | The referred parameter name when the type is CHAINVAL |
| CHAIN_PARAMETER_ID | NUMBER | The referred parameter for chain parameter references (by id) |
| GROUPNAME | VARCHAR2 | The GUI name of the parameter group |
| VISUAL_ATTRIBUTES | VARCHAR2 | Attributes that can be used by the GUI to store representational data |
note
PARAMETER_ID: In version 7 this column was already deprecated and always empty. It still is.
note
EXPRESSION: Expressions are now in REL instead of PL/SQL
note
VISUAL_ATTRIBUTES: Version 9 does not have visual attributes anymore, therefore this column is always empty
plsqlTopic
onsiteTopic