>You never assign the cartID back to the OUTPUT parameter.

Thanks a million, I overlooked it. Now, what function can I use to scan through the table in SP?

Thanks a lot again.

Would this work
insert into CartDetail CartContentID, CredID from (select @CartContentID as CartContentID, value as CreditID from fn_split)