This discussion is archived
11 Replies Latest reply: Oct 5, 2012 12:39 AM by xarg-Xrc RSS

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

xarg-Xrc Explorer
Currently Being Moderated
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)\

Thanks.

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points