在oracle中调用SqlServer函数
给位大哥大姐们,我通过oracle 10g的tg来连接的sqlserver 2005,现在要从oracle调用sqlserver里面的自定义函数,可是这样写不对:
SELECT dbo.fn_fly_readylineto(lineid) as linename FROM t_flyer_plan@okfoc
SELECT "dbo.fn_fly_readylineto(lineid)" as linename FROM t_flyer_plan@okfoc
SELECT 'dbo.fn_fly_readylineto(lineid)' as linename FROM t_flyer_plan@okfoc
实在没有办法了,哪位大哥大姐弄过的,给讲讲呗,O(∩_∩)O谢谢
oracle
sqlserver
------解决方案--------------------试试把语句写成:数据库名.dbo.函数名的形势去查询
------解决方案--------------------本人也遇到了这个问题,同问+帮顶!