Pipelined functions from mssql using DG4MSQL
kenanNov 11 2009 — edited Dec 7 2009Hi to All
I have made installation of DG4MSQL 11.1 to connect Oracle db 10.2.0.4 to MSSQL server and found this problem.
On my MSSQL side there are piplined database objects , functions that behave like tables and which from mssql side is queried by forexample select * from table(parameter);
I tried to query objects on oracle db side using the same syntax like this:
select * from "table(parameter)"@sqlserverlink;
and this
select * from "table"@sqlserverlink (parameter);
and it gave error:
ORA-00933: SQL command not properly ended
.
Also tried standard oracle syntax for selecting from pipleined function like this :
select * from TABLE("table"@sqlserverlink(NULL));
or
select * from TABLE("table"(NULL)@sqlserverlink);
and it gives error
ORA-00933: SQL command not properly ended
.Can enynone give me some answer for this. Are piplined functions supported through DG4MSQL when connecting from oracle to mssql.
Greetings
Kenan