| |
- Causa
- INVALID VALUE FOR LOCATOR IN POSITION position-#.
The value specified in a result set locator host variable or a LOB locator host variable specified at position position-# in the
locator variable list of the SQL statement does not identify a valid result set locator or LOB locator variable, respectively.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- For a result set locator there are two common causes for the error:
- The host variable used as a result set locator was never assigned a valid result set locator value.
Result set locator values are returned by the DESCRIBE PROCEDURE and ASSOCIATE LOCATORS statements.
Make sure the value in your host variable is obtained from one of these statements.
- Result set locator values are only valid as long as the underlying SQL cursor is open.
If a commit or rollback operation closes an SQL cursor, the result set locator associated with the cursor is no longer valid.
For a LOB locator, some common causes for the error are:
- The host variable used as a LOB locator was never assigned a valid LOB value.A commit or rollback operation or an SQL FREE LOCATOR statement freed the locator.
SQLSTATE: 0F001
© Copyright IBM Corp.
|
| |
