Re: ORA-01422 Error when on procedure execution
From: crappy <crappygolucky_at_hotmail.com>
Date: 29 Jun 2001 10:45:29 -0700
Message-ID: <ce31c410.0106290945.231789e9_at_posting.google.com>
Date: 29 Jun 2001 10:45:29 -0700
Message-ID: <ce31c410.0106290945.231789e9_at_posting.google.com>
the problem is that oracle doesn't assume that it's only going to return one row always. if you're sure that it will only return one row, you can use an aggregate function (for example, select max(company_name) .. ), which oracle *can* assume won't return more than 1 row.
while you're at it, you might want to consider what happens if *no* rows are returned. Received on Fri Jun 29 2001 - 19:45:29 CEST