Re: NO_DATA_FOUND exception

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Sat, 13 Sep 2003 20:12:27 +0200
Message-ID: <ren6mv0hs7ullvkh652ff8us2lpusva1f3@4ax.com>

On Sun, 14 Sep 2003 01:23:18 +1000, "David" <auto90059_at_hushmail.com> wrote:

>t appears that you should avoid giving your
>parameters the same name as the columns you address in a select statement, I
>didn't realise this was going to be a problem.

This is a scoping issue. Generally speaking your parameter names should NEVER be identical to any column name. You might simply prefix them with p_ as a convention.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Sep 13 2003 - 13:12:27 CDT