Thanks Charlie....

But still it is not working... is there any way i can continue processcing after an INSERT error

I am executing EXEC (@InsertString)




>To call a stored procedure and receive an output parm, I use the following syntax. It looks strange, but CALL syntax is faster.
>
>lnKey = 0
>= SQLEXEC(oCMIS.ConHandle, '{call spGetNextHiKey(?@lnKey)}')
>
>Charlie