SAP Knowledge Base Article - Preview

2382155 - Issue passing literal argument using ADO.NET - SAP PB .NET 12.6

Symptom

  • There is a difference in behavior in PowerBuilder 12.6 Classic and .NET when declaring and executing a stored procedure that has a literal value for an input argument.  
  • In PowerBuilder .NET, executing the following statements:


    DECLARE p21_DeleteCycleCount_wrong  PROCEDURE FOR p21_deletion
      @delete_primary_table_name = 'TableNameArg',
      @delete_row_stmt = :ls_Delete USING trans;
    EXECUTE p21_DeleteCycleCount_wrong;

  • In the SQL Profiler:
    • PowerBuilder 12.6 returns:
      • RPC:Starting exec p21_deletion @delete_primary_table_name='DeleteStmt'
         
    • In PowerBuilder Classic:
      • SQL:BatchStarting execute p21_deletion @delete_primary_table_name ='TableNameArg' , @delete_row_stmt ='DeleteStmtArg'


Read more...

Environment

  • SAP PowerBuilder .NET 12.6
  • Microsoft SQL Server 2014

Product

SAP PowerBuilder 12.6

Keywords

pb,powerbuilder,.net,literal,argument,ado.net,stored procedure,sp,cr802827,802827 , KBA , BC-SYB-PB , PowerBuilder , Bug Filed

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.