0
I have the following cursor:
-- CÓDIGO OMITIDO
DECLARE
CURSOR CUR_AULAS(IDTURMA NUMBER) IS
SELECT ID, IDCLIENTE
FROM AULAS
WHERE
ATIVO = 1
AND IDTURMA = IDTURMA;
It will always return true because it thinks I am filtering the column itself (IDTURMA) and not by the parameter, if I change the parameter name works correctly but it is possible to use the same name type a this
java?
why not use
P_IDTURMA
in the parameter name for better reading of the code?– andrepaulo
I know I can use it, but my question is whether it is possible to have the same name.
– Laerte
It is not a good practice the ideal is always identify the object , use a prefix "P_" for help parameters is much reading code.
– Motta