Re: [EXT]Re: Is this a DBD::Pg problem or Postgres problem?

2023-10-16 Thread Johnson, Bruce E - (bjohnson)
hnson) wrote: I’ve move an application to Postgres for the database and am having a problem with using named parameters. My code: my $csr_newinv =$lda->prepare("insert into inventory (inv_id, instid, av_id, vials, volume, expiration_date, update_date) values (nextval(invid_seq),:INST

Re: Is this a DBD::Pg problem or Postgres problem?

2023-10-16 Thread Peter J. Holzer
On 2023-10-15 23:26:03 +, Johnson, Bruce E - (bjohnson) wrote: > I’ve move an application to Postgres for the database and am having a problem > with using named parameters. > > My code: > > my $csr_newinv =$lda->prepare("insert into inventory (inv_id, inst

Is this a DBD::Pg problem or Postgres problem?

2023-10-15 Thread Johnson, Bruce E - (bjohnson)
I’ve move an application to Postgres for the database and am having a problem with using named parameters. My code: my $csr_newinv =$lda->prepare("insert into inventory (inv_id, instid, av_id, vials, volume, expiration_date, update_date) values (nextval(invid_seq),:INST, :AV,:VI,:VO,

Re: DBD::Sybase building Problem 64<>32bit

2014-10-17 Thread Michael Peppler
peppler@li ~]$ Michael On 16 Oct 2014, at 19:13, Monetron Team wrote: > Hello List, > > My problem is that i have a 32 bit version of ASE/ > OpenClient, but as it is running on 64bit Linux, Perl is installed in 64 bit > mode. > > # uname -a > Linux 2.6.18-398.el5xen #

DBD::Sybase building Problem 64<>32bit

2014-10-16 Thread Monetron Team
Hello List, My problem is that i have a 32 bit version of ASE/ OpenClient, but as it is running on 64bit Linux, Perl is installed in 64 bit mode. # uname -a Linux 2.6.18-398.el5xen #1 SMP Tue Sep 16 21:31:50 EDT 2014 x86_64 x86_64 x86_64 GNU/Linux # perl -v This is perl, v5.8.8 built for

Re: installation problem make: command not found

2013-02-18 Thread Jon
Indeed. Thanks for the correction. On Feb 18, 2013 12:42 PM, "Bruce Johnson" wrote: > > On Feb 18, 2013, at 11:07 AM, Jon wrote: > > > Hello Abeer, > > > > It appears that make is not installed. > > > > You can install make by itself (depending on your platform) > > > > CentOS/RHEL: yum install

Re: installation problem make: command not found

2013-02-18 Thread Bruce Johnson
On Feb 18, 2013, at 11:07 AM, Jon wrote: > Hello Abeer, > > It appears that make is not installed. > > You can install make by itself (depending on your platform) > > CentOS/RHEL: yum install make > Debian/Ubuntu: apt-get install make > > or install the development meta package > CentOS/RHEL

Re: installation problem make: command not found

2013-02-18 Thread Jon
Hello Abeer, Apologies for the typo, The following command to install the "Development Tools" meta package (barring the obvious typo): >> CentOS/RHEL: yum install "Developement Tools" should actually be: >> CentOS/RHEL: yum groupinstall "Development Tools" Best Regards, Jon A On Mon, Feb 18,

Re: installation problem make: command not found

2013-02-18 Thread Jon
Hello Abeer, It appears that make is not installed. You can install make by itself (depending on your platform) CentOS/RHEL: yum install make Debian/Ubuntu: apt-get install make or install the development meta package CentOS/RHEL: yum install "Developement Tools" Debian/ubuntu: apt-get install

installation problem make: command not found

2013-02-18 Thread Abeer Fadda
Hi, this is the output : $ perl -v This is perl 5, version 12, subversion 4 (v5.12.4) built for darwin-thread-multi-2level (with 2 registered patches, see perl -V for more detail) DBI-1.623 abeer$ perl Makefile.PL *** Your LANG environment variable is set to 'en_US.UTF-8' *** This may cause p

Re: problem getting DBD::mysql working in OS X 10.7

2012-01-03 Thread Brian Manning
On Tue, Jan 3, 2012 at 1:59 PM, Bruce Johnson wrote: > > On Dec 30, 2011, at 9:57 PM, Bruce Johnson wrote: > >>> >>> otool still shows the dylib file sans path, but the original script now >>> works... >> >> But python is still broken, which is another part of my toolchain. >> >> Gonna rip it all

Re: problem getting DBD::mysql working in OS X 10.7

2012-01-03 Thread Bruce Johnson
On Dec 30, 2011, at 9:57 PM, Bruce Johnson wrote: >> >> otool still shows the dylib file sans path, but the original script now >> works... > > But python is still broken, which is another part of my toolchain. > > Gonna rip it all out and use MacPorts... Which ended up working just fine, an

Re: problem getting DBD::mysql working in OS X 10.7

2011-12-30 Thread Bruce Johnson
On Dec 30, 2011, at 6:55 PM, Bruce Johnson wrote: >> I would say yes, here's mine (from MacPorts): > > Well, I found this: > > > that was supposed to fix the issue. > > It didn't, so I took the brute-force kludge

Re: problem getting DBD::mysql working in OS X 10.7

2011-12-30 Thread Bruce Johnson
On Dec 29, 2011, at 5:02 PM, Brian Manning wrote: > On Thu, Dec 29, 2011 at 3:26 PM, Bruce Johnson > wrote: >>> Does the output of: >>> >>> otool -L >>> /Library/Perl/5.12/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle >>> >>> list your custom MySQL libraries anywhere? If the linker

Re: problem getting DBD::mysql working in OS X 10.7

2011-12-29 Thread Brian Manning
On Thu, Dec 29, 2011 at 3:26 PM, Bruce Johnson wrote: >> Does the output of: >> >> otool -L >> /Library/Perl/5.12/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle >> >> list your custom MySQL libraries anywhere?  If the linker can't find >> your MySQL libraries, then you'll need to give the

Re: problem getting DBD::mysql working in OS X 10.7

2011-12-29 Thread Bruce Johnson
On Dec 29, 2011, at 4:00 PM, Brian Manning wrote: > On Thu, Dec 29, 2011 at 2:40 PM, Bruce Johnson > wrote: >> >> On Dec 29, 2011, at 3:36 PM, Bruce Johnson wrote: >> >>> I tried installing Bundle::DBD::mysql via cpan, but got errors about how it >>> couldn't find mysql_config, so I downloade

Re: problem getting DBD::mysql working in OS X 10.7

2011-12-29 Thread Brian Manning
On Thu, Dec 29, 2011 at 2:40 PM, Bruce Johnson wrote: > > On Dec 29, 2011, at 3:36 PM, Bruce Johnson wrote: > >> I tried installing Bundle::DBD::mysql via cpan, but got errors about how it >> couldn't find mysql_config, so I downloaded the DBD::mysql package manually >> and used perl Makefile.pl

Re: problem getting DBD::mysql working in OS X 10.7

2011-12-29 Thread Bruce Johnson
On Dec 29, 2011, at 3:36 PM, Bruce Johnson wrote: > I tried installing Bundle::DBD::mysql via cpan, but got errors about how it > couldn't find mysql_config, so I downloaded the DBD::mysql package manually > and used perl Makefile.pl --mysql_config=/usr/local/mysql/bin/mysql_config > which is

problem getting DBD::mysql working in OS X 10.7

2011-12-29 Thread Bruce Johnson
I tried installing Bundle::DBD::mysql via cpan, but got errors about how it couldn't find mysql_config, so I downloaded the DBD::mysql package manually and used perl Makefile.pl --mysql_config=/usr/local/mysql/bin/mysql_config which is where my mysql_config file lives (it's a standard install fo

Re: [DBI-Users] Fwd: Problem to get UTF8-CSV-File

2011-12-23 Thread Bill Ward
On Fri, Dec 23, 2011 at 3:08 AM, Charles Jardine wrote: > On 22/12/11 20:40, Bill Ward wrote: > >> Agreed. Any Oracle initialization environment variables need to be set >> before your Perl script starts. Another approach is to set them and then >> re-exec() from within the script ... though be c

RE: [DBI-Users] Fwd: Problem to get UTF8-CSV-File

2011-12-23 Thread John Scoles
Let me chime in here as well. Though I rarely ever use UTF but I beleive you can set and or override any of the ENV values this at the handle level which I think is the best solution to the orginal problem >From the POD ora_charset, ora_ncharset For oracle versions >= 9.2 you can s

Re: [DBI-Users] Fwd: Problem to get UTF8-CSV-File

2011-12-23 Thread Charles Jardine
before perl itself is loaded. So, re-execing is necessary for a change to LD_LIBRARY_PATH, but not, but not for a change of NLS_LANG. hello ralf hello jens Jens Rehsack schrieb: [...] We have a problem. We want to get an UTF8-CSV-File from UTF8-Oracle-Database. It seems to be that the CSV-File

Re: [DBI-Users] Fwd: Problem to get UTF8-CSV-File

2011-12-22 Thread Bill Ward
alf > hello jens > > Jens Rehsack schrieb: > [...] > > We have a problem. We want to get an UTF8-CSV-File from >> UTF8-Oracle-Database. It seems to be that the CSV-File is always charset >> "latin-1". What can we do to get UTF-8-File? >> Her

Re: [DBI-Users] Fwd: Problem to get UTF8-CSV-File

2011-12-22 Thread hermann schwärzler
hello ralf hello jens Jens Rehsack schrieb: [...] We have a problem. We want to get an UTF8-CSV-File from UTF8-Oracle-Database. It seems to be that the CSV-File is always charset "latin-1". What can we do to get UTF-8-File? Here is our Testscript. #-- our

Fwd: Problem to get UTF8-CSV-File

2011-12-22 Thread Jens Rehsack
-- Weitergeleitete Nachricht -- Von: Ralf Eiteljörge Datum: 21. Dezember 2011 14:06 Betreff: Problem to get UTF8-CSV-File An: rehs...@cpan.org Hallo, We have a problem. We want to get an UTF8-CSV-File from UTF8-Oracle-Database. It seems to be that the CSV-File is always charset

Re: Problem with Oracle collections/objects

2011-12-13 Thread Martin J. Evans
xactly what you mean. This I could see as a problem as some one who wants 'CAST' to work will find it doesn't which is bad. Though with embeded objects you have no need to use them. Will have to put in some code someplace to detect these new sql commands and ignor the built in DB

RE: Problem with Oracle collections/objects

2011-12-13 Thread John Scoles
well so in the end it gets muddleded. The CAST and crew doing its work on the back end my DBD::ORacle code playing about in the front. This I could see as a problem as some one who wants 'CAST' to work will find it doesn't which is bad. Though with embeded objects you have no n

RE: Problem with Oracle collections/objects

2011-12-13 Thread John Scoles
tin.ev...@easysoft.com; dbi-...@perl.org > CC: dbi-users@perl.org > Subject: RE: Problem with Oracle collections/objects > Date: Sun, 11 Dec 2011 12:00:12 -0500 > > > Well I wrote the code in DBD::Oracle for embedded objectes/types so I am the > one to blame for that. From the SQL and co

RE: Problem with Oracle collections/objects

2011-12-11 Thread John Scoles
> CC: dbi-users@perl.org > Subject: Problem with Oracle collections/objects > > Hi, > > If anyone is around who wrote or has worked on the object/collections support > in DBD::Oracle I'd greatly appreciate it if you could take a quick look at > this problem as the cod

Problem with Oracle collections/objects

2011-12-09 Thread Martin J. Evans
Hi, If anyone is around who wrote or has worked on the object/collections support in DBD::Oracle I'd greatly appreciate it if you could take a quick look at this problem as the code in DBD::Oracle for this has defeated me so far. The problem is I have a query which uses types and collec

Re: Problem with DBD

2011-11-15 Thread Michael Ludwig
Raaz Nepz schrieb am 15.11.2011 um 00:30 (+): > DBD::WMI initialisation failed: Can't locate object method "driver" > via package "DBD::WMI" at C:/Perl/lib/DBI.pm line 815.Perhaps the > capitalisation of DBD 'wmi' isn't right. at usb2.pl line 6 perl -MDBD::WMI -e1 If "Can't locate DBD/WMI.pm

Re: Problem with DBD

2011-11-15 Thread Developer at Deeturagit
apitalisation of DBD 'wmi' isn't right. at usb2.pl line 6 I tried to look for every possible way to solve the issue. But, I couldn't find any help. If anyone out there can help me, that would be great. Raj Do you have DBD::WMI installed, I suspect that this is the problem, si

Problem with DBD

2011-11-15 Thread Raaz Nepz
Hi, I am using module DBD::WMI for my project. I got this error message. DBD::WMI initialisation failed: Can't locate object method "driver" via package "DBD::WMI" at C:/Perl/lib/DBI.pm line 815.Perhaps the capitalisation of DBD 'wmi' isn't right. at usb2.pl line 6 I tried to look for every poss

Build Problem with DBD::mysql and mingw

2011-08-21 Thread René Nyffenegger
Hello all I have tried to build DBD::mysql with mingw and had a bit of frustration to do so since I didn't achieve what I wanted at first. After a few trial and errors, I managed to build it by manualle removing "-Wl,--image-base,0x157" at the linking stage. Now, I have no idea why that is

Re: Problem: given a dbh, extract the original args passed to connect()

2011-04-11 Thread Tim Bunce
that wraps the dbh. (DBIx::Connector > adds transaction, savepoint, and reconnect logic to DBI). > > The problem is, in order to add this feature, I need the original args that > were passed to connect() when creating the dbh. The reason is that > DBIx::Connector will need to constr

Re: Global destruction problem in Perl

2011-04-08 Thread Michael Ludwig
vinay parakoti schrieb am 06.04.2011 um 15:29 (+0530): > > We have an application that is running on IIS 6.0 with Perl (v5.6.1) > as front end and SQL 2000 as back end. DB is located in another > server. 5.6.1 appears antediluvian. > In new server, customer wants to use latest verstions of softw

Problem: given a dbh, extract the original args passed to connect()

2011-04-07 Thread Quinn Weaver
DBI). The problem is, in order to add this feature, I need the original args that were passed to connect() when creating the dbh. The reason is that DBIx::Connector will need to construct the dbh anew if it gets disconnected. However, I can't find a way to get those args out of the dbh. N

Re: Global destruction problem in Perl

2011-04-06 Thread vinay parakoti
estion was a long shot, based solely on some similarities with > errors I had seen. > > You need to mention what database you're using, the version, and if you > can, a short code example illustrating the problem. > > And send it to the list, there's a much better chance of get

Re: Global destruction problem in Perl

2011-04-05 Thread Bob McGowan
recent DBD version or whether it was built against the current DB or the old one. My suggestion was a long shot, based solely on some similarities with errors I had seen. You need to mention what database you're using, the version, and if you can, a short code example illustrating the problem.

Global destruction problem in Perl

2011-03-28 Thread vinay parakoti
move the application to a new server. This time infra has decided to give us latest versions. Now the new server has IIS 7.0, Perl v5.12.3 Most of my application is working fine. However we are facing a problem with respect to global destruction. In my code, I am trying to update database

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

2011-02-18 Thread Mark Bergeron
t me going in the right direction. I have to re-build this app. From: "Bobak, Mark" To: John Scoles Cc: "dbi-users@perl.org" Sent: Fri, February 18, 2011 10:56:27 AM Subject: RE: Problem with UTF8 and array binding Tired the NVARCHAR2,

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

2011-02-18 Thread Furst, Carl
m#UTF-8_vs._utf8_vs._UT F8 Thanks, Carl Furst o/~ What a difference a byte makes... o/~ -Original Message- From: Bobak, Mark [mailto:mark.bo...@proquest.com] Sent: Friday, February 18, 2011 11:56 AM To: Nelson, Erick [HDS]; dbi-users@perl.org Subject: RE: Problem with UTF8 and arr

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

2011-02-18 Thread Bobak, Mark
Tired the NVARCHAR2, it had no effect. -Original Message- From: John Scoles [mailto:sco...@pythian.com] Sent: Friday, February 18, 2011 7:03 AM To: Bobak, Mark Cc: dbi-users@perl.org Subject: Re: Problem with UTF8 and array binding On 17/02/2011 4:38 PM, Bobak, Mark wrote: Sorry

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

2011-02-18 Thread Bobak, Mark
bruary 17, 2011 5:19 PM To: dbi-users@perl.org Subject: RE: Problem with UTF8 and array binding I had this problem quite awhile ago with an old Oracle 9.2 database. I don't remember why but the solution involved setting a couple of environment vars. Looking back at those ancient, no lo

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

2011-02-18 Thread Nelson, Erick [HDS]
I had this problem quite awhile ago with an old Oracle 9.2 database. I don't remember why but the solution involved setting a couple of environment vars. Looking back at those ancient, no longer used, problems I see $ENV{NLS_LANG} = "american_america.we8iso8859p1"; $ENV{OR

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

2011-02-18 Thread John Scoles
On 17/02/2011 4:38 PM, Bobak, Mark wrote: Sorry Mark I saw that PI_CIBD_CODE_TAB was a clob so that is where I though you where having your problem. There is such a thing as a nvarchar never used it myself perhaps that will help. Sorry, but I'm not sure I understand the suggestion.

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

2011-02-17 Thread Bobak, Mark
type mentioned above... I don't see how/where NCLOB fits into the picture? -Mark -Original Message- From: John Scoles [mailto:sco...@pythian.com] Sent: Thursday, February 17, 2011 4:10 PM To: dbi-users@perl.org Subject: Re: Problem with UTF8 and array binding On 17/02/2011 3:05

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

2011-02-17 Thread John Scoles
On 17/02/2011 3:05 PM, Bobak, Mark wrote: Perhaps you have to declare you in type as a NCLOB?? Cheers John Hi all, I'm running into a 'PLS-00418: array bind type must match PL/SQL table row type' error, but only when passing UTF8 data. The details are as follows. I have a PL/SQL packaged f

Problem with UTF8 and array binding....

2011-02-17 Thread Bobak, Mark
Hi all, I'm running into a 'PLS-00418: array bind type must match PL/SQL table row type' error, but only when passing UTF8 data. The details are as follows. I have a PL/SQL packaged function that looks like this: FUNCTION MSTInsUpdCIT( PI_CGP_ID IN VARCHAR2 ,PI_CBL_ID

Re: Downside to ora_envhp=>0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

2011-01-27 Thread Bill Ward
normally an environment will not die unless you loose > >>>> connectivity. If > >>>> you have lost connectivity then there would not be much point in > trying > >>>> to > >>>> reconnect automatically your network or DB is Down?? > >>>

Re: Downside to ora_envhp=>0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

2011-01-27 Thread John Scoles
y then there would not be much point in trying >>>> to >>>> reconnect automatically your network or DB is Down?? >>>> >>> Databases go down sometimes. There could be a power failure or >>> hardware crash, or maybe the DB is just being bounced by

Re: Downside to ora_envhp=>0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

2011-01-27 Thread Bill Ward
n there would not be much point in trying >>> to >>> reconnect automatically your network or DB is Down?? >>> >> Databases go down sometimes. There could be a power failure or >> hardware crash, or maybe the DB is just being bounced by the DBAs >> after making a configur

Re: Downside to ora_envhp=>0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

2011-01-27 Thread John Scoles
just being bounced by the DBAs after making a configuration change or upgrade. The problem is even if the database comes back up, it still keeps generating the same error. Why should I also have to manually restart the Apache server just because the database has come back online? That's odd

Re: Downside to ora_envhp=>0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

2011-01-26 Thread Tim Heath
On 01/26/2011 02:27 PM, John Scoles wrote: On 25/01/2011 8:21 PM, William Ward gmail wrote: In regards to this thread: http://www.mail-archive.com/dbi-users@perl.org/msg32115.html (found via google) I'm having the same problem at $JOB and before we throw ora_envhp=>0 into our connect a

Re: Downside to ora_envhp=>0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

2011-01-26 Thread Bill Ward
the DB is just being bounced by the DBAs after making a configuration change or upgrade. The problem is even if the database comes back up, it still keeps generating the same error. Why should I also have to manually restart the Apache server just because the database has come back online? dbi->c

Re: Downside to ora_envhp=>0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

2011-01-26 Thread John Scoles
On 25/01/2011 8:21 PM, William Ward gmail wrote: In regards to this thread: http://www.mail-archive.com/dbi-users@perl.org/msg32115.html (found via google) I'm having the same problem at $JOB and before we throw ora_envhp=>0 into our connect attribute, we were wondering if this wi

Re: Downside to ora_envhp=>0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

2011-01-26 Thread Martin J. Evans
On 26/01/11 01:21, William Ward gmail wrote: > In regards to this thread: > http://www.mail-archive.com/dbi-users@perl.org/msg32115.html > (found via google) > > I'm having the same problem at $JOB and before we throw ora_envhp=>0 > into our connect attribute, we were wo

Downside to ora_envhp=>0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

2011-01-25 Thread William Ward gmail
In regards to this thread: http://www.mail-archive.com/dbi-users@perl.org/msg32115.html (found via google) I'm having the same problem at $JOB and before we throw ora_envhp=>0 into our connect attribute, we were wondering if this will cause performance issues? Is there a downside to o

Re: Potential problem with DBD::Oracle

2011-01-13 Thread Martin J. Evans
>>> [3][] len=2 >>> >>> As you can see, even though the data in $txt looks correct, perl thinks the >>> internal length of the variable is whatever it was after fetching the first >>> row. This screws up things like sprintf. >>> >>> I

Re: Potential problem with DBD::Oracle

2011-01-13 Thread Martin J. Evans
ntf. >> >> I'm pretty sure this behaviour is a DBD::Oracle thing rather than a DBI >> thing. I tried an equivalent script with DBD::SQLite and DBD::mysql and >> they both returned the length correctly (imo). >> >> This behaviour exists in 1.23 and 1.26. I have

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

2010-12-21 Thread Furst, Carl
10 11:13 AM To: dbi-users@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

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

2010-12-21 Thread John Scoles
obs, so it has me worried. I'll keep y'all posted. Thanks, Carl Furst CMS Developer MLB Advanced Media -Original Message- From: John Scoles [mailto:sco...@pythian.com] Sent: Tuesday, December 21, 2010 8:51 AM To: dbi-users@perl.org Subject: Re: DBD::Oracle, 10g Lob Refetch problem

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

2010-12-21 Thread Furst, Carl
MLB Advanced Media -Original Message- From: John Scoles [mailto:sco...@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

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

2010-12-21 Thread John Scoles
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 trouble since day one. The biggest problem is that we are having a problem writing LOB fields. We get the following

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

2010-12-21 Thread Martin J. Evans
On 21/12/10 09:18, Michael Ludwig wrote: > Martin J. Evans schrieb am 21.12.2010 um 09:03 (+): > >> e.g. for my database here with a SID of "devel" where the database is >> running on betoracle.easysoft.local and my user is fred/password I do: >> >> export ORACLE_USERID=fred/password > > Mino

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

2010-12-21 Thread Michael Ludwig
Martin J. Evans schrieb am 21.12.2010 um 09:03 (+): > e.g. for my database here with a SID of "devel" where the database is > running on betoracle.easysoft.local and my user is fred/password I do: > > export ORACLE_USERID=fred/password Minor correction for TWO_TASK: > export TWO_TASK=//beto

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

2010-12-21 Thread Martin J. Evans
ng 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: ORA-00903: invalid table name (DBD > ERROR: OCIStmtExecute/LOB refetch) An example of the code and the schema fo

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

2010-12-20 Thread Furst, Carl
rs@perl.org Subject: Re: DBD::Oracle, 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

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

2010-12-20 Thread Michael Ludwig
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. (And then on to 5.10.1, and 5.12.2, if you

DBD::Oracle, 10g Lob Refetch problem

2010-12-20 Thread Furst, Carl
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: Potential problem with DBD::Oracle

2010-11-18 Thread John Scoles
On 18/11/2010 3:15 PM, Steve Baldwin wrote: Ok one more to look at for DBD::Oracle 1.28 Hi, I ran across an issue recently that appears to have existed for quite some time. Consider the following script ... #!/usr/bin/perl -w use strict; use warnings; use DBI; sub main { my $dbh = DBI->

Re: Potential problem with DBD::Oracle

2010-11-18 Thread Martin J. Evans
On 18/11/2010 20:15, Steve Baldwin wrote: Hi, I ran across an issue recently that appears to have existed for quite some time. Consider the following script ... #!/usr/bin/perl -w use strict; use warnings; use DBI; sub main { my $dbh = DBI->connect( 'dbi:Oracle:', 'usr/

Potential problem with DBD::Oracle

2010-11-18 Thread Steve Baldwin
Hi, I ran across an issue recently that appears to have existed for quite some time. Consider the following script ... #!/usr/bin/perl -w use strict; use warnings; use DBI; sub main { my $dbh = DBI->connect( 'dbi:Oracle:', 'usr/p...@conn', '', { PrintError =>

Re: perl problem in solaris 5.10

2010-11-09 Thread John D Groenveld
In message , SOMN ATH GANGULY writes: >ora...@prdcmw > perl TablespaceFree.pl >Can't locate DBI.pm in @INC (@INC contains: Where did you install DBI and DBD::Oracle? John groenv...@acm.org

perl problem in solaris 5.10

2010-11-05 Thread SOMNATH GANGULY
Hi , while i am executing the file TablespaceFree.pl i am getting the problem ora...@prdcmw > uname -a SunOS ulscmetl02.uls-prod.com 5.10 Generic_142900-03 sun4u sparc SUNW,Sun-Fire-V490 ora...@prdcmw > ora...@prdcmw > perl TablespaceFree.pl Can't locate DBI.pm in @INC (@INC

Re: FW: DBI 1.6.15 problem on AIX 6.1 with perl 5.8.8 64bit

2010-10-11 Thread Jens Rehsack
k [mailto:rehs...@googlemail.com] > Sent: Friday, October 08, 2010 12:07 PM > To: Martin J. Evans > Cc: Hatala, Michael ; Jens Rehsack; dbi-users@perl.org > Subject: Re: FW: DBI 1.6.15 problem on AIX 6.1 with perl 5.8.8 64bit > > On 10/08/10 14:57, Martin J. Evans wrote: >> On

RE: FW: DBI 1.6.15 problem on AIX 6.1 with perl 5.8.8 64bit

2010-10-08 Thread Hatala, Michael
N is up to date (1.9402). File::Which is up to date (1.09). Thanks, Mike -Original Message- From: Jens Rehsack [mailto:rehs...@googlemail.com] Sent: Friday, October 08, 2010 12:07 PM To: Martin J. Evans Cc: Hatala, Michael ; Jens Rehsack; dbi-users@perl.org Subject: Re: FW: DBI 1.6.15 probl

Re: FW: DBI 1.6.15 problem on AIX 6.1 with perl 5.8.8 64bit

2010-10-08 Thread Jens Rehsack
On 10/08/10 14:57, Martin J. Evans wrote: On 08/10/10 15:25, Hatala, Michael wrote: I don't have the prove command with this perl 5.8.8 64bit release. I'm assuming it's a byproduct of the perl installation(?) It is in Test::Harness which you already have but perhaps not new enough. On my Linux

Re: FW: DBI 1.6.15 problem on AIX 6.1 with perl 5.8.8 64bit

2010-10-08 Thread Martin J. Evans
10:06 AM > To: Hatala, Michael > Cc: Jens Rehsack; dbi-users@perl.org > Subject: Re: FW: DBI 1.6.15 problem on AIX 6.1 with perl 5.8.8 64bit > > On 08/10/10 14:06, Hatala, Michael wrote: >> Jens, thanks for the promt response. It apperas that the command you > gave me just

Re: FW: DBI 1.6.15 problem on AIX 6.1 with perl 5.8.8 64bit

2010-10-08 Thread Martin J. Evans
imited http://www.easysoft.com > -Original Message- > From: Jens Rehsack [mailto:rehs...@googlemail.com] > Sent: Friday, October 08, 2010 3:36 AM > To: Hatala, Michael > Cc: dbi-users@perl.org > Subject: Re: FW: DBI 1.6.15 problem on AIX 6.1 with perl 5.8.8 64bit > >

RE: FW: DBI 1.6.15 problem on AIX 6.1 with perl 5.8.8 64bit

2010-10-08 Thread Hatala, Michael
ts Thanks, Mike Hatala -Original Message- From: Jens Rehsack [mailto:rehs...@googlemail.com] Sent: Friday, October 08, 2010 3:36 AM To: Hatala, Michael Cc: dbi-users@perl.org Subject: Re: FW: DBI 1.6.15 problem on AIX 6.1 with perl 5.8.8 64bit 2010/10/8 Hatala, Michael : > Well I can&#

Re: Problem compiling DBD::Oracle on FreeBSD with Oracle 10g Instant Client

2010-10-08 Thread Eric Yellin
On 05/10/2010 17:44, Scott T. Hildreth wrote: On Sun, 2010-10-03 at 18:45 +0200, Eric Yellin wrote: Hi, I am trying to compile DBD::Oracle that will work with Oracle 10g on FreeBSD 6.3 Eric, Are you compiling a linux Perl? It won't work with out it. I have the port emulators/linux_di

Re: FW: DBI 1.6.15 problem on AIX 6.1 with perl 5.8.8 64bit

2010-10-08 Thread Jens Rehsack
le-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT >                        PERL_MALLOC_WRAP USE_64_BIT_ALL USE_64_BIT_INT >                        USE_ITHREADS USE_LARGE_FILES USE_PERLIO >                        USE_REENTRANT_API >  Built under aix >  Compiled at Jun  3 2009 12:34:41

FW: DBI 1.6.15 problem on AIX 6.1 with perl 5.8.8 64bit

2010-10-07 Thread Hatala, Michael
/5.8.8/aix-thread-multi-64all /usr/opt/perl5/lib64/5.8.8 /usr/opt/perl5/lib64/site_perl/5.8.8/aix-thread-multi-64all /usr/opt/perl5/lib64/site_perl/5.8.8 /usr/opt/perl5/lib64/site_perl -Original Message- From: Hatala, Michael Sent: Thursday, October 07, 2010 6:07 PM To: &#

Re: Problem compiling DBD::Oracle on FreeBSD with Oracle 10g Instant Client

2010-10-05 Thread Scott T. Hildreth
On Sun, 2010-10-03 at 18:45 +0200, Eric Yellin wrote: > > Hi, > > > I am trying to compile DBD::Oracle that will work with Oracle 10g on > FreeBSD 6.3 > > Eric, Are you compiling a linux Perl? It won't work with out it. I have the port emulators/linux_dist-gentoo-stage3 installed. Wit

Re: Problem compiling DBD::Oracle on FreeBSD with Oracle 10g Instant Client

2010-10-05 Thread John Scoles
On 10/5/2010 3:58 AM, Martin J. Evans wrote: On 03/10/10 17:45, Eric Yellin wrote: Hi, I am trying to compile DBD::Oracle that will work with Oracle 10g on FreeBSD 6.3 Here is what I have done so far: 1. Installed the 3 Oracle Instant Client ports: - linux-oracle-instantclient-basic - li

Re: Problem compiling DBD::Oracle on FreeBSD with Oracle 10g Instant Client

2010-10-05 Thread Martin J. Evans
On 03/10/10 17:45, Eric Yellin wrote: > > > Hi, > > > I am trying to compile DBD::Oracle that will work with Oracle 10g on > FreeBSD 6.3 > > > Here is what I have done so far: > > 1. Installed the 3 Oracle Instant Client ports: > > - linux-oracle-instantclient-basic > - linux-oracle-instant

Re: Problem compiling DBD::Oracle on FreeBSD with Oracle 10g Instant Client

2010-10-04 Thread John Scoles
On 10/3/2010 12:45 PM, Eric Yellin wrote: I have yet to try an build DBD::Oracle for FreeBSD so the Makefile might not be working correctly here are my comments Hi, I am trying to compile DBD::Oracle that will work with Oracle 10g on FreeBSD 6.3 Here is what I have done so far: 1. I

Problem compiling DBD::Oracle on FreeBSD with Oracle 10g Instant Client

2010-10-03 Thread Eric Yellin
Hi, I am trying to compile DBD::Oracle that will work with Oracle 10g on FreeBSD 6.3 Here is what I have done so far: 1. Installed the 3 Oracle Instant Client ports: - linux-oracle-instantclient-basic - linux-oracle-instantclient-sdk - linux-oracle-instantclient-sqlplus These install as

Re: DBI->data_sources("Pg") problem

2010-09-21 Thread Laslo Forro
Thanx for you concern, the problem was with my installation. I have reinstalled everything system-wide perl-related, made the symlinks check, and reinstalled DBI and DBD::Pg, now all is fine. Thank you again! Yours Laslo On Tue, Sep 21, 2010 at 6:59 PM, Laslo Forro wrote: > I do not h

Re: DBI->data_sources("Pg") problem

2010-09-21 Thread Laslo Forro
I do not have DBI_DSN set but I use "dbi:Pg:database=whatever". I receive no error message, simply nothing. I am digging deeper for DBI or Pg - do not know yet - drops a segfault in a tested piece of code, so perhaps the problem is somewhere in the dark corners of the Earth. On Tue, Se

Re: DBI->data_sources("Pg") problem

2010-09-21 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > No, it doesn't work even after connecting the db. > > DBI: 1.614 > DBD::Pg: 2.17 > Postgresql: 8.4.4 What error does it give? Are you sure that your environment parameters are correct (e.g. DBI_DSN)? You might try specifying the information

Re: DBI->data_sources("Pg") problem

2010-09-21 Thread Laslo Forro
gt; However, this piece of code gives nothing: > > my @dbs=DBI->data_sources("Pg)"; > > Works fine for me (once the quoting problem is fixed). What > version of DBI and DBD::Pg do you have? > > Does it work if you connect to a Postgres database first, > and th

Re: DBI->data_sources("Pg") problem

2010-09-20 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > However, this piece of code gives nothing: > my @dbs=DBI->data_sources("Pg)"; Works fine for me (once the quoting problem is fixed). What version of DBI and DBD::Pg do you have? Does it work if you connect to a Post

DBI->data_sources("Pg") problem

2010-09-20 Thread Laslo Forro
Hi there, I am trying to get the databases from a running PostgreSQL database. However, this piece of code gives nothing: my @dbs=DBI->data_sources("Pg)"; I tried to trace the situation and ended up here in DBI module: DBD::Pg::dr::data_sources(/home/salmonix/perl5/lib/perl5/x86_64-linux-thread-mu

PROBLEM : Insert into a table with a LOB column over synonym on HP-UX

2010-09-17 Thread kris . lemaire
=403d0488,value_sz=4,dty=104,indp=0,alenp=0,rcodep=0,maxarr_len=0,curelep=0 (*=0),mode=0)=SUCCESS lob refetch 1 for ':opatchinfo' param: ftype 112 setup OCIDefineByPos (40369710,7fffea88,40363930,1,40032e10,-1,112,403df280,0,403df2c0,0)=SUCCESS OCIAttrGet(4036c7d0,OCI_

Re: Reg DBI Problem

2010-09-07 Thread Peter J. Holzer
On 2010-09-06 17:50:44 +0530, Raghavendra Kalimisetty wrote: > Hope you will provide solution to our problem. > > We have recently moved from Oracle 10g to Oracle 11g. Now we are facing an > issue when trying to connect to DB through Perl. > > Here is the error we got: >

RE: Reg DBI Problem

2010-09-06 Thread John Scoles
rebuild DBI and DBD::Oracle with your new Oracle enviornment. Post the results of the Perl Makefile.pl and the make install. That would be the first thing I would try Cheers John Scoles > To: dbi-users@perl.org > Subject: Reg DBI Problem > From: raghavendra.kalimise...@tcs.c

Reg DBI Problem

2010-09-06 Thread Raghavendra Kalimisetty
Hi , Hope you will provide solution to our problem. We have recently moved from Oracle 10g to Oracle 11g. Now we are facing an issue when trying to connect to DB through Perl. Here is the error we got: DBI connect('host=localhost;sid=omc','omcdbsys',...) failed:

Re: Problem at finding sybase open client library when installing DBD::Sybase

2010-07-08 Thread John R Pierce
ld. The easiest way to do this is to source the SYBASE.sh/SYBASE.csh or SYBASE.bat file in the root directory of the Sybase installation you want to use." May be that's about my problem but I don't understand how to do this. I am totally new to this and perl as well could someone p

  1   2   3   4   5   6   7   8   9   10   >