Insert record with binary foreign key

[Levon Barker]

This is a follow on from this ticket which was resolved.

If I wanted to insert a record into CLInbound call which references the CLCallReason.id how would I format that insert?

INSERT INTO cfsc111.dbo.CLInboundCall
(…,reasonId, …)
VALUES(…, convert(binary(32), ‘1C5AC69E4782494ABAE9FD43827126C9’), …)

doesn’t work. I get

SQL Error [8152] [22001]: String or binary data would be truncated.

For greater context, I am trying to insert a CLInbound call record (the table is empty currently) to use as a transferCallId reference when making a SOAP call to notify the application server of an incoming call.

…
<soap:updateCallState>
<soap:userLoginName>nexjsa</soap:userLoginName>
<soap:status>CONNECTED</soap:status>
<soap:phoneNumber>4165089257</soap:phoneNumber>
<soap:reasonId>101C5AC69E4782494ABAE9FD43827126C9</soap:reasonId>
<soap:transferCallId></soap:transferCallId>
</soap:updateCallState>
…

0

[Author]

Posts