cursor size??

From: Alan Sze <alan_at_icon.com.hk>
Date: Mon, 6 Dec 1999 19:26:13 +0800
Message-ID: <82g5vg$na7$1@news.hk.linkage.net>

Hi, I would like to ask if there's any way to set the cursor size in PL/SQL packages?? I've got the following errors when executing a package. I doubt if it is because the size of the cursor variables are smaller than the fetched number of rows.

Thanks.

*
ERROR at line 1:

ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "CLIQ.CLIQ_FITANALYSIS", line 92
ORA-06512: at "CLIQ.CLIQ_FITANALYSIS", line 251
ORA-06512: at line 1

Alan

Received on Mon Dec 06 1999 - 05:26:13 CST