TD-15932: TD 6.0/ SP 3 SqlPLSQLCommand changes the parameters

[Zink]

When we use the Function SqlPLSQLCommand in TD 6.0/ SP 3 the value of the parameters changed - for example - from sJobID = 1234 to 12. This error does not appear with TD 6.0 / SP 1 or 2.

In the following example, you can see how we call the function SqlPLSQLCommand

Code: Select all

Function: insertJob
   Description:
   Returns
   Parameters
      String: sJobID
   Static Variables
   Local variables
      Sql Handle: hSqlPLSQLCommand
      String: sPLSQLCommand
   Actions
      Set sPLSQLCommand = 'insert_Job( sJobID ) '
      Call SqlConnect( hSqlPLSQLCommand )
      Call SqlPLSQLCommand( hSqlPLSQLCommand, sPLSQLCommand )
      Call SqlCommit( hSqlPLSQLCommand )
      Call SqlDisconnect( hSqlPLSQLCommand )

[Jeff Luther]

I have added v6 defect TD-15932 for this issue.

[Jeff Luther]

Hi: This TD bug got fixed and release as part of EMP5361