PL/SQL functions & nested tables

[Anon]

Hi...two questions.

1) How can I use PHP to get the return value from an oracle 8 function? Is this even possible, or should I recode the functions to use OUT variables instead.

2) How can I handle oracls collections in PHP? For example, I have a collection of VARCHAR2's which get returned from a function. How can I user PHP to get to the individual elements of the collection?

Thanks,
Tim Reddy

[Anon]

1) Try something like:
<?php
$pno = 10;
$conn = OCILogon("yourusername", "yourpassword", "yourdbservicename");
$stmt = OCIParse($conn, "begin :name := test_function(:pno); end;");
OCIBindByName($stmt, ":pno", &$pno, -1);
OCIBindByName($stmt, ":name", &$name, 11);
$result = OCIExecute($stmt);
OCIFreeStatement($stmt);
OCILogoff($conn);
echo $name;
?>

2) All the Collection functions are listed as "Coming soon." and "(PHP 4 >= 4.0.6)". See http://www.php.net/manual/en/ref.oci8.php

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com