Page 1 of 1

stored procedure return value still empty

Posted: Wed Jun 22, 2011 12:23 am
by 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

Posted: Wed Jun 22, 2011 12:55 am
by ray.wurlod
And your problem is... ?

How have you tested this stored procedure?