How to retrieve a result from a function using the OCI interface to ORACLE

From: Date: Wed, 19 Apr 2006 19:05:40 +0000
Subject: How to retrieve a result from a function using the OCI interface to ORACLE
Groups: php.windows 
Request: Send a blank email to php-windows+get-26856@lists.php.net to get a copy of this message
Dear Friends, I am quite lost here. I am implementing quite a lot of functions and packages in ORACLE to actualize data, but I dont see possible yet to call successfully the function. Given the following code: "Declare res NUMBER Begin res := foo('bar'); end;" I cannot get the value of res. What I am doing in php is: a) parsing the code b) oci_bind_by_name($stmt, ":res", $res); c) oci_execute($stmt); and the only thing that I can get is apache to hang up. Does anyone knows how to fix it? because I've been searchin' the documentation and I couldnt find the fix so far. Thx in advance Leonardo Belen. AFIP-AR PS: My system is a Windows 2000 Machine with apache 2*, and oracle 9.2

« previous php.windows (#26856) next »