On 17/05/2011 22:18, Tim Bunce wrote:
- Forwarded message from P S Jameel Ahamed -
Date: Tue, 17 May 2011 16:11:04 +0100
From: P S Jameel Ahamed
To: tim.bu...@pobox.com
Subject: Re: DBD::Oracle Slow cursors
X-Mailer: Microsoft Office Outlook 11
HI Tim,
We are facing huge iss
What is the issue exatly?
It is just slow??
Can you give us some examples code to play with.
Slowness can be caused by anything from low-ban width, poor SQL, a badly
partiioned DB or just too much data??
We need to know the version of DBD::Oracle you are using as well
Cheers
John
>
Don't use dynamic queries? You can use PL/SQL variables directly in the SQL
statement w/o specifying them as bind variables. That is, pass them as
parameters to your stored procedure, then just put them directly in the SQL
without decoration. Return XML CLOB instead of cursor?
Just some ide
Tim Bunce schrieb am 17.05.2011 um 22:18 (+0100):
> - Forwarded message from P S Jameel Ahamed
>We are facing huge issues with the SYS_refcurors of oracle
> 10G when returning from Stored procedure. Is there any solution
> you found for the issue?
Care to expand a little on what precisel
- Forwarded message from P S Jameel Ahamed -
Date: Tue, 17 May 2011 16:11:04 +0100
From: P S Jameel Ahamed
To: tim.bu...@pobox.com
Subject: Re: DBD::Oracle Slow cursors
X-Mailer: Microsoft Office Outlook 11
HI Tim,
We are facing huge issues with the SYS_refcurors of oracle 10G
On 17/05/2011 14:54, eric.b...@barclayscapital.com wrote:
Just a quick update:
We switched back to using the FreeTDS driver under DBD::ODBC with the unixODBC
ODBC manager on Linux and the segfault problem went away.
That seems to suggest to me that it's a problem with the Easysoft driver, and
Omg...it's bad enough that we have to use a MS SQL server...but running our
code on Windows...thankfully, that's not a problem we have. Thanks for the
suggestion though, John.
As far as my research has gone so far, it appears at this point that the
TEXTSIZE setting is a server-side setting, wh
Martin Evans would be the expert on that. But it does sound funny that
TEXTSIZE is working and LongReadLen is not?? LongReadLen should work no matter
the driver.
Perhaps you should try DBD::ADO
> From: eric.b...@barclayscapital.com
> To: dbi-users@perl.org
> Date: Tue, 17 May 2011 12:11:55
I'm setting up to use DBD::ODBC with the FreeTDS driver to go against a MS SQL
server and am hoping to nail down the specifics of the relationship between
setting $dbh->{LongReadLen} and TEXTSIZE.
So far, LongReadLen has had exactly no impact on retrieval of long data from my
MS sql server. Re
Just a quick update:
We switched back to using the FreeTDS driver under DBD::ODBC with the unixODBC
ODBC manager on Linux and the segfault problem went away.
That seems to suggest to me that it's a problem with the Easysoft driver, and
I've communicated this to the Easysoft team.
BTW, the Easy
10 matches
Mail list logo