Post reply

SQL Server views on Oracle

  • October 13, 2004 at 1:50 am

    #86686

    Hi,

    I have a following problem: I created views on Oracle tables using OPENQUERY but for some reason some of the text data get truncated. Do you have any idea what can be the problem?

     

    Thanks

     

    Tomas

     

  • October 13, 2004 at 5:50 am

    #526493

    I would review the views that were created in Oracle and ensure that the SQL data types match the Oracle.  It may be some data-type conversion truncation issue.



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply