Date field type

[krshin]

Hi Core Lab,

I was download yours ODAC and I would like to test some features if it is not a problem, durig a testing to post some questions?

First impressions are great and all works fine.

I have a small problem on a start, I plan to made my n-tier app to work with firebird and oracle, so if I set field type to DATE into oracle table I get TDateTime field type, but I need just TDate field is this posible and how to solve this little problem!

Thanks in advance...

[Plash]

ODAC always creates ftDateTime fields for DATE columns in database table. There is no way to use ftDate fields in ODAC.

[krshin]

Thanks Plash!

[avgustin]

ODAC always creates ftDateTime fields for DATE columns in database table. There is no way to use ftDate fields in ODAC.

Why Oracle Package Wizard creates ftDate fields instead of ftDateTime for date fields in Oracle database. I use ODAC 8.1.5.
Only for fields that are Timestamp type in database creates ftDateTime parameters.

[AlexP]

hello,

Thank you for the information, we have fixed the problem. Please specify your e-mail address, where we can send you the fixed version of the Oracle Package Wizard library

[avgustin]

myEmail*gmail*com

[AlexP]

hello,

I have sent you a fixed Oracle Package Wizard library to the specified e-mail

[avgustin]

Now it works.
Thanks for support.

Best regards

[AlexP]

Hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.

[avgustin]

Dear Alex

I still have problems with ODAC Package Wizard. Now auto-generated code looks ok, but I receive random access violation errors on runtime.
I am using Delphi 2010 and the latest ODAC version 8.2.8. I rewrite original package wizard dll with the one you had send. In the pictures below there are some print screens from my application.
Error occurs on call ExecProc. There is also a print screen from madExcept that capture the exception. It looks like that error occurs more often if I am using also DB Monitor. In my application I am also using TOraAlerter component.

Do you have any hint, what could be wrong.

Regards

[AlexP]

Hello,

We couldn't reproduce the errors using the latest PackageWizard, please send a small project reproducing the problem and the scripts for creating all of the needed DB objects to alexp*devart*com

[AlexP]

Hello,

Thank you for the information, we got your sample and reproduced the problem.
We will notify you as soon as we have any results.

[avgustin]

Hello,

Thank you for the information, we got your sample and reproduced the problem.
We will notify you as soon as we have any results.

Any solution found regarding this problem?

[AlexP]

hello,

We are still working on this problem.
We will try to fix it in the nearest product version.