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.

Editing Stored Procedures

2 posts in Windows NT Last posting was on 2000-05-17 16:27:20.0Z
Dimitar Kamenov Posted on 2000-05-17 08:35:05.0Z
From: "Dimitar Kamenov" <Dimitar.Kamenov@globalcons.com>
Subject: Editing Stored Procedures
Date: Wed, 17 May 2000 11:35:05 +0300
Lines: 13
Organization: Global consulting
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <5X6sts9v$GA.290@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: gatekeeper.global.bg 212.95.164.3
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2159
Article PK: 1089586

Hi All,

I wold like to edit existing stored procedures in ASE 11.5 via Sybase
Central but I receive the following message "This procedure has already
executed against the database". Is there any away to edit existing stored
procedures via Sybase Central?
Any help would be greatly appreciated!!!

Thanks

Dimitar Kamenov


Eric T. J. Hogue Posted on 2000-05-17 16:27:20.0Z
From: "Eric T. J. Hogue" <Eric.Hogue@wpafb.af.mil>
References: <5X6sts9v$GA.290@forums.sybase.com>
Subject: Re: Editing Stored Procedures
Date: Wed, 17 May 2000 12:27:20 -0400
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <9rPKQ3Bw$GA.261@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: b3o.bips.wpafb.af.mil 198.97.67.102
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2155
Article PK: 1089594

The only way I have found in Sybase Central bring the procudre up, edit it,
use the main window to delete the procedure, then save it.

Eric

"Dimitar Kamenov" <Dimitar.Kamenov@globalcons.com> wrote in message
news:5X6sts9v$GA.290@forums.sybase.com...
> Hi All,
>
> I wold like to edit existing stored procedures in ASE 11.5 via Sybase
> Central but I receive the following message "This procedure has already
> executed against the database". Is there any away to edit existing stored
> procedures via Sybase Central?
> Any help would be greatly appreciated!!!
>
> Thanks
>
> Dimitar Kamenov
>
>