The NEXT_ITEM_TYPE function returns an integer code identifying the data type of the next data item in a message that was retrieved into the session’s local message buffer. As each item is moved off of the local message buffer with the UNPACK_MESSAGE procedure, the NEXT_ITEM_TYPE function returns the data type code for the next available item. A code of 0 is returned when no more items are left in the message.
Parameters
typecode
Code identifying the data type of the next data item is shown in the following table.
Type code
Data type
0
No more data items
9
NUMBER
11
VARCHAR2
13
DATE
23
RAW
!!! Note
The type codes listed in the table aren't compatible with Oracle databases. Oracle assigns a different numbering sequence to the data types.
Examples
This example shows a pipe packed with a NUMBER item, a VARCHAR2 item, a DATE item, and a RAW item. A second anonymous block then uses the NEXT_ITEM_TYPE function to display the type code of each item.