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

I don't know of a way to get more detail on which bind variables are missing. You could try putting OCIInternalDebug(1); in you script. Normally when i get this error it's usually a typo in my code. Lang Gregory Watson wrote: > 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 >> >>