We have installed 9i client and 9i ole db provider and are trying to execute a procedure with input/output variables over a linked service in SQL Server database. We keep getting an error about undefined column. Has anyone done this before and do you have syntax.
-SQL Server 2000
-Oracle 9i
-OLE DB
-Using SQL Server Query Analyzer
-We can successfully return data using openquery and passing just a SQL statement
-We can successfully execute functions
-Stored procedure gets error "undefined columns"
