Re: Procedure help for a newbie
From: Adrian Billington <billiauk_at_yahoo.co.uk>
Date: 12 Mar 2002 00:15:51 -0800
Message-ID: <dee17a9f.0203120015.38e09d25_at_posting.google.com>
Date: 12 Mar 2002 00:15:51 -0800
Message-ID: <dee17a9f.0203120015.38e09d25_at_posting.google.com>
You are raising the TOO_MANY_ROWS exception with your implicit SELECT..INTO cursor. If you are to fetch more than one row, you need to use a ref cursor or a LOOP to fetch row-by-row. Seeing as you are fetching something to pass out to the caller, you probably need a ref cursor or an array. Received on Tue Mar 12 2002 - 09:15:51 CET