<?
//在oracle中執行存儲過程示例
//供大家參考
$gconn=ocilogon("test","test");
/* ocidefinebypos example [email protected] (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);
?>
