ORACLE OLEDB ERRORS - Long String and DateTime

General discussion forum about all databases other than SqlBase.
carlos.calegari
Brazil
Posts: 4
Joined: 14 Jan 2021, 22:03
Location: BRASIL

ORACLE OLEDB ERRORS - Long String and DateTime

Post by carlos.calegari » 06 Aug 2013, 12:48

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
You do not have the required permissions to view the files attached to this post.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest