Browse Cerna MILLENNIUM Oracle Database in SQL

[Kerry Potts]

Good Afternoon

I have setup an Oracle Connection and Linked Server to a MILLENNIUM Oracle database on a SQL Server. 

I am trying to complete a Select statement on any of the tables but keep receiving a generic data type invalid for a UTC field each time.

I am able to query the Views without error.

I have tried wrapping my select statement in the OpenQuery syntax but this is still not working. 

Can you please assist to how to query the MILLENNIUM db from a SQL instance?

Kerry

[Fenil Desani (Oracle Cerner)]

Hello Kerry,

This group focuses on Cerner's SMART on FHIR API only.

Thanks,

Fenil