ORACLE OLEDB ERRORS - Long String and DateTime

General discussion forum about all databases other than SqlBase.
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


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

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-, 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-

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

TEST CASES: - Create Table and Package - Test Case

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 3 guests