OracleScript not raising NO_DATA_FOUND

OracleScript not raising NO_DATA_FOUND

Postby Huetti » Wed 11 Jan 2012 13:51

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
Huetti
 
Posts: 1
Joined: Wed 11 Jan 2012 13:33

Postby Shalex » Thu 12 Jan 2012 15:33

Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle