ORACLE OLEDB ERRORS - Long String and DateTime

[carlos.calegari]

Hi,

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.

SOFTWARE:
Team Developer 6.1 spr3 - Errors
Oracle 10
Team Developer 3.1 - Works Fine

TEST CASES:
DatabaseScript.zip - Create Table and Package
OLEDB_ERROR_LONG_AND_DATE.zip - Test Case

Thanks