oracle column not allowed here

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




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

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.