CODEWITHSUNDEEP
phpyii2
Jonnny
Jonnny

Reputation: 5039

Get DB Instance

What is the correct way to execute this code in Yii2. I get oci_new_cursor() expects parameter 1 to be resource, object given. 

// get DB instance
$connection = Yii::$app->db;
// set cursor
$refcur = oci_new_cursor($connection);

$q = "BEGIN :RC := REPORT_CARDS.GET_DATA(:I_YEAR); END;";
...

Upvotes: 0

Views: 815

Answers (1)

Thernys
Thernys

Reputation: 723

There are some important facts to keep in mind:

  1. Yii uses PDO
  2. PDO and OCI8 are completely different extensions and you cannot mix their use
  3. the PDO driver for Oracle databases (PDO_OCI) has limitations; for instance it seems that cursors aren't really supported and its use is in general not really recommended

You can get the PDO instance used by Yii with \Yii::$app->db->pdo, but as per point 2 above, this does not help you with the OCI8 functions you are trying to use in your example. As per point 3, it further does not seem a great idea to commit resources to learning to use PDO just to replace OCI8.

Still, if you want to give the 'Yii way' another shot for those problems that it can still solve, you can try and see how far you get with yii\db\Command. The PDO counterpart for oci_bind_by_name() you refer to in your comment is PDOStatement::bindParam which is basically proxied by yii\db\Command::bindParam. So, a very basic use example for a custom-built SQL query would be something like

// $var1 and $var2 somewhere
$command = \Yii::$app->db->createCommand('some query with :bound :values');
$command->bindParam(':bound', $var1, \PDO::PARAM_STR);
$command->bindParam(':values', $var2, \PDO::PARAM_STR || \PDO::PARAM_INPUT_OUTPUT); 
$command->execute();

I can't really test with your specific example, and based on what I've read I can't guarantee success if you try for yourself, but I wish you luck with the exploration. If it falls short of success, then I don't see an easy way around it; you'll just have to use a separate connection of your own, manually initialized with oci_connect or whatever, and then operate as usual through OCI8.

Upvotes: 1

Related Questions