Re: SQL return code

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 Fri May 01 1998 - 00:00:00 CDT