> > > 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?

Well, those are special cases then :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com