From: opintosalazar at terra dot cl
Operating system: Windows 2003 Server
PHP version: 5.0.4
PHP Bug Type: OCI8 related
Bug description: Problem in calling to the Oracle procedure
Description:
------------
At the moment PHP, works very or, yet type of consultations towards the
data base oracle, but something exists, that I have not been able to make
work, or not this supported by PHP, that is what desire to know.
I have a pack in Oracle:
CREATE PACKAGE Prov_Pkg
AS
TYPE tblEName IS TABLE OF VARCHAR2(130) INDEX BY BINARY_INTEGER;
PROCEDURE Prov
(o_EName OUT tblEName)
END Prov_pkg;
CREATE PACKAGE BODY Prov_Pkg
AS
PROCEDURE Prov
(o_EName OUT tblEName)
IS
CURSOR cur_employee IS
SELECT razon_social
FROM Proveedores;
RecordCount NUMBER DEFAULT 0;
BEGIN
FOR curRecProv IN cur_prov LOOP
RecordCount:= RecordCount + 1;
o_EName(RecordCount):= curRecProv.razon_social;
END LOOP;
END Prov;
END Prov_Pkg;
This is everything what I have in oracle, a procedure and a package This
returns a collection to me type table, not a cursor, and I have not been
able to make it work with PHP, however with ASP, this he is very facil,
desire to know, if PHP, supports this
Reproduce code:
---------------
$sql = "Begin Prov_pkg.Prov(:o_EName);End;";
$stmt = OCIParse($conn,$sql);
OCIBindByName($stmt,':o_EName',$o_EName);
OCIExecute($stmt);
echo $o_EName->getelem(0);
it does not work
a comparison of the competition that if it does
set cm = server.createobject("adodb.command")
cm.activeconnection = conexion
cm.commandtext = "{call PROV_PKG.PROV({resultset 9,o_EName})}"
cm.commandtype = &H0001
set reg = server.createobject("adodb.recordset")
reg.activeconnection = conexion
reg.cursortype = 3
set reg.source = cm
reg.open
largo = 0
response.write "salida<br>"
do while not reg.eof
response.write reg("o_EName") & "<br>"
reg.movenext
loop
--
Edit bug report at http://bugs.php.net/?id=33496&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=33496&r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=33496&r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=33496&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=33496&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=33496&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=33496&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=33496&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=33496&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=33496&r=support
Expected behavior: http://bugs.php.net/fix.php?id=33496&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=33496&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=33496&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=33496&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=33496&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=33496&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=33496&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=33496&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=33496&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=33496&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=33496&r=mysqlcfg
