Problems with using the Oracle Max function
- 2020-12-22 17:49:27
- OfStack
The following sql statement is used when writing another stored procedure
Supposedly, the result of the query based on this condition should be sqlcode=1403, but strangely, the following sql exception is not caught:
No error is returned during the execution. When checking the value of V_RE_DATE through the execution, it is found that the value is null, so if the value is null, it should also report an exception of sqlcode=1405. But the oracle execution engine did not report any error.
SELECT MAX(RE_DATE) INTO V_RE_DATE
FROM T_RECORDING
WHERE ID ='100010010102'
Supposedly, the result of the query based on this condition should be sqlcode=1403, but strangely, the following sql exception is not caught:
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
ERR_CODE :=-2000;
ERR_MSG :=SQLERRM;
RETURN ;
No error is returned during the execution. When checking the value of V_RE_DATE through the execution, it is found that the value is null, so if the value is null, it should also report an exception of sqlcode=1405. But the oracle execution engine did not report any error.