Re: I want to use an argument on a function which has an user-defined datatype, and call the function in a trigger

From: A. Mehoela <a.mehoela_at_hoetmeel.com>
Date: Mon, 13 Apr 2015 19:01:22 +0200
Message-ID: <EDSWw.192381$nQ7.91909_at_fx42.am4>


ejosue.15_at_gmail.com wrote:

> fNacimiento ref FechaHistorica,

> --2-
> create or replace function Validar(objeto in FechaHistorica)

> 4- In this trigger I want to call the function, but I get an error wrong number or types of arguments on the call of the function. What should I do to correct this?
>
> --3-
> CREATE OR REPLACE TRIGGER exper.some_trigger
> before insert or update on exper.Persona for each row
> BEGIN
> if Validar(:New.fNacimiento) = 0

fNacimiento is a "ref FechaHistorica", Validar expects a "FechaHistorica". Received on Mon Apr 13 2015 - 19:01:22 CEST

Original text of this message