Oracle and Store Procedure

[Anon]

Hi,
What's that problem in this code?
function Logon($matricula,$senha,$CaminhoDadosP,$TempBooleanDados,$conn){
if ($senha != ""){
//Exec. da StoreProcedure afim de Retornar os Dados do Solicitante
$EMail = '[e-mail]';
$STOREPROCEDUREDADOSC = "begin INFO_USUARIO('MBRAGA',$NOME,$AREA,$ESCRITORIO,";
$STOREPROCEDUREDADOSC .= "$LOCALIZACAO,$RAMAL,$FUNCAO,";
$STOREPROCEDUREDADOSC .= "$E_MAIL,$RETORNO); end;";
$stmt = OCIParse($conn,$STOREPROCEDUREDADOSC);
}else{
//$stmt = OCIParse($conn,'SELECT DadosCliente From TblCliente WHERE MATRICULA = :matricula end');
}
OCIExecute($stmt);
Dados do Solicitante
$this->Matric = ociresult($stmt,"col_Matr");
$this->Name = ociresult($stmt,"NOME");
$this->Carg = ociresult($stmt,"col_Cargo");
$this->Fone = ociresult($stmt,"col_Fone");
$this->Setor = ociresult($stmt,"col_Setor");
$this->Localiz = ociresult($stmt,"col_Localiza");
$this->CompSetor = ociresult($stmt,"col_CompSetor");
$this->Email = ociresult($stmt,"col_Email");
/
if ($TempBooleanDados==0){
setcookie ("LOGON",$senha);
//header ("Location: $CaminhoDadosP");
}
OCIfreeStatement($stmt);
}

i would like execulte one store procedure wich Oracle, help-me please...

thank's Sinval filho

[Anon]

Hey
From your program i figure out that you have a stored procedure call and this procedure has some in, some out variables. You need to approach in the folllwing way

Say on Oracle

Library.GetLoginWebRights(UserID IN NUMBER,
WebPass IN VARCHAR2, WebRights OUT VARCHAR2);

Your PHP code should follow the below

$c = OCILogon($dbUser, $dbPass,$db);

$StoredProc = "begin library.GetLoginWebRights($UserID, '".$WebPass."', :WebRights); end;";

$s = OCIParse($c,$StoredProc);

OCIBindByName($s,":WebRights", &$WebRights, 200); // check manual for the explanation for this.

OCIFreeStatement($s);

OCILogoff($c);

Now you can access your returned variable $WebRights.

I hope i answered your question

OCIExecute($s);

[Anon]

Hi,

If I make print out variable in screen, can i?
If yes, how?
This example that you writed for me, it have webRights variable and
i need to write WebRights variable, please help-me

thank's Sinval Filho

[Anon]

HI,

That's all Ok! Thank's
But now i would use variable in and out
wich store procedure, can i help?

thank's again Sinval Filho