stored procedure return value still empty

[coface]

Hello,

The function is called with the syntax:

BEGIN :3 := STAGING.GET_PERIOD(:1, :2); END;

The function return a Varchar, the first ad second parameter are from type Input and the third (return_value) Function.

return_value is also set to output column, but the value is still empty.


Thanks

[ray.wurlod]

And your problem is... ?

How have you tested this stored procedure?