[RESOLVED] Stored Procedure return values problem

[Chubby]

*Edit*

Hi Chaps.

This is breaking my head, wonder if any of you nice people could help me out?

I have a stored procedure that calls another stored procedure to return a string

The syntax from SQL books to return the value is to use an output parameter and this works in Query Analyzer:

 
EXEC spGetCalleeRecIDSQL 2,@CampaignName,@REC = @RECID

The problem is in the procedure when I check @RECID its is blank when it comes back ?

I have traced thru the inner procedure and it works fine but the code in the outer procedure does'nt get past the EXEC line.

Help please ???? humbly grateful... please ???... call me a muppet if you need to, just need to fix this...

Cheers

Chubby..