In article <00d201c544b5$0b7455b0$3802a8c0@martijnws>, Martijn Tonies wrote:

> > select Result_ID
> > from P_SAVE_DATA_LIST_ITEM (1,'test',1);
>
> Please - NEVER do this on a procedure that INSERTs or
> UPDATEs or executes other procedures.
>
> ONLY use this for procedures that actually return/create a
> resultset.

How about SP's that do both?

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly