Re: how can I use exists in my store procedure?

You can not use if in such a way.

begin
select 'Y' into v_char from dual where
exists(select dummy from cl1 from tb2 where clause); execption when no_data_found then
v_char:='N';
end;
if v_char='Y' then
dbms_output.put_line('Yes');
elsif v_char='N' then
dbms_output.put_line('Yes');
else
dbms_output.put_line('Failed');
end;

luio <lctNOlcSPAM_at_hotmail.com.invalid> wrote in message news:1b0e181f.16d4e25e_at_usw-ex0104-026.remarq.com...
> if exists (select cl1 from tb2 where clause)
>
> it is valid in my store procedure.
> how can I do this in my oracle stored procedure?
>
>
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Mon Aug 07 2000 - 00:00:00 CDT