storing record in tables, that relate to multiple id's

[eluser]Brad K Morse[/eluser]
I tried using that. I have the database autoloading within the libraries array of autoload.php

This is the function I wrote that inserts into two tables.

Code:

function insertTwo() {
  $data = array(
                  'SP_COMMENTS_MESSAGE'       =>  'I am trying to insert this in' ,
                  'SP_COMMENTS_STATUS'        =>  'Completed' ,
                  'SP_COMMENTS_DEPARTMENT_ID' => 1
                );
  $this->db->insert('SP_COMMENTS', $data);
  
  $foreign_key = $this->db->insert_id();
  
  $data2 = array(
                  'SP_TRANSACTIONS_COMMENT_ID'  =>  $foreign_key ,
                  'SP_TRANSACTIONS_STEP_ID'     =>  3
                );
                
  $this->db->insert('SP_TRANSACTIONS', $data2);
  
}

It prints this error out: This feature is not available for the database you are using.

I am using a oracle db, which does not support the $this->db->insert();