OCI-51865
invalid LOB locator encountered or VECTOR data is null
Cause
OCIVectorToArray or OCIVectorToText returned this error as a result of invalid LOB locator or VECTOR data is NULL.
Action
To resolve the issue, perform any one of the following:
- Associate an indicator variable with all define variables to record the presence of the NULL value. This technique permits your program to take a specific action if a NULL value is returned.
- Use the NVL function to convert the retrieved NULL to another value, such as zero or blank. This is the simplest solution.
- Revise the query to eliminate inclusion of columns that
/ might contain a NULL value.