TOraStoredProc - Cannot Convert Type on Prepare

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
mikeho
Posts: 41
Joined: Thu 11 Nov 2004 21:23
Location: Middle Tennessee USA

TOraStoredProc - Cannot Convert Type on Prepare

Post by mikeho » Thu 11 Nov 2004 21:26

What would cause the generic SCannotConvertType error to be thrown during a Prepare call for a TOraStoredProc?

mikeho
Posts: 41
Joined: Thu 11 Nov 2004 21:23
Location: Middle Tennessee USA

Post by mikeho » Thu 11 Nov 2004 21:53

I think I found my own answer... seems that a Parameter was being set by ParamByName('ReceiveDate').AsDate = StrToDate(edRecDate.Text). I changed this to AsDateTime and the Prepare worked.

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Fri 12 Nov 2004 08:17

We fixed this problem with TOraParam.AsDate in ODAC 5.10.4.12. Please download the last ODAC version

Post Reply