Dot lookup does not work in the IF after a FOR X IN (..) LOOP statements.
Example:
DECLARE
N NUMBER;
BEGIN
FOR X IN (SELECT * FROM USER.TABLE)
LOOP
IF X.
END LOOP;
END;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center