Converts a FOID as a number to a FOID as a display string.
If the input number is NULL, then the string 'NULL' is returned. If the agency cannot be found in the database, then 'Not Found' is returned.
Input
Parameter | Type | Description |
|---|---|---|
v_foid | INTEGER | The feature object identifier (FOID) as a number. |
Output
Type | Description |
|---|---|
VARCHAR2 | The feature object identifier (FOID) as a display string. |
Example
select foidnumbertostring(2025493936704848112) from dual;
FOIDNUMBERTOSTRING(2025493936704848112) ---------------------------------------------------- 1C 0000000240 00001 |
Exceptions
N/A