EXEC [dbo].[sql_store_proc_name] @MSSQL08 in oracle gives error PLS-00201: identifier '[dbo].[sql_store_proc_name] @MSSQL08' must be declared
Asked
Active
Viewed 35 times
0
-
How does this relate to SQL Server and Oracle DB? The two are different products with incompatible SQL dialects. – Dai Dec 06 '16 at 11:12
-
I have a store procedure in SQL. and i need to call it using Oracle db to get result in oracle view. – Shum Dec 06 '16 at 11:15
-
but i cant configure it using http://www.easysoft.com/applications/oracle/database-gateway-dg4odbc.html like this – Shum Dec 06 '16 at 11:17
-
i used this method too, http://stackoverflow.com/a/14584791 – Shum Dec 06 '16 at 11:21