On Wed, May 01, 2002 at 12:35:48PM +0100, Ford, Mike [LSS] wrote: > Using the Oracle OCI interface, as far as I can see if I do the following: > > $stmt = OCIParse($conn, 'DELETE FROM TITLES' > . ' WHERE TAG<0' > . ' RETURNING ID INTO :T_ID'); > > there seems to be no way of picking up more than one ID when multiple rows are >deleted. The obvious > > OCIBindByName($stmt, ':T_ID', $t_id, 10); > > only returns one ID, and not an array of IDs as I might have > expected. No other method I can think of is able to return > even that! (Including any OCIFetch variation, which doesn't > surprise me as they're labelled as being for SELECT results > only!) > > I would be very grateful for any suggestions of how to do this, > or confirmation that it can't be done (in which case I'll > submit a Feature/Change request to ask for it!).
have you tried an array bind? i have not tries myself, but that would be my 1st guess. see http://conf.php.net/pres/slides/oci/paper.txt for a small sample. > > It seems ridiculous that I should have to do a SELECT/DELETE > pair, when Oracle provides such a useful feature to get the > same result in a single statement. bla bla bla... php comes for free - please choose your words a bit more careful, ppls might get offended and not respond to you at all! if you require this feature and it's not in PHP you can: - moan - implement it and keep it private - implement it and give it back to PHP for other ppls to use - find someone who implements it for free - sponsor someone to implement it if you are interested in sponsoring this development please contact me via PM. tc -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php