Get error number with oracle database in Codeigniter

Question

First of all sorry for my bad English..

I have this function in a model:

function insertUser($data){

$sql = "INSERT INTO USERS VALUES (?, ?, ?, ?, ?, ?, ?, ?)";

$query = $this->db->query($sql, array(
    $data["uname"],
    $data["nome"],
    $data["dnuser"],
    $data["muser"],
    $data["fruser"],
    $data["cpuser"],
    $data["euser"],
    md5($data["passu"])
  ));

//return $this->db->_error_number();

}

I have one primary key and when data is correct the function works but when is inserted a duplicate key the function doesn’t work. But how can i know that? i mean how can i catch the error ORA-00001 ??

BTW the commented line doesn’t work..

Thank you very much!!

yes, the function is defined that way in oci_driver.php in system folder... — José Ricardo Ribeiro
– José Ricardo Ribeiro, Commented Dec 9, 2012 at 0:43
What kind of class is $this->db then? Or what framework are you using? Which framework/application does this system folder belong to? — GolezTrol
– GolezTrol, Commented Dec 9, 2012 at 0:48

Hasib Tarafder · Accepted Answer · 2012-12-09 05:14:48Z

2

You can use try catch block...

function insertUser($data){

$sql = "INSERT INTO USERS VALUES (?, ?, ?, ?, ?, ?, ?, ?)";

try{
$this->db->trans_start();
$query = $this->db->query($sql, array(
    $data["uname"],
    $data["nome"],
    $data["dnuser"],
    $data["muser"],
    $data["fruser"],
    $data["cpuser"],
    $data["euser"],
    md5($data["passu"])
  ));
$this->db->trans_commit();
}
catch(Exception $ex){
$this->db->trans_rollback();
echo "Error:".$ex;
}
}

You can check the following article..

http://ellislab.com/codeigniter/user-guide/database/transactions.html

answered Dec 9, 2012 at 5:14

community wiki

Hasib Tarafder

Sign up to request clarification or add additional context in comments.

1 Comment

danisupr4 Over a year ago

are you sure have tried those codes and get expected result? for me those codes didn't result anything.

Collectives™ on Stack Overflow

Get error number with oracle database in Codeigniter

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related