Re: oracle (oci8) intro

Hello, Anthony Carlos wrote: > > That's interesting. I haven't had to do too many queries with lots of > computed columns. I'll defer to you and double check my queries. On the If you haven't had any problems is because you did not try to use your row range fetching technique with computed columns. > other hand, I have not run into any problems with truncated column data. I guess that is just a visual problem because I no longer recall an example problem. Maybe it was a problem when selecting fields with the same name in different tables. > With regards to the server side cursors, why not send an anonymous PL/SQL > block? I don't suppose that it has to be a stored procedure... I don't recall what the problem was, but I tried to declare a server side cursor but I could not figure how to execute it and have it return a result set to PHP. Maybe it was a PHP limitation when dealing with the OCI API. > Perhaps you're talking about the ability to output the result set from a > PL/SQL block to PHP. That's a curious puzzle. I haven't given it much > thought, mainly because I'm not too good at writing dynamic SQL in PL/SQL > (which is even less arbitrary, I believe, than the code I wrote below), but > what would happen if you built a PL/SQL table or array and bound that to a > PHP variable? Have you ever tried this? No. I even don't know if PHP could do that. > It's nice to see someone with a lot of Oracle experience-- sometimes I think > that this is only for MySQL users! Actually I had a hard time to deal with Oracle (as most people) because I developed a PHP database abstraction named Metabase that among many other things has the ability to let the developers to specify a range of rows that are returned by a select query. Metabase works with many different databases and it supports query result row range clipping in all of them. In those that something like the LIMIT clause is not supported like with Oracle, the feature is emulated trasparently with client side row skipping. It's not very efficient but it allows you to write portable applications. Maybe later I find a more efficient way to do it without compromising the portability Metabase developers applications. I think there is a way to do it with Oracle extensions, but I need to try it first to tell if it works. If you want to know more about Metabase, you may donwload it for free from: http://phpclasses.UpperDesign.com/browse.html/package/20 Regards, Manuel Lemos