I'm trying to use the Oracle pipelined table() function in the microsoft query wizard but I'm getting the error, "Could not add the table..."
My query looks like this inside the Sql Statement prompt in the Microsoft query wizard:
Select * from table(MyData.SomeTable_Test('03/28/2013'));
Does the Oracle table function work in microsoft query wizard? Some other Oracle functions like to_date works.