DISPLAY_AND_SAVE Function

Use this function to display an item as text, but save its value to session state.

Syntax

HTMLDB_ITEM.DISPLAY_AND_SAVE(
    p_idx         IN    NUMBER,
    p_value       IN    VARCHAR2 DEFAULT NULL
    p_item_id     IN    VARCHAR2 DEFAULT NULL,
    p_item_label  IN    VARCHAR2 DEFAULT NULL)
    RETURN VARCHAR2;

Parameters

Table: DISPLAY_AND_SAVE Parameters describes the parameters available in the DISPLAY_AND_SAVE function.

DISPLAY_AND_SAVE Parameters

Parameter	Description
`p_idx`	Number that determines which `HTMLDB_APPLICATION` global variable will be used.Valid range of values is 1 to 50. For example, 1 creates `F01` and 2 creates `F02`
`p_value`	Current value
`p_item_id`	HTML attribute ID for the `<input>` tag
`p_item_label`	Label of the text field item

Example

The following example demonstrates how to use the HTMLDB_ITEM.DISPLAY_AND_SAVE function.

SELECT HTMLDB_ITEM.DISPLAY_AND_SAVE(10,empno) c FROM emp