| |
- Causa
- object-type object-name ATTEMPTED TO READ DATA WHEN THE DEFINITION OF THE FUNCTION OR PROCEDURE DID NOT SPECIFY THIS ACTION
The current environment does not allow SQL statements that read data. One of the following situations had occurred:
- A user-defined function or stored procedure object-name was invoked and attempted to read data, but the function or procedure was
defined without the READS SQL DATA or MODIFIES SQL DATA option.
- A function or procedure defined with CONTAINS SQL or NO SQL has attempted to invoke another function or procedure defined with READS SQL DATA.
In an environment of nested functions and procedures, the SQL option in effect is the most restrictive one that has been specified in the nested
hierarchy of functions and procedures.
The SQL data access option in effect does not allow for reading data.
- Ação do sistema
- The SQL statement failed.
- Resposta ao Desenvolvedor
- Either use an ALTER statement to change the definition of the function or procedure to allow statements that read data, or remove the failing SQL
statement from the external function or procedure.
SQLSTATE: 38004
© Copyright IBM Corp.
|
| |
