[Brad Cook]

Thanks all – I really appreciate the insight and guidance. I actually have TCL training next week, so an Infor person who can hopefully give me some input will be onsite. Let me respond back to what I find out.

[Brad Cook]

It appears that stored procedures are not supported with advanced database lookup – has someone used a SP with this before?

Code:

MESSAGE 1
[0:TEST] Invalid sql statement: ‘{call PROVIDER.prPhyndAddExternalProviders[(?,?,?,?, OUT)]}’.
[0:TEST] Only SELECT statement is allowed in DBLookup

[Brad Cook]

Thanks Brent – I just found the help on advanced DB lookup – reviewing

[Brad Cook]

Thanks – let me pull back a little so I can get a basic understanding of some things.

If I have an inbound hl7 thread and an database-outbound thread using a stored procedure – how do I pass the parameters defined in the database-outbound protocol properties? Do I need to put the actual hl7 coordinates?

Here is what I have {call IMR.PROVIDER.prPhyndAddExternalProviders(inValue1, inValue2, inValue3, inValue4, outPara1 OUT)}

Do I need to

{call IMR.PROVIDER.prPhyndAddExternalProviders( 4(0).2(0).MFN(0).#20(0), 4(0).2(0).MFN(0).#20(0), 4(0).2(0).MFN(0).#20(0), outPara1 OUT)}

[Brad Cook]

Yup – that is what I was hoping for with the “OUT” parameter “outPara1 OUT)}”. The problem I have is that I am trying to get the value and route to another thread. Would this have to be done via an “OVER” or something?

Basically I am looking to make this SP call mid-flight between an inbound HL7 thread and outbound thread – getting the value to send on the outbound.

I am not sure if it is even possible using the database thread or if I need to use a tcl call within my Xlate. I have included a doc with a rough idea for the route. I was thinking I could use a tcl prc for the inbound tps reply to get the value and send along.

[Brad Cook]

Cloverleaf Version: 6.1.2

OS: AIX 7.1

JDBC: MSSQL Driver

[Author]

Replies