Hi,
I have two problems:
1) I need executing stored procedure on Oracle 11g via linked server from MSSQL Express 2012, I use ODBC.
I try:
execute ('exec TEST_SCH.MY_PROC;') at ORA_1;
Send error:
OLE DB provider "MSDASQL" for linked server "ORA_1" returned message "[Oracle][ODBC]Syntax error or access violation.".
Msg 7215, Level 17, State 1, Line 3
Could not execute statement on remote server 'ORA_1'.
2) Can I write select on MSSQL without OPENQUERY?
this works: SELECT * FROM OPENQUERY(ORA_1, 'SELECT atrb FROM TEST_SCH.my_table;')
but, I need the same as the table is on MSSQL - SELECT atrb FROM ORA_1..TEST_SCH.my_table;
When I call that, I receive:
Msg 7318, Level 16, State 1, Line 15
The OLE DB provider "MSDASQL" for linked server "ORA_1" returned an invalid column definition for table ""
TEST_SCH"."
MY_TABLE"".
Thanks