OPEN cursor FOR SELECT... Question

From: Dan Cunningham <dcunning_at_wam.umd.edu>
Date: 1997/11/09
Message-ID: <34660E33.6AB961E0@wam.umd.edu>#1/1

Hello there,

        I have a question concerning testing a select that is used in opening a cursor.

	If I have the following:
		OPEN c_return FOR
			SELECT CompanyName, AccountNum
			FROM AccountsTable
			WHERE AccountNum = term;
	can I use the SQL%... attributes (specifically, ROWCOUNT and 	
NOTFOUND) and/or catch the exception NO_DATA_FOUND for the 	select

statement?

Thank you,
Daniel Cunningham
dcunning_at_umdstu.umd.edu Received on Sun Nov 09 1997 - 00:00:00 CST