+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Need help with stored procedure oracle (/showthread.php?tid=48313)
Need help with stored procedure oracle - El Forum - 01-11-2012
[eluser]cotejf[/eluser]
Hey guys!
Im doing my best and I really cant execute correctly a call to a stored procedure using oracle 10gr2).
I found on the forum some threads about it but nothing really help me at this moment.
Can someone help? It will be greatly appreciated....
I receive this message:
The connection was reset
The connection to the server was reset while the page was loading.
I can query via CI, the stored procedure is tested, the crential are ok, the grant on the stored proc too.
Im using the latest wamp with php 5.3.8, oci8 1.4.6, oracle standard 10gr2
(my actual code)
Code:
function test(){
$ret='';
$entree='O';
$param = array(
array('name'=>':a1' , 'value'=>$entree , 'type'=>SQLT_CHR, 'length' => 200),
array('name'=>':a2', 'value'=>$ret, 'type'=>SQLT_CHR, 'length' => 200),
);
$this->db->stored_procedure('test','testjfc',$param);
echo "ok";
}and my stored proc:
Code:
CREATE OR REPLACE procedure test.testjfc (p0 in varchar2, p1 out varchar2)is
begin
declare
l_dummy varchar2(1);
begin
if p1='O' then
p1 := 'OUI';
else
p1:= 'NON';
end if;
end;
end;
/Thanks
Need help with stored procedure oracle - El Forum - 02-21-2012
[eluser]jorfermo[/eluser]
try to pass the parameters like this:
'value'=>&$entree
Instead of:
'value'=>$entree
Need help with stored procedure oracle - El Forum - 02-27-2012
[eluser]cotejf[/eluser]
@jorfermo thanks a lot man, you were right!
Have a great day!
Need help with stored procedure oracle - El Forum - 02-28-2012
[eluser]jorfermo[/eluser]
You are welcome :-)