DBD::Oracle, 10g Lob Refetch problem

Hello, I just built DBD::Oracle 1.26 on Solaris SPARC 2.10 using perl 5.8.5 32 bit against client 10.0.2.4 We've been having trouble since day one. The biggest problem is that we are having a problem writing LOB fields. We get the following error: DBD::Oracle::st execute failed:

RE: DBD::Oracle, 10g Lob Refetch problem

, 10g Lob Refetch problem Moin Carl, Furst, Carl schrieb am 20.12.2010 um 15:17 (-0500): I just built DBD::Oracle 1.26 on Solaris SPARC 2.10 using perl 5.8.5 32 bit against client 10.0.2.4 Perl 5.8.5 is from mid-2004, so six and a half years old. Time to upgrade to 5.8.9

RE: DBD::Oracle, 10g Lob Refetch problem

...@pythian.com] Sent: Tuesday, December 21, 2010 8:51 AM To: dbi-users@perl.org Subject: Re: DBD::Oracle, 10g Lob Refetch problem On 20/12/2010 3:17 PM, Furst, Carl wrote: Hello, I just built DBD::Oracle 1.26 on Solaris SPARC 2.10 using perl 5.8.5 32 bit against client 10.0.2.4 We've been having

RE: DBD::Oracle, 10g Lob Refetch problem

@perl.org Subject: Re: DBD::Oracle, 10g Lob Refetch problem On 21/12/2010 10:48 AM, Furst, Carl wrote: Thanks to all of you for taking the time to answer my questions. Unfortunately I don't have the output from the compile. However consider that we are able to connect, select, insert, and update

RE: DBD::Oracle 'make test' fails - ORA-24327: need explicit attach before authenticating a user

I'm wondering if just using the username@SIDSTRING would have worked without TWO_TASK being set? It did for me on Solaris Sparc. If TNS_ADMIN or ORACLE_HOME is set correctly, it should lookup SIDSTRING in tnsnames.ora for connection info. Carl Furst -Original Message- From: Alexander

RE: Problem with UTF8 and array binding....

Then, I guess, the text was not utf8, you set the flag, but did you actually convert the text to a UTF-8 format, perhaps an explicit encode('utf8', $text) call? Just a thought. Also some more food for thought about utf8 and UTF-8

RE: One of us can't count....

Are you calling $csr-finish at the end of each iteration? Might not be the issue but indeed good practice. Carl Furst o/~ What a difference a byte makes... o/~ -Original Message- From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu] Sent: Friday, February 18, 2011 3:07 PM Cc: DBI

RE: One of us can't count....

OK, scratch my last this indeed has changed... http://search.cpan.org/~timb/DBI-1.616/DBI.pm#finish Carl Furst o/~ What a difference a byte makes... o/~ -Original Message- From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu] Sent: Friday, February 18, 2011 3:07 PM Cc: DBI Users

RE: DB2-DBD error messages

It could be that there is a POSIX issue with fastcwd() on your machine. Does your machine support getcwd(3)? and is it the POSIX version? It could be that the dangerous portion of the description below is in play here and that fastcwd() is trying to muck around with chdir(). You could easily

Re: What is the oldest community supported versions for PERL DBI and DBD::ORACLE?

I'm sorry I should clarify.. When I say work I mean you can build it against that version of the OCI. What you should do is see what the highest version of the DBD::Oracle can build against your OCI client. Carl Furst On 1/23/12 10:32 AM, Furst, Carl carl.fu...@mlb.com wrote: If I

Re: DBD::Oracle Schema different than User question

Switching schemas in Oracle makes no sense, because schemas are tied to the user. In fact you don't login to oracle with a username but with a schema name. Schema and username are the same things. It is not like MySQL where you have Databases that denote these object groups and are separate from

Re: Error appears in web log but script runs ok on the command line

So did you build DBD::Oracle with that LD_LIBRARY_PATH? And against that install? Maybe Oracle.so is using LD_LIBRARY_PATH set at build time instead of runtime? Carl Furst On 10/21/13 4:03 PM, Bruce Johnson john...@pharmacy.arizona.edu wrote: On Oct 20, 2013, at 1:03 PM, Bruce Johnson

DBD::Oracle installation

What libs from oracle are exactly required to install this.. We just installed the client libs, including sql plus on Centos and it seems that Makefile.pl is having trouble finding the version: WARNING: I could not determine Oracle client version so I'll just default to version 8.0.0.0. Some

Re: DBD::Oracle installation

On 12/5/13 6:57 PM, Bruce Johnson john...@pharmacy.arizona.edu wrote: On Dec 5, 2013, at 4:06 PM, Furst, Carl carl.fu...@mlb.com wrote: What libs from oracle are exactly required to install this.. We just installed the client libs, including sql plus on Centos and it seems that Makefile.pl

Re: First time DBI user crashing perl

Is the driver you are using the one you used to install the DBD libs with? If you installed the DBD libs with one driver and then, say, upgraded the driver, you would have to re-install the DBD libs. Carl Furst On 10/30/14, 5:37 PM, Tim Bunce tim.bu...@pobox.com wrote: On Thu, Oct 30,

Re: make test fails installing DBI-1.632 (linux, perl5.8.8)

-- From: John Wiersba jrw32...@gmail.com Date: Thu, Jan 8, 2015 at 11:19 AM Subject: Re: make test fails installing DBI-1.632 (linux, perl5.8.8) To: Furst, Carl carl.fu...@mlb.com Thanks, Carl. Well, I see that now, but I did not see it before, even after looking for it. And it's only a warning

Re: make test fails installing DBI-1.632 (linux, perl5.8.8)

But it did say: Warning: prerequisite Test::Simple 0.90 not found. We have 0.62. Which is the same thing, really. Carl Furst CMS Developer MLB Advanced Media On 1/8/15, 10:48 AM, John Wiersba jrw32...@gmail.com wrote: After installing the latest version of Test::Simple, all tests

Re: DBD::CSV

drive I get this output: Cannot obtain shared lock on /export/home/mmusgrove/test. csv: No locks available -- ./test.plhttp://test.pl at 18 $VAR1 = {}; HTH, Matt On Wed, Feb 25, 2015 at 11:25 AM, Furst, Carl carl.fu...@mlb.commailto:carl.fu...@mlb.com wrote: I think someone wrote about

Re: Bundle::DBI and DBD::Oracle failing

It means you don¹t have the Oracle DBD installed. Or its installed to a different place. Did you install it? Where? Carl Yamamoto-Furst -- From: Tony D'Alfonso Date: Wednesday, June 22, 2016 at 2:00 PM To: "dbi-users@perl.org" Subject:

Re: Perl DBI libraries for connecting 12c

I believe you have to go to Oracle to get those.. You can get DBI and even DBB::Oracle but it won’t build. You won’t have the Oracle C libs to link off of. You’ll need to install an oracle client library. -- Carl Yamamoto-Furst From: Michael Radakovich Date: