2918013 - UDF causes procedure recompiling after upgrading ASE 16.0 SP03 PL07 & PL08 - SAP ASE.

• When performing nested procedures after ASE upgrade to ASE16.0 SP03 PL07 and PL08, some of called procedures are recompiled though the procedures didn’t have ‘with recompile’ option.
• sp_w result shows that the procedure was compiling every time the problematic procedure is running. 
  fid    spid   command                                                        execution_time       physical_io blocked
  ------ ------ -------------------------------------------------------------- -------------------- ----------- ------- 
    0    338 COMPILING                                                                       100           0       0
• The problematic procedure references a UDF(User Define Function)
• When checking the status value of sysprocedures, the status contains 0x40(procedure no cache) like 1090, 1218 ,1238.
  You can check the procedure name which contains 0x40 in the status as follows.
  select distinct (id), left(object_name(id),50),status  from sysprocedures where status & 0x40=64
  go

• SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL07 and PL08

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed