Re: WHAT'S WRONG WITH THIS

hi,

[Quoted] I gave you a wrong code :

function est_expediteur ( CodUtil in varchar2)

return number is
res number;
 begin
select count(numexpvisu) into res from chargeurvisu where numexpvisu=CodUtil;
return res;
exception
when others then
return 0;
end;

I would like to kno if there 's another way to know if an element exists in a table . the function should return 0 if it doesn't exist and 1 if it does.

thanks

sandy

• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful