11 Replies Latest reply on Oct 5, 2012 7:39 AM by xarg-Xrc

    Views created from Database link over dg4msql has column type as long

      Hi All,

      I am reading some views from SQL server using dg4msql to Oracle database 11G r2.

      All working well except columns that are typically varchar2 are now of type LONG. This is causing issues given the wide range of restrictions of data type long.

      Is there a way that when I create a view in Oracle like:
      CREATE or replace view as v1 (
      select a1, a2, a3 from msqlserver_table@dblink)
      The columns don't come up as long but as varchar2??

      Problem is once its in long format, I can't change it to another format in a SELECT statement (like cast it as varchar 2 etc)\


      Edited by: xarg-Xrc on Oct 3, 2012 7:26 PM