we have a project using TD 3.1 and need to go to TD 6.1 or TD 6.2, but we was found a error.
The problems occur when we use MSDAORA and OraOLEDB.Oracle, in TD 3.1 works fine, but in TD 6.1 spr3 we have the following problems:
1 - Long String Bind:
Using MSDAORA or OraOLEDB.Oracle the Oracle Procedures don't work. In the case is the second SqlPrepare, parameters:
Set P_PROT_ANOTACOES = "Anotações Informadas" ! STRING OK
Set P_PROT_ANOTACOES_LONG = "Anotações Informadas" ! LONG STRING ERROR
2 - Date Time:
The problem is when we send a DATETIME_Null, are diferents behaviors:
MSDAORA --> Save NULL, ok!
OraOLEDB.Oracle --> Save 0000-00-00-00.00.00.000000, don't a NULL. Using TD 6.1 SPr3, we can't call the procedures, in all tests returned error... But, in previous versions or in TD 6.0 we have a return 0000-00-00-00.00.00.000000.
Team Developer 6.1 spr3 - Errors
Team Developer 3.1 - Works Fine
DatabaseScript.zip - Create Table and Package
OLEDB_ERROR_LONG_AND_DATE.zip - Test Case
Who is online
Users browsing this forum: [Ccbot] and 0 guests