Symptom
- sp_showtext (or sp_helptext) shows incorrect syntax in a stored procedure, for example:
sp_showtext p2
create proc p2
go
as
declare @val int
declare c cursor for select id from sysobjects
open c
fetch c into @val
while (@@sqlstatus !=2)
begin
print "in cursor"
if 1=1
begin
print "in if clause"
end
fetnd
fetch c into @val
end
dbcc upgrade_object (pubs2, p2, 'check')
go
Msg 102, Level 15, State 181:
Server 'myASE', Procedure 'p2', Line 15:
Incorrect syntax near 'fetnd'.
Msg 11031, Level 16, State 1:
Server 'myASE', Procedure 'p2', Line 15:
Execution of procedure p2 failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.p2.
- Same issue is seen when using ddlgen.
- This issue does NOT happen in
- SAP ASE 15.7 SP139 and lower
- SAP ASE 16.0 SP03 PL03 and lower
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL04 and above
- SAP Adaptive Server Enterprise (ASE) 15.7 SP140 and above
- High Availability Disaster Recovery (HADR)
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
817723, CR817723, CR#817723, extra spaces, tab, wrong behavior, compiled, compile, migration, keywords, whitespace, CR817869, CR#817869, 817869, CR813005, CR#813005, 813005, 156, missing end comments mark , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.