oci_bind_array_by_name

Binds PHP array to Oracle PL/SQL array by name (PHP 5 >= 5.1.2, PECL oci8:1.2.0-1.2.4)
bool oci_bind_array_by_name ( resource statement, string name, array &var_array, int max_table_length [, int max_item_length [, int type]] )

Example 1632. oci_bind_array_by_name() example

<?php


$c = oci_connect("scott", "tiger");

$create = "CREATE TABLE bind_example(name VARCHAR(20))";
$statement = oci_parse($c, $create);
oci_execute($statement);

$create_pkg = "

CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS

  TYPE ARRTYPE IS TABLE OF VARCHAR(20) INDEX BY BINARY_INTEGER;

  PROCEDURE iobind(c1 IN OUT ARRTYPE);

END ARRAYBINDPKG1;";
$statement = oci_parse($c, $create_pkg);
oci_execute($statement);

$create_pkg_body = "

CREATE OR REPLACE PACKAGE BODY ARRAYBINDPKG1 AS

  CURSOR CUR IS SELECT name FROM bind_example;

  PROCEDURE iobind(c1 IN OUT ARRTYPE) IS

    BEGIN

    FOR i IN 1..5 LOOP

      INSERT INTO bind_example VALUES (c1(i));

    END LOOP;

    IF NOT CUR%ISOPEN THEN

      OPEN CUR;

    END IF;

    FOR i IN REVERSE 1..5 LOOP

      FETCH CUR INTO c1(i);

      IF CUR%NOTFOUND THEN

        CLOSE CUR;

        EXIT;

      END IF;

    END LOOP;

  END iobind;

END ARRAYBINDPKG1;";
$statement = oci_parse($c, $create_pkg_body);
oci_execute($statement);

$statement = oci_parse($c, "BEGIN ARRAYBINDPKG1.iobind(:c1); END;");

$array = array("one", "two", "three", "four", "five");

oci_bind_array_by_name($statement, ":c1", $array, 5, -1, SQLT_CHR);

oci_execute($statement);

var_dump($array);

?>

Examples ( Source code ) » oci_bind_array_by_name


oci_bind_array_by_name() example

<?php


$c = oci_connect("scott", "tiger");


$create = "CREATE TABLE bind_example(name VARCHAR(20))";

$statement = oci_parse($c, $create);

oci_execute($statement);


$create_pkg = "

CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS

  TYPE ARRTYPE IS TABLE OF VARCHAR(20) INDEX BY BINARY_INTEGER;

  PROCEDURE iobind(c1 IN OUT ARRTYPE);

END ARRAYBINDPKG1;";

$statement = oci_parse($c, $create_pkg);

oci_execute($statement);


$create_pkg_body = "

CREATE OR REPLACE PACKAGE BODY ARRAYBINDPKG1 AS

  CURSOR CUR IS SELECT name FROM bind_example;

  PROCEDURE iobind(c1 IN OUT ARRTYPE) IS

    BEGIN

    FOR i IN 1..5 LOOP

      INSERT INTO bind_example VALUES (c1(i));

    END LOOP;

    IF NOT CUR%ISOPEN THEN

      OPEN CUR;

    END IF;

    FOR i IN REVERSE 1..5 LOOP

      FETCH CUR INTO c1(i);

      IF CUR%NOTFOUND THEN

        CLOSE CUR;

        EXIT;

      END IF;

    END LOOP;

  END iobind;

END ARRAYBINDPKG1;";

$statement = oci_parse($c, $create_pkg_body);

oci_execute($statement);


$statement = oci_parse($c, "BEGIN ARRAYBINDPKG1.iobind(:c1); END;");


$array = array("one", "two", "three", "four", "five");


oci_bind_array_by_name($statement, ":c1", $array, 5, -1, SQLT_CHR);


oci_execute($statement);


var_dump($array);


?>

oci_bind_array_by_name

Binds PHP array to Oracle PL/SQL array by name (PHP 5 >= 5.1.2, PECL oci8:1.2.0-1.2.4)
bool oci_bind_array_by_name ( resource statement, string name, array &var_array, int max_table_length [, int max_item_length [, int type]] )

Example 1632. oci_bind_array_by_name() example

Related Examples ( Source code ) » oci_bind_array_by_name

Code Examples / Notes » oci_bind_array_by_name

Change Language

oci_bind_array_by_name

Binds PHP array to Oracle PL/SQL array by name (PHP 5 >= 5.1.2, PECL oci8:1.2.0-1.2.4) bool oci_bind_array_by_name ( resource statement, string name, array &var_array, int max_table_length [, int max_item_length [, int type]] )

Example 1632. oci_bind_array_by_name() example

Related Examples ( Source code ) » oci_bind_array_by_name

Code Examples / Notes » oci_bind_array_by_name

Change Language

Binds PHP array to Oracle PL/SQL array by name (PHP 5 >= 5.1.2, PECL oci8:1.2.0-1.2.4)
bool oci_bind_array_by_name ( resource statement, string name, array &var_array, int max_table_length [, int max_item_length [, int type]] )