Oracle Date Field Issue With Yii Framework

Yii 1.1 General Discussion
1

Hello Everyone,

i am using Oracle 11ig with Yii framework.

I have configured everything perfectly to work with oracle for my this yii project.I have a table in which i am storing start date and end date which is a DATE type column.

So, when i am trying to add new record which is inserting a dates then it is giving me an exception.


CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1858 OCIStmtExecute: ORA-01858: a non-numeric character was found where a numeric was expected

Even though i have used


$model->START_DATE = new CDbException("TO_DATE('28-05-2013','DD-MM-YYYY')");

      $model->CLOSE_DATE = new CDbException("TO_DATE('28-06-2013','DD-MM-YYYY')");

in my code.And i dont include this lines and try to run my code then i got this exception.


CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1843 OCIStmtExecute: ORA-01843: not a valid month

Any body can suggest me something please who have an experience in Oracle too.Since i am new to oracle that is why i am unable to figure out the solution.but i know atleast that this error is coming when i am inserting dates.

Waiting for your kind responses.

Thanks in Advance !!

2

Huhhhh …

Sorry guys i have resolved that issue. Actually that was my mistake in syntax. :(

But now its working fine. thanks :)

3

It would have been nice if you would have explained what syntax error you made. I’m running into Oracle date fields as well and I suppose that you mistakenly used CDbException instead of CDbExpression.