On Saturday 04 July 2009 10:47:34 am Juan Pablo Cook wrote:
> Hi friends, It's my first time I'm writing to the list. All days I enjoy
> the list!
> I declare a function, and when I want to call this, it fails.
>
> My function:
> CREATE OR REPLACE FUNCTION
> alta_docente(integer,varchar,varchar,varchar,bigint,varchar,integer)
> RETURNS VOID AS
> $body$
> declare
> codigo integer;
> begin
> INSERT INTO persona(cod,dni,nombre,apellido,domicilio,telefono) VALUES
> (DEFAULT,$1,$2,$3,$4,$5);
> codigo := currval('persona_cod_seq');
>
> INSERT INTO persona_docente(cod,legajo,antiguedad) VALUES
> (codigo,$6,$7);
> end;
> $body$
> LANGUAGE 'plpgsql';
>
> The call I'm doing:
> SELECT alta_docente(2323232,cast('Mariela' AS varchar),cast('Botti' AS
> varchar),cast('232 de Noviemb23' AS varchar),cast(2312312321AS
> bigint),cast('323232A' AS varchar),23)
>
> And here is the error:
>
> ERROR: function alta_docente(integer, character varying, character
> varying, character varying, bigint, character varying, integer) does not
> exist at character 8
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
> STATEMENT: SELECT alta_docente(2323232,cast('Mariela' AS
> varchar),cast('Botti' AS varchar),cast('232 de Noviemb23' AS
> varchar),cast(2312312321AS bigint),cast('323232A' AS varchar),23)
>
> I don't know what's the problem, because I did all the explicit cast I
> think to convert types. If someone can help me, It would be great!
>
> Thanks a lot
>
> JP Cook
>
> Sorry about my bad english!
Is this a schema path issue? Did you create function in one schema and call it