Friday, March 23, 2007

PHP and Oracle cursors

Just checking back in accessing Oracle cursors within PHP. I thought you might be able to retrieve complex data objects using cursors (instead of XML) but that doesn't appear to be the case. When you a retrieve an Oracle cursor, it brings back a resource. You still need to loop over it to fetch the data. This is still better than multiple queries, and perhaps more straightforward than the XML queries. Still I like the XML method better.

No comments: