Re: ORA 1403 NO DATA with select statment

From: Roy Brokvam <roy.brokvam_at_conax.com>
Date: Wed, 24 Feb 1999 17:22:34 +0100
Message-ID: <7b198r$q75$1@readme.online.no>

Hi!

Alexey B. Vashchenko wrote in message <36D40D9D.4773C605_at_zenon.net>...

>
>Are you declare c1 as table%rowtype? ("table" is pseudonim - yes?)
>
>

Never ever declare index variables! They are implicitly declared in the FOR loop, and will override your own declaration. It's bad programming style, and may confuse debugging and code inspection.

See also Thomas Kyte's answer to this question in comp.databases.oracle.misc

HTH, Roy Brokvam
roy.brokvam_at_conax.com Received on Wed Feb 24 1999 - 10:22:34 CST