more than one return value from SPL?

It's easy to use the SPL as select name, call_number (state,phone) from .... if the SP 'call_number' is returning just **one** value. But how to do if there is more than one? Using DB-Access I've got: -686 Procedure procedure-name has returned more than one row. A procedure returned more than one row of values (for example, it executed RETURN... WITH RESUME) when the caller expected only one row of values. Any hints? -- Chris Drauch <cdr@xteam.co.at> ... just speaking for myself ...