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