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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.