Running test script - passing null value as parameter

[maurocl]

Hi all,

I have a function. See it below:

create or replace function obtem_total_gasto(data1 in gasto.data%type, data2 in gasto.data%type) (see it below for more information).

When I call it using a PL/SQL block like

declare
a number;
dt1 varchar2(10);
dt2 varchar2(10);
begin
dt1 := null;
dt2 := '07/11/2011';
a:=obtem_total_gasto(dt1,dt2);
dbms_output.put_line('a='||a);
end;

I got the expected value "-3" (since the first value is null)

Then, I

 

[Marco Kalter]

Your message seems to be truncated.