Using CI with Oracle Stored Procedures

[eluser]kimo_gusatava[/eluser]
Hi,

I'm trying to learn oracle, and I'm just using a sample database. seems like selecting table and views are easy but when calling procedures I got a bit of a problem...

Is there an easier way to call an Oracle stored Procedure like using the default active record methods?

or should I really have to modify the driver?

seems like the $package is required here right this means I have to create the package? and all I got right now is a procedure...

anyway I would like to call this one:

Code:

create or replace
PROCEDURE add_job_history
  (  p_emp_id          job_history.employee_id%type
   , p_start_date      job_history.start_date%type
   , p_end_date        job_history.end_date%type
   , p_job_id          job_history.job_id%type
   , p_department_id   job_history.department_id%type
   )
IS
BEGIN
  INSERT INTO job_history (employee_id, start_date, end_date,
                           job_id, department_id)
    VALUES(p_emp_id, p_start_date, p_end_date, p_job_id, p_department_id);
END add_job_history;