Skip to Main Content
  • Questions

  • Database link between Oracle and SQL Server

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Abida.

Asked: August 04, 2021 - 1:46 pm UTC

Last updated: August 06, 2021 - 2:14 am UTC

Version: SQL Server 2017 and Oracle 12c

Viewed 1000+ times

You Asked

I have Database link in Oracle 12c which can query data from SQL Server 2017. I can't select time type field of SQL server from my database link. My question is how to select time type field of SQL Server in Oracle? I tried different options to convert and then select but no luck.

and Connor said...

If you are using the full Database Gateway option, then I'd log an SR with Oracle Support because we generally try to support all the remote data types.

But if you are just using the heterogenous services layer, then perhaps take a look at using passthrough

https://connor-mcdonald.com/2012/07/18/dbms_hs_passthroughthe-magic-package/




Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database