create Procedure spICB_CustomerIntegration as
Begin
Set nocount on
--exec spICB_CustomerIntegration
--select * from rm00101 where custnmbr='DJDJDJD'
declare @O_iErrorState int, @oErrString varchar(255), @errordesc nvarchar(100)
select @O_iErrorState = 0
if (@O_iErrorState = 0)
begin
exec taupdatecreatecustomerrcd
@I_vCustnmbr='DJDJDJD',
@I_vCustname='Devin Johnson3',
@I_vADRSCODE='PRIMARY',
@O_iErrorState = @O_ierrorstate output,
@oErrString = @oErrString output
end
IF @O_iErrorState <> 0
Begin
Set @errorDesc = (select errordesc from dynamics.dbo.taerrorcode where errorcode = @O_iErrorState)
select @oErrString
select @errorDesc
End
end