Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Porting Sybase to Oracle (Procs & Triggers)

Re: Porting Sybase to Oracle (Procs & Triggers)

From: Peter Sylvester <peters_at_mitre.org>
Date: Thu, 01 Mar 2001 07:52:24 -0500
Message-ID: <3A9E4608.5DDCDD3A@mitre.org>

Take a look at PL/SQL functions:
 SQLCODE
 SQLERRM And CURSOR Attributes:
 SQL%ROWCOUNT And PL/SQL package:
 DBMS_TRANSACTION
 (may also have to write something here to look at v$session, v$transaction, etc)

-Peter

Randall DuCharme wrote:
>
> Greetings,
>
> I'm trying to get a database ported to Oracle 8.1.5 and seem to be
> having a bit of difficulty finding equivalients for Sybase constructs
> used in triggers and stored procedures.
>
> My main boggle seems to be with the Sybase variables:
> @@ERROR
> @@ROWCOUNT
> @@TRANSTATE
>
> Any tips/hints someone can share in porting these things to Oracle would
> be greatly appreciated.
>
> Thanks much!
>
> --
> Randall D DuCharme (KD5IZI) Proud to be 100% Microsoft Free!
>
> Unsolicited commercial email (SPAM) received at this email address
> will not be tolerated. All spam is subject to a $200 per incident
> processing fee and possible legal action pursuant to US Code, Title
> 47, Chapter 5, Subchapter II, p.227.
Received on Thu Mar 01 2001 - 06:52:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US