Re: Zend Core for Oracle vs. Zend Core (php

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 05 Jan 2006 20:44:17 GMT
Message-Id: <pan.2006.01.05.20.44.15.767900@sbcglobal.net>

On Thu, 05 Jan 2006 20:20:33 +0000, Andy Hassall wrote:

> On Thu, 05 Jan 2006 18:48:56 GMT, Mladen Gogala <gogala_at_sbcglobal.net> wrote:
>

>>One nice thing about OCI8 is that it will support array interface when it 
>>becomes a production. Array interface is already in CVS.

>
> It looks like it implements binding to PL/SQL array/collection types, but the
> previous version claimed to do that too (although it was badly
> underdocumented).
>
> I can't spot how you'd do straight OCI bulk binding in the CVS version? All
> the array_bind* tests run through a PL/SQL procedure with a "table of number
> index by binary_integer" type - this isn't using the OCI array interface, where
> you bind to an array, or use callbacks, and set the "iters" parameter > 1 when
> executing.

You are right. I misinterpretted Wez's comments in the CVS version. Here it's clearly visible that they're ignoring arrays:

statement->errcode = PHP_OCI_CALL(

		OCIBindByName,
		(
			statement->stmt,                /* statement handle */
			(OCIBind **)&bindp->bind,       /* bind hdl (will alloc) */
			statement->err,               /* error handle */
			(text*) name,                    /* placeholder name */					  
			name_len,                        /* placeholder length */
			(dvoid *)bind_data,              /* in/out data */
			value_sz, /* PHP_OCI_MAX_DATA_SIZE, */ /* max size of input/output data */
			(ub2)type,                       /* in/out data type */
			(dvoid *)&bindp->indicator,      /* indicator (ignored) */
			(ub2 *)0,                        /* size array (ignored) */
			(ub2 *)&bindp->retcode,          /* return code (ignored) */
			(ub4)0,                          /* maxarr_len (PL/SQL only?) */
			(ub4 *)0,                        /* actual array size (PL/SQL only?) */
			mode                             /* mode */
		)

-- 
http://www.mgogala.com

Received on Thu Jan 05 2006 - 14:44:17 CST