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

Post found bugs and possible workarounds.
Zink

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

Post by Zink » 14 Jul 2011, 09:52

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

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

Post by Jeff Luther » 15 Jul 2011, 23:44

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

Jeff Luther

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

Post by Jeff Luther » 01 Aug 2011, 19:26

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

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 1 guest