null select

hi

i am having some problems with my select into statement.

i'm trying to see if an item is in a table. but oracle complains when nothing returns from the query.

is there a way around this? i.e. how do i tell if something is in the table or not?

here's a bit of code:

select rpt_id
into myvar
from tableA
where ...blah..

thanks. Received on Wed Aug 27 1997 - 00:00:00 CDT