On Thu, Jul 30, 2009 at 12:22:03PM +0100, Andre Lopes wrote:
> Hi. I need to know what is wrong with this function
>
> CREATE OR REPLACE FUNCTION "public"."apr_alta_empregado" ("pID_SOCIEDADE"
> varchar, "pID_EMPREGADO" varchar, "pNOME" varchar, "pNOME_ABREV" varchar,
[..]
> VALUES ( pID_SOCIEDADE,
You're mixing and matching quoting of identifiers, sometimes you use
"pID_SOCIEDADE" and other times just pID_SOCIEDADE (i.e. without the
quotes) and these are different identifiers. You need to pick one style
and stick with it.
--
Sam http://samason.me.uk/