Access to Sybase Stored Procedures from Oracle 9i

From: Manuel Delgado <mdelgado_at_mfs.com>
Date: 11 May 2004 06:01:41 -0700
Message-ID: <4ce194b0.0405110501.10618505@posting.google.com>

Hi all,

I'm trying to execute a simple Sybase 11.9.2.4 stored procedure using an Oracle DB link. I'm getting the following error:

ORA-06550: line 2, column 1:
PLS-00201: identifier 'TEST_DB_LINK_SP_at_MFTP_RPT_MFS' must be declared
ORA-06550: line 2, column 1:

PL/SQL: Statement ignored

This is the way that i call the SP:

begin
"dbo"."test_db_link_sp_at_mftp_rpt_mfs";
end;

I also tried
begin
dbo.test_db_link_sp_at_mftp_rpt_mfs;
end;

Can anyone tell me what is the way for doing this?

Thanks

Manuel Received on Tue May 11 2004 - 08:01:41 CDT