Re: URGENT: Problem with cursor

Originally posted by Joan Sanchez

> When I execute the following code, the cursor doesn't retreive

> any row, but If I execute the select in svrmgrl a row is retrevied

> to me.

>

> Does anyone know the reason?

> [snip]

> open cLOCK(lILCK,lETID);

> if cLOCK%FOUND then

> fetch cLOCK into sITEM_LOCK, lCDAD_LOCK;

>

%FOUND checks the result of FETCH. not of OPEN. So your code should say:

            open cLOCK(lILCK,lETID);

            fetch cLOCK into sITEM_LOCK, lCDAD_LOCK;

            if cLOCK%FOUND then ...

--
Posted via http://dbforums.com