Stored Proc error after modifying field type

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: Stored Proc error after modifying field type
Date: 2003-07-02 09:53:36
Message-ID: 00fc01c3407f$d4be4750$230a0a0a@compaq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I've a problem with some of my stored procs. My config is: RH7.1, Postgres
7.3.2

I have converted a few fields of a few tables from one type to another.
After this I made all the necessary changes on the functions and recreated
all my types and functions. (Actually I recreated the whole database later
from a dump.) It seemd to be all right, but some functions won't work
anymore. I call them from a windows client program (Delphi via BDE) and I
call all my stored procedures in the same way. Other functions work properly
but these ones.

The error message says, that there is no such a function and it recognises
the text type parameters as "unknown" and suggests to explicitly cast them.
-----------------------------------------------------------------------
ERROR: Function addincominginvoice(integer, integer, "unknown", "unknown",
"unknown", "unknown", integer, "unknown", "unknown", "unknown", "unknown",
double precision) does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
-----------------------------------------------------------------------
My functions header is:
create or replace function "addincominginvoice" (int, int, text, text, text,
text, int, text, text, text, text, decimal) returns integer as' ...

In Delphi's BDE StoredProcedure comonent I can't add any typecasts to the
parameters and with the remaining part of my procdures it's not even
necessary.

Should anybody suggest me something about this problem.

Thanks a lot,

-- Csaba

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 2003. 06. 18.

Browse pgsql-general by date

  From Date Subject
Next Message Robert 2003-07-02 10:14:34 Re: URGENT: How to change ON CASCADE RESTRICT to DELETE?
Previous Message btober 2003-07-02 09:08:56 Re: Text datatype as Memo in Delphi