在Oracle10g访问 sql2005时,在PL中输入 一下一段代码:
select rownum,
to_char(to_date('20100101','yyyyMMdd') + rownum- 1,
'yyyyMMdd') as "fdate",
"Code",
"Name",
from (select A."Code", B."Name"
from (select max("Year") as "Year",
"Code"
from A@DBLINK
where "Code" = '1'
group by "Code") A left join
B@DBLINKB
on A."Year" = B."Year" and A."Code" = B."Code")
connect by rownum <= to_date('20100907', 'yyyyMMdd') -
to_date('20100101', 'yyyyMMdd') + 1----------------------------------------------------------------------------------
报 ORA 03113:通讯通道的文件结束。
然后又报 ORA 03114 未连接到 Oracle。 请高手解决。
select rownum,
to_char(to_date('20100101','yyyyMMdd') + rownum- 1,
'yyyyMMdd') as "fdate",
"Code",
"Name",
from (select A."Code", B."Name"
from (select max("Year") as "Year",
"Code"
from A@DBLINK
where "Code" = '1'
group by "Code") A left join
B@DBLINKB
on A."Year" = B."Year" and A."Code" = B."Code")
connect by rownum <= to_date('20100907', 'yyyyMMdd') -
to_date('20100101', 'yyyyMMdd') + 1----------------------------------------------------------------------------------
报 ORA 03113:通讯通道的文件结束。
然后又报 ORA 03114 未连接到 Oracle。 请高手解决。
检测防火墙以及杀毒软件开启