oracle column not allowed here

Yii 1.1 General Discussion
1

hi, i dunno what’s going on, but i think my sql statement’s quotes and commas are in correct places, but when i run this code




$query = "INSERT INTO MYTABLE (ADID,COMPLAINID,STATUS,CREATEDDATE,CREATEDBY,UPDATEDDATE,UPDATEDBY)

                        VALUES('".$adid."','10','7',CURRENT_DATE,'1',CURRRENT_DATE,'1')";

                    Yii::app()->db->createCommand($query)->execute();

am getting a "COLUMN NOT ALLOWED HERE" error from oracle, any idea why?

what’s the Yii way to get rid of this error and let me pass through this ?

NOTE: there’s an autoincrement field that I left,because in mysql, if there’s a PK that has an auto-increment, we can ommit it from the insert statement…i don’t know in oracle

2

Hello. It seems you can’t use CURRENT_DATE like this. Are you sure it’s the correct function to return the value you need to insert? I’m not an Oracle guy, but I would google it.