Page 1 of 1

OraQuery How to Parameter

Posted: Tue 04 Nov 2008 13:56
by alicinar
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?

Posted: Wed 05 Nov 2008 08:52
by Plash
You should remove the '=' character from this code.

Posted: Wed 05 Nov 2008 08:56
by alicinar
Plash wrote:You should remove the '=' character from this code.
thanks plash :D