Delphi TUniStoredProc, Direct access to Oracle and TimeStamp param - error

[PetrB]

Hi all,
I have Delphi XE2, Oracle Database 11g Express Edition Release 11.2.0.2.0, Windows 7 home premium. I'm developing database application using Oracle. This application is able to connect DB server thru oracle client (11.2.0.2.0) or direct access. Using oracle client is working fine, without problems. But if I run my app with Direct access option on I have problem with oracle routines params. Especially with param type TimeStamp. When app is preparing params for routine (TUniStoredProc) I got message "Unsupported data type [180]".
I went thru Unidac source and found routine TOCICommand.InitProcParams7 where is parsing of params. There are types like timestamp but with different number code than 180. OraCallUni.pas define those consts
SQLT_DATE = 184; // ANSI Date
SQLT_TIME = 185; // TIME
SQLT_TIME_TZ = 186; // TIME WITH TIME ZONE
SQLT_TIMESTAMP = 187; // TIMESTAMP
SQLT_TIMESTAMP_TZ = 188; // TIMESTAMP WITH TIME ZONE
SQLT_INTERVAL_YM = 189; // INTERVAL YEAR TO MONTH
SQLT_INTERVAL_DS = 190; // INTERVAL DAY TO SECOND
SQLT_TIMESTAMP_LTZ = 232; // TIMESTAMP WITH LOCAL TZ

Do you have some solution for my problem, how to solve it?

Thank you PB

[AlexP]

Hello,

Thank you for the information. We have fixed the problem. This fix will be included in the next UniDAC version

[PetrB]

Thank you. It's nice to see fast reaction for user problem.

For how long time I could download upgrade of my UnidacProff? My date of registration is 28.6.2012.

PB

[AlexP]

Hello,

Subscription for our products is active for a year. If your subscription has expired, you can renew it at http://www.devart.com/unidac/ordering.html the Renewals & Upgrades tab, the Subscription Renewals section