Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Can I use system __error in my stored procedures?

2 posts in Trigger Last posting was on 2007-02-15 15:33:41.0Z
GreenStar Posted on 2007-02-15 07:27:57.0Z
From: "GreenStar" <sobincor@inbox.ru>
Newsgroups: Advantage.Trigger
Subject: Can I use system __error in my stored procedures?
Date: Thu, 15 Feb 2007 12:27:57 +0500
Lines: 8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 82.198.22.2
Message-ID: <45d40aac@solutions.advantagedatabase.com>
X-Trace: 15 Feb 2007 00:24:28 -0700, 82.198.22.2
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.198.22.2
Xref: solutions.advantagedatabase.com Advantage.Trigger:317
Article PK: 1136382

Hi
Can I use system __error in my stored procedures? If not, how I can use
RAISE exception (or any other method for generating errors) in my stored
procedures?

Thanks!!!


Edgar Sherman Posted on 2007-02-15 15:33:41.0Z
Date: Thu, 15 Feb 2007 08:33:41 -0700
From: Edgar Sherman <no@email.com>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
Newsgroups: Advantage.Trigger
Subject: Re: Can I use system __error in my stored procedures?
References: <45d40aac@solutions.advantagedatabase.com>
In-Reply-To: <45d40aac@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.24.34.127
Message-ID: <45d47c4f@solutions.advantagedatabase.com>
X-Trace: 15 Feb 2007 08:29:19 -0700, 10.24.34.127
Lines: 24
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.34.127
Xref: solutions.advantagedatabase.com Advantage.Trigger:318
Article PK: 1136384

Are you using scripted procedures or AEPs (DLL Procedures)?

For scripted procedures you can use the RAISE SQL scripting call. See
this page in the help file for more details.

http://devzone.advantagedatabase.com/dz/webhelp/Advantage8.1/advantage.htm#adssql/raise.htm

If you are using AEPs (DLL Procedures) then you can use the __error
table. See this link for more info (Second to last section on the page).
http://devzone.advantagedatabase.com/dz/webhelp/Advantage8.1/advantage.htm#extprocs/creating_an_advantage_extended_procedure.htm

Edgar Sherman
Advantage Support

GreenStar wrote:
> Hi
> Can I use system __error in my stored procedures? If not, how I can use
> RAISE exception (or any other method for generating errors) in my stored
> procedures?
>
> Thanks!!!
>
>