SQL return code

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 Received on Mon Apr 27 1998 - 16:51:35 CDT