Re: PS/SQL Procedure
From: billiauk <billiauk_at_yahoo.co.uk>
Date: 25 Jan 2002 00:38:31 -0800
Message-ID: <dee17a9f.0201250038.36265e85_at_posting.google.com>
Date: 25 Jan 2002 00:38:31 -0800
Message-ID: <dee17a9f.0201250038.36265e85_at_posting.google.com>
Geoffrey
Where's the error? What is Oracle telling you? Where's your exception handler?
I'll bet you are either retrieving no rows (NO_DATA_FOUND) or more than one row (TOO_MANY_ROWS). These are exceptions to the SELECT .. INTO implicit cursor you are using - these MUST always return one row and one row only. Use an explicit cursor in this case, or have an exception with WHEN NO_DATA_FOUND THEN do_something...
Adrian Received on Fri Jan 25 2002 - 09:38:31 CET