SAP Knowledge Base Article - Preview

2578627 - monCachedProcedures shows ObjectName enclosed by asterisk marks - SAP ASE

Symptom

  • monCachedProcedures may show entries with ObjectName surrounded by asterisk marks as belows:
1> select ObjectName, ObjectType, DBName from monCachedProcedures
2> go
 ObjectName                     ObjectType                       DBName
 ------------------------------ -------------------------------- ------------------------------
 sp_mda                         stored procedure                 sybsystemprocs
 sp_sql_type_name               stored procedure                 sybsystemprocs
 sp_who                         stored procedure                 sybsystemprocs
.......
 *sq1593209845_1514147108ss*    stored procedure                 tempdb
 *ss1609209902_0773996335ss*    stored procedure                 tempdb
 *sh1817210643_0457903703ss*    stored procedure                 tempdb


Read more...

Environment

  • SAP Adaptive Server Enterprise version 12.5.x
  • SAP Adaptive Server Enterprise version 15.x
  • SAP Adaptive Server Enterprise version 16.x

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

DYNAMIC_PREPARE, jConnect, JDBC, ODBC, CT-Library, dynamic SQL, light-weight procedure, LWP, PreparedStatement, SQLPrepare, ct_dynamic , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To

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.