DB Outbound Protocol : Need help to format my Sql Insert req

Hi,

I want tu use ‘Database Outbound’ Protocol to save inbound ADT messages in our QDXLOG Table Schema in ‘chmdw’ Database.

I use a xlate to translate and send values from Inbound ADT HL7 msg thru Outbound QDXLOG Table Schema.

My Oracle Sql  request is functionnal if I push values directly inside my insert.

But when I tried to pass in Outbound parameters from QDXLOG table, I receive that error msg :

Running DB Write action failed.

Mar 28, 2014 1:37:50 PM com.lawson.cloverleaf.dbprotocol.CDBUtils execSQLStatementForDbWrite

SEVERE: ORA-01400: cannot insert NULL into (“DEVEAI”.”QDXLOG”.”QDXNOM”)

No documentation about that in Cloverleaf 6.0, so, I need help to format my Sql Insert request. If it is possible, to give to me an example of how to format

my Sql request (the exact syntax please).

For example, if I want to put inside of QDXLOG.QDXNOM field the value from the xlate field , how can I do it ?

In my inbound HL7 message, the value to send is ‘ADT’.

Thanks in advance.

My Sql Insert request in Database Outbound Protocol Properties is :

INSERT INTO QDXLOG

(QDXLOG.QDXLOGID, QDXLOG.QDXLOGDHRE, QDXLOG.ISEPURE, QDXLOG.QDXNOM, QDXLOG.PROVENANCE, QDXLOG.DESTINATION, QDXLOG.SITE,

QDXLOG.DOSSIER, QDXLOG.VISITE, QDXLOG.SERVICE, QDXLOG.CODEDETX, QDXLOG.CODEDETXHL7, QDXLOG.MESSAGE, QDXLOG.MESSAGEID)

VALUES (QDXLOGID.nextval, sysdate, ‘1’, , ‘1’, ‘1’,  ‘1’,  ‘1’,  ‘1’,  ‘1’, ‘1’,  ‘1’,  ‘1’, null)