用PHP執行Oracle預存程序樣本

oracle|預存程序|樣本|執行 <?
//在oracle中執行預存程序樣本
//供大家參考
$gConn=ocilogon("test","test");

/* OCIDefineByPos example thies@digicol.de (980219) */
//discrate與nEcode是out parameter,其餘均是 in parameter.
//預存程序get_discrate存放於package ebiz_pg中。
$stmt = OCIParse($gConn,"BEGIN ebiz_pg.get_discrate(:discrate,505,402,1,56,:nEcode);END;");
OCIBindByName($stmt,":discrate",&$discrate,32);
OCIBindByName($stmt,":nEcode",&$nEcode,32);
OCIExecute($stmt);

echo($discrate);
echo("<br>");
echo($nEcode);

//echo($discrate*0.09);
OCIFreeStatement($stmt);
OCILogoff($gConn);
?>