passing php array to an Oracle function

From: Date: Fri, 17 May 2002 20:19:56 +0000
Subject: passing php array to an Oracle function
Groups: php.db 
Request: Send a blank email to php-db+get-19238@lists.php.net to get a copy of this message
Hope there's any Oracle Guru around. :) Oracle 8.1.7: Asuming that I have the following object type: Create or Replace Type Test_Table_type as object (PK number(10,0), name varchar2(100)); and that I have the following package: Create Package Test_Pkg Is Type test_array_type is varray(10) of Test_Table_Type; Function TestFunc(in_array IN test_array_type) Return number; End; and i want to call the function like this from php: $query = "begin :result := Test_Pkg.TestFunc(:array); end;"; and bind a php array to the :array variable. Is this possible? If yes, what should the array look like? If not, how should i do it then? Any sample code would be really great. Regards Michael

« previous php.db (#19238) next »