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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
