Re: Calling stored procedures.

John Trambakoulos wrote:

>
> Error Number: -2147467259
> Error Description: Error while executing the query;
> ERROR:  fmgr_info: function 19264: cache lookup failed
>
> I did some research and found that this error message occurs when a stored
> procedure refers to another function that has been dropped from the database
> and that to avoid this error you must drop all objects referring to this
> stored procedure and recreate them.  The problem is that I get this error
> message for NEWLY created procedures?  Any ideas about this?  I don't know
> what this OID 19264 is referring to.


I believe this is because you have an undeclared variable ret. Try to
declare it like below.

create function validate_user(varchar, varchar)
RETURNS integer AS '
DECLARE ret INTEGER;
BEGIN
   SELECT count(*) INTO ret
   FROM  users
   WHERE userid = $1 and passwd = $2;
   RETURN ret;
END;
'
LANGUAGE 'plpgsql';

Jochem