getLastInsertId workaround for Oracle

myActiveRecord

<?php

class QActiveRecord extends CActiveRecord {
	
	
	public function afterSave(){

		if(Yii::app()->db->driverName == 'oci'){

			try {
				$connection=Yii::app()->db;
				$sql = "select {$this->sequenceName}.currval from dual";
				$result = $connection->createCommand($sql)->queryRow();
							
				$this->ID = $result['CURRVAL'];

			} catch (Exception $e) {
				echo("Error: $e\n");
			}
			
		} else {
			// not implemented yet, doubt this will work
			return parent::getLastInsertId();
			
		}
		
	}
	
	
}

?>

Not so sure about this solution. What happens if a transaction slips in between the SELECT SEQ.NEXTVAL and this select CURRVAL? Then you'll have the wrong ID.

yes, this needs to be wrapped in a transaction