server: Running an Oracle Stored Procedure

When using a linked server for calling a remote Oracle stored procedure from
SQL Server 2000 I receive the error :
Server: Msg 7212, Level 17, State 1, Line 1
Could not execute procedure 'ABB_TEST_AMF' on remote server 'ORCLOMD'.
[OLE/DB provider returned message: One or more errors occurred during
processing of command.]
[OLE/DB provider returned message: Syntax error in {call...} ODBC Escape.]
I have tried the following commands:
exec ORCLOMD.OMD.APPS.ABB_TEST_AMF
exec ORCLOMD..APPS.ABB_TEST_AMF
The Microsoft KB Article (ID 873234) recognises this error but no resolution
is provided. Any ideas ?
Linked server using Micrsoft OLE DB provider for Oracle
Oracle client installed on sql server: Oracle 8.1
Oracle database: Oracle 7.3Hi Narimrajr,
There are some limitation when executing an Oracle procedure within a DTS
package.
If you want to execute an Oracle procedure you must use Oracle ODBC native
drivers and specify the connection, Data Source, to use Oracle Provider OLE
DB
and specify the DNS entry in the properties dialog.
Thanks,
Chandan
"narimrajr" wrote:
> When using a linked server for calling a remote Oracle stored procedure from
> SQL Server 2000 I receive the error :
> Server: Msg 7212, Level 17, State 1, Line 1
> Could not execute procedure 'ABB_TEST_AMF' on remote server 'ORCLOMD'.
> [OLE/DB provider returned message: One or more errors occurred during
> processing of command.]
> [OLE/DB provider returned message: Syntax error in {call...} ODBC Escape.]
> I have tried the following commands:
> exec ORCLOMD.OMD.APPS.ABB_TEST_AMF
> exec ORCLOMD..APPS.ABB_TEST_AMF
> The Microsoft KB Article (ID 873234) recognises this error but no resolution
> is provided. Any ideas ?
> Linked server using Micrsoft OLE DB provider for Oracle
> Oracle client installed on sql server: Oracle 8.1
> Oracle database: Oracle 7.3
>
>
>|||Also, try calling the Oracle procedure via OPENQUERY
Thanks,
Chandan
"narimrajr" wrote:
> When using a linked server for calling a remote Oracle stored procedure from
> SQL Server 2000 I receive the error :
> Server: Msg 7212, Level 17, State 1, Line 1
> Could not execute procedure 'ABB_TEST_AMF' on remote server 'ORCLOMD'.
> [OLE/DB provider returned message: One or more errors occurred during
> processing of command.]
> [OLE/DB provider returned message: Syntax error in {call...} ODBC Escape.]
> I have tried the following commands:
> exec ORCLOMD.OMD.APPS.ABB_TEST_AMF
> exec ORCLOMD..APPS.ABB_TEST_AMF
> The Microsoft KB Article (ID 873234) recognises this error but no resolution
> is provided. Any ideas ?
> Linked server using Micrsoft OLE DB provider for Oracle
> Oracle client installed on sql server: Oracle 8.1
> Oracle database: Oracle 7.3
>
>
>