Problem using c_cursor%FOUND

From: C Chang <cschang_at_maxinter.net>
Date: Tue, 24 Sep 2002 23:48:51 -0400
Message-ID: <3D913223.6812@maxinter.net>

Why I can not use the c_cursor%FOUND when c_cursor is open and BULK COLLECT into a table type variable? I have to use the c_cursor%ROWCOUNT to check the c_cursor conditon. ex

OPEN c_cursor;
FETCH c_cursor BULK COLLECT INTO t_variable;

IF c_cursor%ROWCOUNT > 0 THEN
...do something..
END IF; CLOSE c_cursor;

When I replaced the c_cursor%ROWCOUNT > 0 with c_cursor%FOUND, I never get into do something part. I have searched the documentation and found nothing about this restriction. Am I right?

C Chang Received on Tue Sep 24 2002 - 22:48:51 CDT