SAP Knowledge Base Article - Preview

3142625 - Msg 208 on execution of a sp having "execute as caller" after dump & load from 15.7

Symptom

A create procedure containing "execute with caller" clause fails with the following on subsequent execution attempts after the database has been dumped and loaded from 15.7 to 16.0. The sp executes succesfully on the first attempt:

Cannot use variable  '@xxxxx' without first declaring it.
Cannot use variable  '@yyyyy' without first declaring it.
Msg 208, Level 16, State 1:
Server 'servername', Procedure 'procname', Line XXX:
#<table> not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
(return status = -6)


Read more...

Environment

SAP Adaptive Server Enterprise 16.0 

Product

SAP Adaptive Server Enterprise 16.0

Keywords

"execute as caller", Msg 208, "Cannot use variable" , 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.