Need help on SP

Hello All,
I want to store count(*) of a table in a variable ,
for that I have declared a variable and wrote a
statment but it is giving me error.
can anybody please help me..

CREATE OR REPLACE FUNCTION foreign_keys_tables(OUT
par_result charecter varying, IN  par_tablename
character varying , IN par_clomnname,IN par_colvalue
integer) AS
$BODY$)
DECALRE
 countno integer;
BEGIN
Select count(*) into countno from par_tablename where
par_columnname=par_colvalue;

if countno>0 then
par_result='yes'
else
par_result='No'
end if

END;
 $BODY$
  LANGUAGE 'plpgsql' VOLATILE;


it is giving me error in select statment,
Thanks in advance

With Regards
Ashish Karalkar







____________________________________________________________________________________
Never miss an email again!
Yahoo! Toolbar alerts you the instant new Mail arrives.
http://tools.search.yahoo.com/toolbar/features/mail/