oci8pdo Follow @yiiframework

// application components
    'components'=>array(        
        // MySQL database config
        'db'=>array(
              'connectionString'=>'mysql:host=myDataBaseHost.com;dbname=myDataBase',
              'username' => '',
              'password' => '',
              'charset' => 'utf8',
        ),
        'dbOracle'=>array(
              'class'=>'ext.oci8Pdo.OciDbConnection',
             /*
              * Note: Normally you use the Easy Connect string, but your server has 
              * to be correctly set-up for that.
              * 
              * ** Easy Connect String **
              * If you get the following error: 
              * `ORA-12154: TNS:could not resolve the connect identifier specified`,
              * go to /opt/oracle/instantclient/sqlnet.ora and change 
              * the following line:
              *    NAMES.DIRECTORY_PATH= (TNSNAMES)
              * Change this to:
              *    NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
              */
//           'connectionString' => 'oci:dbname=//myOracleHost.com:1526/ccq',
             /*
              * ** Full Connection String **
              * Use this method incase your Easy Connect gives you errors and 
              * you can't edit the sqlnet.ora file.
              * You can set the charset in this string as well, add 
              * `;charset=AL32UTF8;` at the end for UTF-8.
              */
              'connectionString' => 'oci:dbname=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myOracleHost.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=myService.intern)));charset=AL32UTF8;',
              'username' => '',
              'password' => '',
             /*
              * enableProfiling and enableParamLogging are working like normal; 
              * Default is false.
              */
              'enableProfiling' => true,
              'enableParamLogging' => true,
        ),
    ),

//Getting the Oracle DB connection
    $oci = Yii::app()->dbOracle;    
    $sql = <<<SQL
SELECT
  t.ANNOUNCEMENT
  , t.DESCRIPTION
  , t.TYPE
FROM
  CCQ.ANNOUNCEMENT_LIST t
WHERE
  t.TYPE = 0
  AND t.DESCRIPTION NOT LIKE '%MENU%'
  AND t.DESCRIPTION NOT LIKE '%Menu%'
  AND rownum<=2
ORDER BY 1
SQL;
 
    $command = $ivr->createCommand($sql);       
    $dataReader = $command->query();
    foreach($dataReader as $row) {
        echo $row['DESCRIPTION'],'$dataReader';
    }

$oci = Yii::app()->dbOracle;   
$command = $oci->createCommand();
$rows = $command->insert('CCQ.MY_ANNOUNCEMENTS', array(
    'PKEY'=>new CDbExpression('(select max(PKEY)+1 from "CCQ"."MY_ANNOUNCEMENTS")'),
    'PC_TO'=>'1111',
    'PC_FROM'=>'1112',
    'PRODUCTTYPE'=>'Internet',
    'TTS'=>'',
    'ANNOUNCEMENT'=>'7501.wav',
    'TYPE'=>'0',
    'DATETIME'=>new CDbExpression('SYSDATE'),
    'TICKET'=>'123123',
));

$row = Yii::app()->dbOracle->createCommand()
        ->select('t.DESCRIPTION')
        ->from('CCQ.MY_ANNOUNCEMENTS t')
        ->where('TICKET=:ticket', array(':ticket'=>123))
        ->queryRow();

class IvrModel extends CActiveRecord
{
    /**
     * Returns the Oracle database connection used by this active record.
     * @return OciDbConnection the Oracle database connection used by 
     * this active record.
     */
      public function getDbConnection()
      {
            if(self::$db!==null) {
                  return self::$db;
            } else {
                  self::$db = Yii::app()->dbOracle;
                  return self::$db;
            }
      }
 
     /**
      * Returns the static model of the specified AR class.
      * @param string $className active record class name.
      * @return IvrModel the static model class
      */
      public static function model($className=__CLASS__)
      {
            return parent::model($className);
      }
 
     /**
      * @return string the associated database table name
      */
      public function tableName()
      {
            return 'CCQ.MY_ANNOUNCEMENTS';
      }
 
     /**
      * @return array validation rules for model attributes.
      */
      public function rules()
      {
            return array(
                  array('PKEY', 'default', 'value'=>new CDbExpression('(select max(PKEY)+1 from "CCQ"."MY_ANNOUNCEMENTS")'), 'setOnEmpty'=>false, 'on'=>'insert'),
                  array('MY_ANNOUNCEMENTS', 'default', 'value'=>new CDbExpression('SYSDATE'), 'setOnEmpty'=>false, 'on'=>'insert'),
                  array('MY_ANNOUNCEMENTS', 'default', 'value'=>new CDbExpression('SYSDATE'), 'setOnEmpty'=>false, 'on'=>'update'),
            );
      }
}

$oneModel = IvrModel::model()->find('TICKET=:ticket', array(':ticket'=>12345));
$allModels = IvrModel::model()->findAll();

$model = new IvrModel;
 //Note the attributes are fully capitalized
$model->PC_TO = 1111;
$model->PC_FROM = 1113;
$model->PRODUCTTYPE = 'Internet';
$model->TTS = '';
$model->ANNOUNCEMENT = '7501.wav';
$model->TYPE = 0;
$model->TICKET = 5555;
$model->save();