OracleScript not raising NO_DATA_FOUND

[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

[Shalex]

Please refer to http://www.devart.com/forums/viewtopic. ... c&start=15.