Hi Martin I think I found the root cause.
In 1.22 support for auto select of lobs was added, and when you have a lob
in a ref_cursor you can only select 1 row. hence the is_child. What I
will do it try to set it up so the is_child it only set when there is a
Lob in select.
Will get back to you
sco...@pythian.com wrote:
Hi Martin I think I found the root cause.
In 1.22 support for auto select of lobs was added, and when you have a lob
in a ref_cursor you can only select 1 row. hence the is_child. What I
will do it try to set it up so the is_child it only set when there is a
Lob in
Hi,
I have a strange situation I would dearly like some help with as I have
now come unstuck trying to understand what the code in oci8.c is
supposed to do. I have one table and 2 ways to select the same data from
it but one is fast and the other is really slow but I'm stuck with the
latter.
Great stuff Martin I did not write the ref_cursor code but I have an
idea hat the fect rows satamet might be getting all of the rows each
times it runs.
You are right that there should be some sort of ability to set the size
of the records returned in this function.
I'll try to have a look
John Scoles wrote:
Great stuff Martin I did not write the ref_cursor code but I have an
idea hat the fect rows satamet might be getting all of the rows each
times it runs.
You are right that there should be some sort of ability to set the size
of the records returned in this function.
John Scoles wrote:
Great stuff Martin I did not write the ref_cursor code but I have an
idea hat the fect rows satamet might be getting all of the rows each
times it runs.
You are right that there should be some sort of ability to set the size
of the records returned in this function.
Martin Evans wrote:
John Scoles wrote:
Great stuff Martin I did not write the ref_cursor code but I have an
idea hat the fect rows satamet might be getting all of the rows each
times it runs.
You are right that there should be some sort of ability to set the
size of the records returned in
Martin Evans wrote:
Martin Evans wrote:
John Scoles wrote:
Great stuff Martin I did not write the ref_cursor code but I have an
idea hat the fect rows satamet might be getting all of the rows each
times it runs.
You are right that there should be some sort of ability to set the
size of