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
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... |