Re: SQL return code

From: rok <rok_at_MCI2000.com>
Date: Sat, 02 May 1998 05:56:50 GMT
Message-ID: <01bd758f$51bc25e0$d80b37a6@raghus-computer>

Jason,

     As count(*) has to do a table scan, how about following code:

DECLARE
v_data_found BOOLEAN := TRUE;
v_dummy INTEGER;

BEGIN

	SELECT 1 INTO v_dummy FROM DUAL
	WHERE EXISTS (SELECT 1 FROM TABLEA);
EXCEPTION
	WHEN NO_DATA_FOUND THEN
		v_data_found := FALSE;
	WHEN OTHERS THEN
		RAISE;

END; if v_data_found then

        do something;
end if

raghuvir

Jason Selby <jselby_at_cams.co.uk> wrote in article <3549DD75.6B3F8C22_at_cams.co.uk>...
> Vijay Raghavacharian wrote:
>
> > Guys !!
> > I need to do something like this:
> >
> > select * from <table1>;
> >
> > if (NO_DATA_FOUND)
> > {
> > do something else
> > };
> >
> > How do I check the return code of an SQL statement without going into
> > PL/SQL?
>
> I don't know what your calling ORACLE from but you could do something
> like
>
> SELECT count(*) FROM <table1> INTO :mycount
>
> if(mycount>0)
> {
> do something else
> };
>
> HTH
>
>
> Jason
>
>
>
Received on Sat May 02 1998 - 00:56:50 CDT