Page 1 of 1

OracleScript not raising NO_DATA_FOUND

Posted: Wed 11 Jan 2012 13:51
by Huetti
I'm executing the following script (just for demo purposes) using the OracleScript class.

Code: Select all

declare
i number;
begin
    select 1 into i from dual where 0=1;
end;
Doing so should lead to a NO_DATA_FOUND exception (when executing with SQLDeveloper/Toad...) but not when calling Execute().
Is there an event which is fired in case of an NO_DATA_FOUND or am I missing something?

Kind regards
Huetti

Posted: Thu 12 Jan 2012 15:33
by Shalex