SAP Knowledge Base Article - Preview

2523322 - Msg 2007 returned on self-referencing procedure without owner prefix - SAP ASE

Symptom

  • Msg 2007 is returned when creating a self-referencing stored procedure
  • When not consistently using the 'dbo' owner prefix:

Msg 2007, Level 11, State 1:
Server 'ASE', Procedure 'dbo.proc_name':
Cannot add rows to sysdepends for the current stored procedure because it
depends on the missing object 'proc_name'. The stored procedure will still be created.


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

execute as owner, execute as caller, not valid procedure name, validate, ownership , "error 2007" , "msg 2007" , 2007 , "message 2007" , KBA , 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.