Symptom
Recreating a stored procedure that references an already existing table results in error 2714 returned to client:
Msg 2714, Level 16, State 1: Server 'ASE_SPXXX', Procedure 'select_into_example_proc', Line 11:
There is already an object named 'tab_target' in the database.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
"error 2714", "message 2714" , "drop procedure" , "recreate procedure" , "re-create procedure" , KBA , execute , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.
SAP Knowledge Base Article - Preview