At 19:30 2/10/2008, you wrote:

>Thanks it worked. But it is very slow.

Using a SELECT procedure is not a sensible way to do this. Rewrite the called procedure as an executable one and call it with EXECUTE PROCEDURE .... RETURNING_VALUES(:outvar1, :outvar2, ....)

.heLen