PL/SQL执行语句:
SELECT "dbo"."fn_fly_readylineto"@dblink(t."id") FROM table@dblink t;
tg的init*.ora配置:
HS_FDS_CONNECT_INFO="SERVER=server;DATABASE=database"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
HS_FDS_SUPPORT_STATISTICS=TRUE
HS_CALL_NAME="dbo.fn_fly_readycodeto;dbo.fn_fly_readylineto"
HS_FDS_PROC_IS_FUNC=TRUE
HS_FDS_RESULTSET_SUPPORT=FLASE
错误截图:
那个HS_CALL_NAME的配置是从这里模仿来的:
https://forums.oracle.com/forums/thread.jspa?messageID=9057304
哪位哥哥姐姐遇到过这类问题的,给说说呗。