CodeIgniter Forums
CI & ORACLE, CANNOT INSERT VIA CI BUT SUCCESS WITH SQLDEVELOPER - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: CI & ORACLE, CANNOT INSERT VIA CI BUT SUCCESS WITH SQLDEVELOPER (/thread-52427.html)



CI & ORACLE, CANNOT INSERT VIA CI BUT SUCCESS WITH SQLDEVELOPER - El Forum - 06-10-2012

[eluser]ClOuD_Za[/eluser]
Hi, all

I'm trying to submit an insert query to ORACLE database
it's just a simple one.

I've tried $this->db->query and ActiveRecord

after submit, CI gave me db_driver error on line 330.
this error message is not helping.

I've tried $this->db->last_query() to see what query string it submited into database.

I copied what it showed and pasted into SQLDEVELOPER.
The query was submited successfully without any error.

Any Idea ??

Please Help.

Thank you so much

Chatawat


CI & ORACLE, CANNOT INSERT VIA CI BUT SUCCESS WITH SQLDEVELOPER - El Forum - 06-11-2012

[eluser]Krystian[/eluser]
can you make a select statement from CI to this database? or it gives you the same error?

can you paste your database config file?


CI & ORACLE, CANNOT INSERT VIA CI BUT SUCCESS WITH SQLDEVELOPER - El Forum - 06-11-2012

[eluser]ClOuD_Za[/eluser]
[quote author="Krystian" date="1339419571"]can you make a select statement from CI to this database? or it gives you the same error?

can you paste your database config file?[/quote]

this CI is used for 4 people, every statements are running correctly but i dont know what's wrong with this one ..

i'll post the config file tomorrow. i got no clue cuz other queries works ...

thank you do much, i'm looking forward into ur reply Smile


CI & ORACLE, CANNOT INSERT VIA CI BUT SUCCESS WITH SQLDEVELOPER - El Forum - 06-12-2012

[eluser]ClOuD_Za[/eluser]
sorry for late reply.
following is my config.php and database.php

http://www.sendspace.com/file/e5c76n

Best Regards,
Chatawat


CI & ORACLE, CANNOT INSERT VIA CI BUT SUCCESS WITH SQLDEVELOPER - El Forum - 10-29-2012

[eluser]Unknown[/eluser]
I'm facing the same scenario. Anything to do with oci8_driver.php? I'm getting also the following;

Error Number:

Filename: XXX\system\database\DB_driver.php

Line Number: 330


CI & ORACLE, CANNOT INSERT VIA CI BUT SUCCESS WITH SQLDEVELOPER - El Forum - 11-25-2012

[eluser]Unknown[/eluser]
Hello,

Same problem here, did anyone solved this issue?

Regards