Error : This feature is not available for the database you are using

Question

I am using oci8 as my database driver in Codeigniter. While using the following code that calls a stored procedure gives me error :

$this->db->call_function('update_letter_body', $body_letter, $insert_id);

Error : This feature is not available for the database you are using.

What should be done to make this work ?

I am trying to set a value that has more than 4000 characters which doesn't seem to work from direct query and seems like the codeigniter does not support calling functions for oracle. Any suggestions ?

as far as i guess these functions are only available to work with mysql not with oracle — Muhammad Raheel, Dec 19 '12 at 06:30
CI oci8 driver is not updated since long time i faced the same problem for my project — umefarooq, Dec 19 '12 at 06:38
Are you sure `CodeIgniter` will not submit a 4000 character normal query using `$this->db->query()`, or maybe its just that your `max_post_size` or `max_execution_time` is set to low? — PhearOfRayne, Dec 19 '12 at 06:41
@StevenFarley : yeah, it does not, check this link http://stackoverflow.com/questions/13945710/error-ora-01704-string-literal-too-long — hsuk, Dec 19 '12 at 06:45
http://stackoverflow.com/questions/9046075/trying-to-call-stored-procedures-with-codeigniter — Kanishka Panamaldeniya, Dec 19 '12 at 06:56

score 7 · Accepted Answer · edited Nov 19 '18 at 15:07

7

hmmm , try with

$this->db->query("CALL update_letter_body(".$body_letter.",".$insert_id.")");

call_function enables you to call PHP database functions that are not natively included in CodeIgniter,not for calling procedures you've written.

check the documentation

https://www.codeigniter.com/user_guide/database/call_function.html

edited Nov 19 '18 at 15:07

Stack Programmer

679
6
18

answered Dec 19 '12 at 06:48

Kanishka Panamaldeniya

17,302
31
123
193

Error : This feature is not available for the database you are using

1 Answers1

Linked