Re: executing Sybase procedure from Oracle

From: daniele stefanucci <d.stefanucci_at_edisontel.it>
Date: Thu, 2 Aug 2001 10:36:45 +0200
Message-ID: <jk8a7.2496$Wg4.5773995@news.edisontel.com>

OK...this error????
BEGIN "somma_credito"@smas_ccs.prod('PPA','99999','10000'); END;

*
ERRORE alla riga 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Transparent gateway for SYBASE]Stored procedure 'somma_credito' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode. ORA-06512: at line 1

"Billy Verreynne" <vslabs_at_onwe.co.za> ha scritto nel messaggio news:9kat0e$8ti$1_at_ctb-nnrp1.saix.net...
> "Daniel A. Morgan" <Daniel.Morgan_at_attws.com
>
> > > Can i execute a Sybase procedure from sqlplus ??
> > >
> > > SQL> exec my_proc_at_dblink_sybase ('a','b');
> >
> > AFAIK only if you purchase the Oracle transparent gateway to Sybase.
> >
>
> Or if you write an Extended Stored Procedure (external DLL on Oracle NT)
that
> provides access to Sybase stored procs via ODBC or DBlib.
>
> --
> Billy
>
>
>
Received on Thu Aug 02 2001 - 03:36:45 CDT