Problema con funcion

From: "Mario Soto Cordones" <masc68(at)gmail(dot)com>
To: "'Lista - PostgreSQL'" <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Problema con funcion
Date: 2010-08-10 20:22:13
Message-ID: 003901cb38c9$b9abb110$2d031330$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Hola Lista, tengo la siguiente función:

CREATE OR REPLACE FUNCTION "public"."insodontologos" (

char,

integer,

integer,

integer,

char,

varchar,

varchar,

varchar,

varchar,

varchar,

varchar,

date,

varchar,

char,

smallint,

smallint,

smallint,

varchar,

date,

date,

smallint,

text,

numeric

)

RETURNS "pg_catalog"."void" AS $body$

INSERT INTO

"public"."eDental_odontologo"

(

id_estado,

co_empresa,

co_filial,

rut_odontologo,

dv_odontologo,

nom_odontologo,

ape_odontologo,

num_colegio,

fono_cel,

id_usuario,

email_odontologo,

prox_atencion,

fono_casa,

sexo_odontologo,

co_region,

co_provincia,

co_comuna,

dir_odontologo,

fe_ingreso,

fe_baja,

tipo_odontologo,

tx_observaciones,

por_prestaciones

)

VALUES (

$1,$2,$3, $4, $5,$6, $7, $8, $9, $10, $11, $12, $13, $14, $15,
$16, $17, $18, $19,$20,$21,$22,$23);

$body$

LANGUAGE 'sql'

VOLATILE

RETURNS NULL ON NULL INPUT

SECURITY INVOKER

COST 100;

Y cuando trato de insertar usando esta:

select * from
insodontologos('SA',1,1,22254799,'7','NOMBRE’,'APELLIDO','0','0','ADMIN','MA
IL(at)MAIL(dot)CL','2000-01-01','0', 'M', 13, 1,
4,'DIRECCION','10/08/2010','1900-01-01','0','');

Sale el siguiente error:

ERROR: function insodontologos(unknown, integer, integer, integer, unknown,
unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown,
unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown,
unknown) does not exist

Tengo Postgresql 8.3.7 sobre linux CentOS 5

Alguien encuentra algo que yo no veo del porqué sale el error.

Desde ya muchas gracias

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Fernando Siguenza 2010-08-10 20:26:12 Retornar setof record o cursor
Previous Message kervin licett 2010-08-10 20:13:39 Ayuda...