+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Development (https://forum.codeigniter.com/forumdisplay.php?fid=6)
+--- Forum: CodeIgniter 3.x (https://forum.codeigniter.com/forumdisplay.php?fid=17)
+--- Thread: Store procedure oracle (/showthread.php?tid=63532)
Store procedure oracle - neomicho85 - 11-10-2015
Hello i want to execute an store procedure in my oracle datbase. but i don't know how
when i use this
$this->db->query("call NEWCRS.TEMP()");
i have an error like this
Error Number: 6502
ORA-06502: PL/SQL: numeric or value error ORA-06512: at "SYS.OWA_UTIL", line 354 ORA-06512: at "SYS.HTP", line 1418 ORA-06512: at "SYS.HTP", line 1494 ORA-06512: at "SYS.HTP", line 1814 ORA-06512: at "NEWCRS.TEMP", line 5
call NEWCRS.TEMP()
Filename: controllers/Welcome.php
Line Number: 25