| Subject | check if a select return value |
|---|---|
| Author | Ronaldo Rezende Vilela Luiz |
| Post date | 2003-09-10T11:41:52Z |
Hi, I have this select in my stored procedure
select ID_CURSO, ID_PARCEIRO from MATRICULA
where ID_CONTRATO = :ID_CONTRATO
into :CURSO_ANTERIOR, :ID_PARCEIRO
How can I check if the select has been returned a value?
the variables CURSO_ANTERIOR and ID_PARCEIRO are integers and doesn't
have any assignment of values before this select.
If my select doesn't return any value, what will be assigned to my
variables?
select ID_CURSO, ID_PARCEIRO from MATRICULA
where ID_CONTRATO = :ID_CONTRATO
into :CURSO_ANTERIOR, :ID_PARCEIRO
How can I check if the select has been returned a value?
the variables CURSO_ANTERIOR and ID_PARCEIRO are integers and doesn't
have any assignment of values before this select.
If my select doesn't return any value, what will be assigned to my
variables?