Re: [PHP-DEV] Oracle questions for the Oracle gurus out there From: Bjorn Borud (borud <email protected>)
Date: 05/27/98

[Rasmus Lerdorf <rasmus <email protected>>]
|
| Secondly, would it make sense to also make persistent cursors? They
| do not seem to be related to a particular query in any way, but they
| are tied to a connection.

I have a gut feeling that this would not be a good idea, because I
want to introduce (or rather, show Stig how I want it and have him
introduce :-) reference cursors in PHP.

a reference cursor is currently the only way to return a set of rows
from a PL/SQL-routine in Oracle and it works by having an argument
that is both IN and OUT in the PL/SQL-routine of type REFCURSOR (if
memory serves me right).

in order to use this we need to support obndra() and perhaps to change
the Oracle code a bit.

-Bjørn

-- 
 Bjørn Borud <borud <email protected>>       | "The Net interprets censorship 
 <URL:http://www.pvv.unit.no/~borud/>  | as damage and routes around it."
 UNIX person, one of "them"            |         - John Gilmore