Re: A Q about Pro*C
From: Stewart McKenna <ahipc1j.smcken01_at_eds.com>
Date: 1995/07/08
Message-ID: <3tm0ko$82c_at_maverick.tad.eds.com>#1/1
Date: 1995/07/08
Message-ID: <3tm0ko$82c_at_maverick.tad.eds.com>#1/1
Craig L Hollister <Craig.Hollister_at_DaytonOH.NCR.COM> wrote:
> Stewart McKenna, 7/7/95, wrote:
>
> A query of the form "EXEC SQL SELECT COUNT(*) INTO :i FROM t" (barring an
> error) will return exactly one row. There is no need to check the SQLCODE for
> a no data found condition.
Yes, as long as you stay with Oracle ! I was just suggesting that indicator variables be used because they are more portable. e.g. In a DB2 environment you would be returned -315. Anyone who programmed for this is asking for trouble ! Received on Sat Jul 08 1995 - 00:00:00 CEST