Re: SQL return code

Hello Vijay,

How are you going to "do something else" without going into PL/SQL? If it's another query, i beleive there is a way to merge the two queries into one bigger. If it's DML you can also use subqueries.
If "something else" is DDL, then i think you should use dynamic sql, and this really is PL/SQL.

Regards,
Igor

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?
>
> Thanks.
>
> --
> Vijay Raghavacharian
> vragha_at_ctp.com
> voice: 650-372-6246
> fax: 650-372-6200
>
> Cambridge Technology Partners (415-574-3710)
> 1300 South El Camino Real, Suite 600
> San Mateo, CA 94402
> http://www.ctp.com

--
Igor Sereda,
ITC, Russia Received on Tue Apr 28 1998 - 10:39:28 CDT