Need help with stored procedure oracle

[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

[eluser]jorfermo[/eluser]
try to pass the parameters like this:

'value'=>&$entree

Instead of:

'value'=>$entree

[eluser]cotejf[/eluser]
@jorfermo thanks a lot man, you were right!

Have a great day!

[eluser]jorfermo[/eluser]
You are welcome :-)