Re: [PHP] Re: Biding Arrays from Oracle Stored Procedure to PHP Variables

[Gregory Watson]

Thanks Lang - from the notes you sent me I'm able to bind arrays 
successfully using a complex select, but using the procedure still gives 
me an error:

   Warning: OCIStmtExecute: ORA-01008: not all variables bound in
   C:\ftp_dir\boards\winners.php on line 20
   Warning: OCIFetch: ORA-24374: define not done before fetch or
   execute and fetch in C:\ftp_dir\boards\winners.php on line 21
All the variables are there; is there any way to get more detail on 
which variable or variables is causing problems?

Thanks again

Greg

Lang Sharpe wrote:

Have a look at this paper, in particular the collections section at the end

http://www.phpconference.de/2001/slides/arntzen_ocipaper.txt

I've never used them myself, because they look a bit dodgy. But it may be 
the only way to do what you're trying to do.

Lang