OraQuery How to Parameter

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
alicinar
Posts: 13
Joined: Fri 03 Oct 2008 10:06

OraQuery How to Parameter

Post by alicinar » Tue 04 Nov 2008 13:56

TO_NUMBER(TO_CHAR(to_date(=:strVariable,'DD-MM-YYYY'),'J'))


this sql source code is ORA-00906 Missing Expression
how to =:strVariable is sql parameter?
Top
Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Wed 05 Nov 2008 08:52

You should remove the '=' character from this code.
Top
alicinar
Posts: 13
Joined: Fri 03 Oct 2008 10:06

Post by alicinar » Wed 05 Nov 2008 08:56

Plash wrote:You should remove the '=' character from this code.
thanks plash :D
Top
Post Reply

Return to “Oracle Data Access Components”