Symptom
The creation or execution of a stored procedure results in Error 156 "Incorrect syntax near the keyword 'KEYWORD'." When the stored procedure has a large amount of white space between keywords.
create procedure p
AS -- large number of spaces or whitespace BEGIN
select "Stored procedure installed successfully!" AS TestResult
END
go
Msg 156, Level 15, State 2:
Server 'ase16', Procedure 'p', Line 5:
Incorrect syntax near the keyword 'END'.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP03
- SAP Adaptive Server Enterprise (ASE) 15.7 SP139
Product
Keywords
drop, recreate, spaces, excessive, 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.