NO data Error

From: Jawahar Rajan <jrajan_at_nc.rr.com>
Date: Tue, 01 Feb 2005 03:11:54 GMT
Message-ID: <_rCLd.48213$dt3.4645628@twister.southeast.rr.com>

All,
I have experienced a strange feature on Oracle 9i I have a stored Proc

Procedure getScalarText(strSQL in varchar2, retval out Varchar2) Begin

EXECUTE IMMEDIATE strSQL INTO retval;

end getScalarText;

If the sql returns no rows an execption is raised saying that no data found. This is as expected as one cannot select a null into something (loke above). But on another instance of Oracle 9i (Test instance) the error is not seen and no execption is raised from the stored proc (if the sql executed returns no data) and the calling application carries on a normal.

Is there a configration for the Oracle database that can supress the no data found error, does this concern the ANSI mode?

Any help or suggestions are appreciated.

Jawahar Received on Mon Jan 31 2005 - 21:11:54 CST