Executing Oracle Stored Procedure via SQL Server 2000 Linked Serve

[marco]

All,

I am trying to execute a simple Oracle stored procedure from SQL Server
2000. The SP has no input or output parameters. I have created the linked
server correctly as I am able to execute Oracle functions just fine. I have
tried the following two methods to execute the SP, SKELETON:

{Call ORADB..MARCO.SKELETON()}

Execute ORADB..MARCO.SKELETON

Both methods result in the same error listed below:

Server: Msg 7212, Level 17, State 1, Line 1
Could not execute procedure 'SKELETON' on remote server 'ORADB'.
[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.]

Any ideas on how I can get this working properly?

Thanks,

Marco

[oj]

Here is an old post by Umachandar. See if it helps:
http://tinyurl.com/7dxrr

--
-oj

"marco" <ma...@discussions.microsoft.com> wrote in message
news:792C4015-008A-420A...@microsoft.com...

[marco]

Thanks for the link. I have a stored procedure in Oracle that was created a
long time ago by someone else. Without manipulating the stored proc at all,
I wanted to feed it the required input parameters via SQL Server and let it
do its magic. From what I gather, this is not possible? I must create the
proc within a package in Oracle?

[oj]

Yes. Creating a package wrapper is your ticket to get to oracle proc.

--
-oj

"marco" <ma...@discussions.microsoft.com> wrote in message

news:4653000F-F545-4044...@microsoft.com...