Dear all,

I've got a DTS which launch a pl function and return a 'number' value into a
local variable (defined of course inside Sql Task) and I would need in the
case that have 1 (error) as value send an e-mail but I don't know how can I
do this.
Using a global variables doesn't work at all
Does anyone have ever used or experienced something like that?


DECLARE
RetVal NUMBER;

begin
RetVal := ACTUALIZAMARCAEMPLEADOS;
?:= RetVal; ********** WRONG, RETURN ME AN ERROR ************
end;




Thanks a lot,
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)