| Este es el mensaje de error y el store procedure:
SQL error:
ERROR: no existe el lenguaje «plpgsql»
HINT: Necesita usar «createlang» para instalar el lenguaje en la base de datos.
In statement:
CREATE FUNCTION "SP_TRANSACCIONES_VARIAS" (varchar, varchar, varchar, varchar, varchar, varchar, varchar, text, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar) RETURNS int4 AS '
DECLARE
yCod_Empresa ALIAS FOR $1;
yNro_Transa ALIAS FOR $2;
yCod_AlmaOri ALIAS FOR $3;
yCod_AlmaDes ALIAS FOR $4;
yCod_Entid ALIAS FOR $5;
yCod_fpago ALIAS FOR $6;
yTip_Transa ALIAS FOR $7;
yFec_Transa ALIAS FOR $8;
yCod_Secci ALIAS FOR $9;
yCod_Concep ALIAS FOR $10;
yCod_Moneda ALIAS FOR $11;
yCod_Docum1 ALIAS FOR $12;
yNro_Docum1 ALIAS FOR $13;
yCod_Docum2 ALIAS FOR $14;
yNro_Docum2 ALIAS FOR $15;
yCod_Docum3 ALIAS FOR $16;
yNro_Docum3 ALIAS FOR $17;
yDes_Observ ALIAS FOR $18;
yTip_Estad ALIAS FOR $19;
yLog_UltMod ALIAS FOR $20;
yFlg_Tx ALIAS FOR $21;
ycArtic ALIAS FOR $22;
ycCalid ALIAS FOR $23;
ycTotal ALIAS FOR $24;
ycMed00 ALIAS FOR $25;
ycMed01 ALIAS FOR $26;
ycMed02 ALIAS FOR $27;
ycMed03 ALIAS FOR $28;
ycMed04 ALIAS FOR $29;
ycMed05 ALIAS FOR $30;
ycMed06 ALIAS FOR $31;
ycMed07 ALIAS FOR $32;
ycMed08 ALIAS FOR $33;
ycMed09 ALIAS FOR $34;
ycMed10 ALIAS FOR $35;
ycMed11 ALIAS FOR $36;
BEGIN
yFec_Transa:=TO_DATE(yFec_Transa,\\''DD/MM/YYYY\\'');
INSERT INTO TTRANSAC(cod_empresa, nro_transa, cod_almaori,
cod_almades, cod_entid, cod_fpago,
tip_transa, fec_transa, cod_secci,
cod_concep, cod_moneda, cod_docum1,
nro_docum1, cod_docum2, nro_docum2,
cod_docum3, nro_docum3, des_observ,
tip_estad, log_ultmod, flg_tx)
VALUES (ycod_empresa, ynro_transa, ycod_almaori,
ycod_almades, ycod_entid, ycod_fpago,
ytip_transa, yfec_transa, ycod_secci,
ycod_concep, ycod_moneda, ycod_docum1,
ynro_docum1, ycod_docum2, ynro_docum2,
ycod_docum3, ynro_docum3, ydes_observ,
ytip_estad, ylog_ultmod, yflg_tx)
END;' LANGUAGE 'plpgsql'; |