note 93458 added to function.oci-bind-array-by-name
| From: | david dot paper at usu dot edu | Date: | Thu, 10 Sep 2009 17:44:24 +0000 |
| Subject: | note 93458 added to function.oci-bind-array-by-name | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-160431@lists.php.net to get a copy of this message | ||
We were able to get the example included for the "OCI_BIND_ARRAY_BY_NAME" to work.
However, the example is NOT actually binding with a PL/SQL array of any type. It is writing data to
an Oracle table named "bind_example". Notice how this table is created. The table does NOT
have an array type as one of its fields. Since this is the case, there cannot be any binding to a
PL/SQL array because at least one field in the table must be either a VARRAY, NESTED TABLE or
ASSOCIATIVE ARRAY data type. We searched the Internet and could not find any examples that actually
read from a PL/SQL array type. We were able to get data from a PL/SQL VARRAY data type, but only by
using a SELECT statement.
----
Server IP: 64.71.164.2
Probable Submitter: 129.123.43.83
----
Manual Page -- http://www.php.net/manual/en/function.oci-bind-array-by-name.php
Edit -- https://master.php.net/note/edit/93458
Del: integrated -- https://master.php.net/note/delete/93458/integrated
Del: useless -- https://master.php.net/note/delete/93458/useless
Del: bad code -- https://master.php.net/note/delete/93458/bad+code
Del: spam -- https://master.php.net/note/delete/93458/spam
Del: non-english -- https://master.php.net/note/delete/93458/non-english
Del: in docs -- https://master.php.net/note/delete/93458/in+docs
Del: other reasons-- https://master.php.net/note/delete/93458
Reject -- https://master.php.net/note/reject/93458
Search -- https://master.php.net/manage/user-notes.php