SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

execute immediate - execution stop on "no data found"

673165Oct 12 2009 — edited Jul 12 2012

execute immediate v_sql
into v_georaster
using p_prin_id;

On a "no data found" exception, execution seems to stop. No error is thrown. If I wrap a begin/exception/end block around I can catch the error.

11gr1 patch7

Is this fixed in 11gr2?

This post has been answered by Boneist on Oct 13 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 9 2012

Added on Oct 12 2009

13 comments

10,902 views