Re: PERL - DBI MODULE

The closest thing to what you ask that is actually useful is to install DBD::SQLite. While this is a DBD, it includes the database engine so you have full DBI functionality without needing to have a separate database server. -- Darren Duncan On 2020-06-02 9:35 p.m., Pramod Mv wrote: Hello

Re: PERL - DBI MODULE

On Thu, Jun 4, 2020 at 13:32 Pramod Mv wrote: > Could you please let me know how to use the DBI module without a DBD > module installed ? . can you suggest any alternative. > For most practical purposes, you can't use the DBI without a DBD module — it's reason for existing is to provide a

Re: Perl DBI libraries for connecting 12c

In message , Christopher Jones writes: >For the record, Instant Client is available in Solaris packages: https://blogs >.oracle.com/jmcp/oracle-instant-client:-now-available-in-ips Have you noticed that Oracle ships 12.2 Instant Client but only

Re: Perl DBI libraries for connecting 12c

On 10/10/17 3:42 pm, John R Pierce wrote: On 10/9/2017 6:32 PM, Lincoln A Baxter wrote: You can solve this problem by building your own perl with gcc. It's not that hard. After build, install it in a location on path (actually you pick the install location has part of configuring the

Re: Perl DBI libraries for connecting 12c

On 10/10/17 00:07, Bruce Johnson wrote: On Oct 9, 2017, at 3:52 PM, John R Pierce wrote: On 10/9/2017 2:49 PM, Furst, Carl wrote: 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

Re: Perl DBI libraries for connecting 12c

On 10/9/2017 6:32 PM, Lincoln A Baxter wrote: You can solve this problem by building your own perl with gcc. It's not that hard. After build, install it in a location on path (actually you pick the install location has part of configuring the build). Then you can build the DBI, and DBD::oracle.

Re: Perl DBI libraries for connecting 12c

On Mon, 2017-10-09 at 15:52 -0700, John R Pierce wrote: > On 10/9/2017 2:49 PM, Furst, Carl wrote: > > 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

Re: Perl DBI libraries for connecting 12c

> On Oct 9, 2017, at 3:52 PM, John R Pierce wrote: > > On 10/9/2017 2:49 PM, Furst, Carl wrote: >> 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

Re: Perl DBI libraries for connecting 12c

On 10/9/2017 2:49 PM, Furst, Carl wrote: 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. as I recall, to use CPAN and build modules

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:

RE: perl DBI errors

Sorry to say, but you are into a mini-project to get things working again. From past experience, IBM tends to make a minimalistic version of Perl available to you by default with AIX. So your original error messages were telling you that the modules your program requires are not part of the

RE: Perl DBI Hangs while execute()

There are many things you can do in sqlplus that you cannot do in sql (in this case DBI). What are you trying to run? -Original Message- From: amaresh pothnal [mailto:amaresh.poth...@gmail.com] Sent: Monday, November 19, 2012 3:29 AM To: dbi-users@perl.org Subject: Perl DBI Hangs while

Re: Perl DBI Hangs while execute()

Thanks For your support. This issue got solved after installation of nls libraries. Thanks Amaresh On Wed, Nov 21, 2012 at 5:53 AM, John Scoles byter...@hotmail.com wrote: Well I would do something like select 1 from dual rather thatn '*' It sounds like your DB coonection string is not

RE: Perl DBI Hangs while execute()

Well I would do something like select 1 from dual rather thatn '*' It sounds like your DB coonection string is not correct. Cheers From: amaresh.poth...@gmail.com Date: Mon, 19 Nov 2012 16:59:09 +0530 Subject: Perl DBI Hangs while execute() To: dbi-users@perl.org Hi All,

RE: perl-dbi #temp table created using handle not accessible when accessed via -do() with the same handle

Maybe it just doesn't like the # character in the table name. -Will -Original Message- From: Anantharaman Sekaripuram, Gopalakrishnan [mailto:gopalakrishnan.sekaripuram.ananthara...@deshaw.com] Sent: 4 August 2011 08:57 To: dbi-users@perl.org Subject: perl-dbi #temp table created

Re: perl-dbi #temp table created using handle not accessible when accessed via -do() with the same handle

On 04/08/11 13:57, Anantharaman Sekaripuram, Gopalakrishnan wrote: Hi DBI-users, I am facing this problem perl DBD::ODBC rollback ineffective with AutoCommit enabled athttp://stackoverflow.com/questions/6938036/perl-dbdodbc-rollback-ineffective-with-autocommit-enabled-at and while looking at

Re: RE: perl DBI Oracle NCLOB fetching

Betreff: RE: perl DBI Oracle NCLOB fetching That only ocures when the nclob going in is not compatiable with the nclob field you are trying to stuff it into. one thing that wil give us a little more info is to connect with dbd_verbose=9 on the attributes and that will tell us you NSL

RE: perl DBI Oracle NCLOB fetching

but you will get a whold lot more tracing Cheers John Date: Mon, 6 Jun 2011 10:57:24 +0200 From: y...@mailueberfall.de Subject: Re: RE: perl DBI Oracle NCLOB fetching To: byter...@hotmail.com; dbi-users@perl.org Hello, setting dbd_verbose leads to no additional output. It's only: DBD

RE: perl DBI Oracle NCLOB fetching

That only ocures when the nclob going in is not compatiable with the nclob field you are trying to stuff it into. one thing that wil give us a little more info is to connect with dbd_verbose=9 on the attributes and that will tell us you NSL setting. also get your DBA to check

Re: Perl, DBI, DBD and MYSQL versions

We are using following versions - MySql - 5.1.52 Perl- 5.12.2 DBI - DBI-1.615 DBD - DBD-mysql-4.018 Is this combination correct? All up-to-date stable releases, so I'd consider it very good. -- Michael Ludwig

Re: Perl DBI sets $SIG{PIPE} to 'IGNORE'

On 07/28/2010 05:53 PM, Stuart Cooper wrote: Hi Damian, my $first_line = `grep -v '#' $filename|head -n 1`; # to get the first non-comment line --extra code deleted-- It's a broken pipe because the right side of it is not valid. Could you elaborate on why? I tried it and it worked for

Re: Perl DBI sets $SIG{PIPE} to 'IGNORE'

damian keefe wrote: I'm no software engineer, but given that it is known that some of the libraries used by DBI 'mess with' signal dispositions in apparently unknown ways, would it not make sense for DBI.pm to preserve the state of %SIG on entry and reinstate it on disconnect/END/EXIT cheers

Re: Perl DBI sets $SIG{PIPE} to 'IGNORE'

I'm no software engineer, but given that it is known that some of the libraries used by DBI 'mess with' signal dispositions in apparently unknown ways, would it not make sense for DBI.pm to preserve the state of %SIG on entry and reinstate it on disconnect/END/EXIT cheers Damian On 28

Re: Perl DBI sets $SIG{PIPE} to 'IGNORE'

Hi Damian, my $first_line = `grep -v '#' $filename|head -n 1`; # to get the first non-comment line the shell which is invoked inherits the SIGPIPE = 'IGNORE' state. This causes a grep: writing output: Broken pipe error as the grep tries to write to the head process which has exited. head

Re: Perl DBI and DBD::Oracle compatibility with perl, v5.6.1

Subhasis Gorai wrote: Hi, I just wanted to know what is the compatible version of DBI and Oracle DBD for perl, v5.6.1? It would be great if you can provide me with the information as soon as possible since it's very urgent. Thanks a lot for your time! Regards, Subhasis.

Re: Perl DBI and DBD::Oracle compatibility with perl, v5.6.1

Martin Evans wrote: Subhasis Gorai wrote: Hi, I just wanted to know what is the compatible version of DBI and Oracle DBD for perl, v5.6.1? It would be great if you can provide me with the information as soon as possible since it's very urgent. Thanks a lot for your time!

Re: PERL DBI ORACLE DATABASE OUTPUT TO A FILE

Requests for help with something that do not work are usually accompanied by relevant information: Platform versions error messages I did not see any of those in the post. Please see this article, it will prove to be quite valuable to you: http://catb.org/~esr/faqs/smart-questions.html

RE: PERL DBI ORACLE DATABASE OUTPUT TO A FILE

I like using Text::CSV_XS for this sort of thing. If your columns in your select are ordered properly you could try the following. use Text::CSV_XS; use IO::File; my $csv = Text::CSV_XS-new({binary=1, eol=$/, always_quote=1}); my $fh = IO::File-new(somefile.csv); if(defined $fh){ my $sth

Re: PERL DBI ORACLE DATABASE OUTPUT TO A FILE

On May 11, 2010, at 12:25 PM, tech422 wrote: Hi, I am trying to query an Oracle database and output the results to a file using PERL but its not working. I have tried 2 approaches. 1 uses bind the other does not. Could you please advise? This is my usual route: while

Re: Perl, DBI and encoding problem

Alex Bernier wrote: Hello, I use DBI 1.605, the DBD MySQL driver 4.007, Perl 5.10.0, MySQL 5.1.41 (on a Debian Lenny). Here is my script : script use DBI; $DB_name= 'xxx'; $DB_user= 'xxx'; $DB_pwd = 'xxx'; my $dbh; $dbh =

Re: Perl DBI Oracle SYSDBA help/advise please:

Thanks Jared ... It must be the DBI and DBD version then On Fri, Feb 12, 2010 at 1:34 PM, Jared Still jkst...@gmail.com wrote: On Wed, Feb 10, 2010 at 4:21 PM, newbie01 perl newbie01.p...@gmail.comwrote: Hi all, To anyone who had been using Perl DBI and Oracle, can you please confirm if

Re: Perl DBI Oracle SYSDBA help/advise please:

On Wed, Feb 10, 2010 at 4:21 PM, newbie01 perl newbie01.p...@gmail.comwrote: Hi all, To anyone who had been using Perl DBI and Oracle, can you please confirm if connection by SYSDBA works or doesn't? Works for me RH Linux EL 4 Oracle 10.2.0.4 Perl v5.8.8 DBD::Oracle 1.23 use

RE: Perl DBI and DBD::ODBC for Oracle on Windows

Hello 1) By adding sid= in the DSN, you should be able to point to the correct SID. So in your case : my $DSN = 'driver={Microsoft ODBC for Oracle};server=10.1.6.9:1521;sid=XX;uid=oradbuser;pwd=oradbpassword;'; 2) You should not use Microsoft ODBC for Oracle that is a very old driver,

Re: Perl DBI and DBD::ODBC for Oracle on Windows

- Original Message From: pmonsch...@groupe-casino.fr pmonsch...@groupe-casino.fr To: my600...@yahoo.com; dbi-users@perl.org Sent: Tuesday, July 28, 2009 9:21:02 AM Subject: RE: Perl DBI and DBD::ODBC for Oracle on Windows Hello 1) By adding sid= in the DSN, you should be able

RE: perl dbi and RaiseError handling - is this a situations which won't raise an error?

occurred it will return undef. Regards, Tshimanga. -Original Message- From: Douglas Wilson [mailto:[EMAIL PROTECTED] Sent: Tuesday 02 December 2008 02:56 To: Larry W. Virden Cc: dbi-users@perl.org Subject: Re: perl dbi and RaiseError handling - is this a situations which won't

Re: perl dbi and RaiseError handling - is this a situations which won't raise an error?

On Mon, Dec 1, 2008 at 7:58 AM, Larry W. Virden [EMAIL PROTECTED] wrote: Now, when the PERSON_ID matches, the update occurs. When the PERSON_ID is not found, however, an error isn't raised. updating zero rows is not an error. you can detect it yourself with: my $rows = $sth-execute(); Then

Re: Perl - DBI - DBD - Oracle - Solaris

Yes you have to have an Oracle client to get it to DBI DBD to work Most people these days are using the Instant Client http://www.oracle.com/technology/software/tech/oci/instantclient/index.html I do not really know olite client light I guess it would worded cheers John Scoles Hi, I have a

Re: Perl+DBI question [C1]

On 2008-07-28 20:36:23 +0530, Srinivas KATTI wrote: I am working on perl assignment which is first perl code in our environment, i have come across following problem, pls if you could provide your expert consultansy it will be great help to me I am trying to use DBI in my program (simple

Re: Perl+DBI question [C1]

On Mon, Jul 28, 2008 at 08:36:23PM +0530, Srinivas KATTI wrote: Hi I am working on perl assignment which is first perl code in our environment, i have come across following problem, pls if you could provide your expert consultansy it will be great help to me I am trying to use DBI in

Re: Perl+DBI question [C1]

On Tue, Jul 29, 2008 at 6:05 PM, Tim Bunce [EMAIL PROTECTED] wrote: On Mon, Jul 28, 2008 at 08:36:23PM +0530, Srinivas KATTI wrote: Hi I am working on perl assignment which is first perl code in our environment, i have come across following problem, pls if you could provide your expert

Re: Perl+DBI question [NC]

-users@perl.org Subject Re: Perl+DBI question [C1] On Mon, Jul 28, 2008 at 8:06 AM, Srinivas KATTI [EMAIL PROTECTED] wrote: I am working on perl assignment which is first perl code in our environment, i have come across following problem, pls if you could provide your expert consultansy

Re: Perl+DBI question [NC]

Thanks a lot Tim, i am checking with Unix admin to do that and let's see once done Thanks again Regards Srinivas K [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/29/2008 06:05 PM To Srinivas KATTI/ia/[EMAIL PROTECTED] cc dbi-users@perl.org, [EMAIL PROTECTED] Subject Re: Perl+DBI question

Re: Perl+DBI question [C1]

On Tue, Jul 29, 2008 at 06:10:30PM +0530, Amit Saxena wrote: On Tue, Jul 29, 2008 at 6:05 PM, Tim Bunce [EMAIL PROTECTED] wrote: On Mon, Jul 28, 2008 at 08:36:23PM +0530, Srinivas KATTI wrote: I am working on perl assignment which is first perl code in our environment, i have come across

Re: Perl+DBI question [NC]

: referenced symbol not found Killed [EMAIL PROTECTED]:[/home/glrecdev/icrs] Please advise Thanks and Regards Srinivas Katti [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/29/2008 06:05 PM To Srinivas KATTI/ia/[EMAIL PROTECTED] cc dbi-users@perl.org, [EMAIL PROTECTED] Subject Re: Perl+DBI

Re: Perl+DBI question [C1]

On Mon, Jul 28, 2008 at 8:06 AM, Srinivas KATTI [EMAIL PROTECTED]wrote: I am working on perl assignment which is first perl code in our environment, i have come across following problem, pls if you could provide your expert consultansy it will be great help to me I am trying to use DBI in my

Re: perl dbi

On Thu, Jul 17, 2008 at 7:19 PM, gene golub [EMAIL PROTECTED] wrote: 1. how do you process procedures Often the same or nearly the same way you process other SQL statements. There are often examples in the DBD::* (whatever DBD you are using) documentation. 2. what if I have multiple select or

Re: perl DBI oracle and error ORA 06502

On Tue, 2008-03-18 at 14:06 -0700, Pompiliu wrote: ... $dbh-func(10, 'dbms_output_enable'); right after connect. The problem is that I am getting only part of the result and the error I am getting is ORA 06502. ORA-6502 is often the result of size mismatch between variables and

Re: perl DBI oracle and error ORA 06502

You might want to set the DB handles LongReadLen attribute to a higher values say 100 meg like this dbh-{LongReadLen} = 100*1024*1024 and then give it a try, That might work for you. Cheers John Scoles John Scoles wrote: It could be in perl but if this is the case I would need the exact

RE: perl DBI oracle and error ORA 06502

-Original Message- From: John Scoles [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2008 5:27 AM Cc: Pompiliu; dbi-users@perl.org Subject: Re: perl DBI oracle and error ORA 06502 You might want to set the DB handles LongReadLen attribute to a higher values say 100 meg like

Re: perl DBI oracle and error ORA 06502

Ah yes the APPLE][ error for those of us who are old enough to remember those things here is what the error code means *ORA-06502:*PL/SQL: numeric or value error /string/ *Cause:* An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if

Re: perl DBI oracle and error ORA 06502

It could be in perl but if this is the case I would need the exact procedure, schema, some data and the exact perl code that calls it. However to start please set the dbh-debug(6) before you call your code and send me the results. There might be a var that Perl is croaking on and this is one

RE: perl DBI on windows 64

: Friday, March 14, 2008 4:07 AM To: dbi-users@perl.org Subject: Re: perl DBI on windows 64 Ramakrishna Raju wrote: Alexander, t-SQL has a print command and lot of stored procs have print statements in the code to indicate progress of execution or whatever. I need to capture

RE: perl DBI on windows 64

:07 AM To: dbi-users@perl.org Subject: Re: perl DBI on windows 64 Ramakrishna Raju wrote: Alexander, t-SQL has a print command and lot of stored procs have print statements in the code to indicate progress of execution or whatever. I need to capture it and print that to my log

Re: perl DBI on windows 64

4:07 AM To: dbi-users@perl.org Subject: Re: perl DBI on windows 64 Ramakrishna Raju wrote: Alexander, t-SQL has a print command and lot of stored procs have print statements in the code to indicate progress of execution or whatever. I need to capture it and print that to my log

Re: perl DBI on windows 64

Alexander Foken wrote: On 13.03.2008 19:49, Ramakrishna Raju wrote: And now, I am looking for a web link or a short snippet that does robust error handling of SQL errors. Use the RaiseError DBI attribute, preferably during connect(). And how to process the output of sql print

Re: perl DBI on windows 64

] Sent: Thursday, March 13, 2008 12:28 PM To: dbi-users@perl.org Subject: Re: perl DBI on windows 64 Sorry for the mess of replying but for some reason my email client won't include your text when it was added after my signature. There are 2 odbc administrators - one you get to in the normal way

Re: perl DBI on windows 64

On 14.03.2008 09:46, Martin Evans wrote: Alexander Foken wrote: There is one annoyance with SQL server: You can't have more than one active statement, i.e. a statement that is executing but not yet finished, per connection. This is a limitation of the SQL server protocol, not a DBI

Re: perl DBI on windows 64

Easysoft Limited http://www.easysoft.com -Original Message- From: Alexander Foken [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 2:41 PM To: Ramakrishna Raju Cc: dbi-users@perl.org Subject: Re: perl DBI on windows 64 On 13.03.2008 19:49, Ramakrishna Raju wrote: And now

Re: perl DBI on windows 64

Alexander Foken wrote: On 14.03.2008 09:46, Martin Evans wrote: Alexander Foken wrote: There is one annoyance with SQL server: You can't have more than one active statement, i.e. a statement that is executing but not yet finished, per connection. This is a limitation of the SQL server

Re: perl DBI on windows 64

On 14.03.2008 11:48, Martin Evans wrote: Alexander Foken wrote: On 14.03.2008 09:46, Martin Evans wrote: Alexander Foken wrote: There is one annoyance with SQL server: You can't have more than one active statement, i.e. a statement that is executing but not yet finished, per connection.

RE: perl DBI on windows 64

4:07 AM To: dbi-users@perl.org Subject: Re: perl DBI on windows 64 Ramakrishna Raju wrote: Alexander, t-SQL has a print command and lot of stored procs have print statements in the code to indicate progress of execution or whatever. I need to capture it and print that to my log

Re: perl DBI on windows 64

It seems you don't have a valid ODBC data source named xxxsql01. If you are running your script from a web server, it has to be a system data source, else it may also be a user data source. And by the way: Are you sure you want to connect as sa? That account usually has too many privileges.

Re: perl DBI on windows 64

Ramakrishna Raju wrote: Hi, I am trying to connect to SQL Server 2005 on a windows 64bit machine from the same machine. And I get this error message: DBI connect(xxxsql01,'sa',...) failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver

RE: perl DBI on windows 64

:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 11:23 AM To: Ramakrishna Raju Cc: dbi-users@perl.org Subject: Re: perl DBI on windows 64 It seems you don't have a valid ODBC data source named xxxsql01. If you are running your script from a web server, it has to be a system data source, else it may

RE: perl DBI on windows 64

I applied the latest DBD-ODBC 1.15 version (Martin J Evans) and it still is a problem. Is there any fix or work around for this issue? Appreciate your time, Thanks, Ramakrishna Raju ( Raju ) [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Are you

Re: perl DBI on windows 64

Sorry for the mess of replying but for some reason my email client won't include your text when it was added after my signature. There are 2 odbc administrators - one you get to in the normal way through control panel, administrative tools, data sources (the 64 bit one) and one you have to go

RE: perl DBI on windows 64

[mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 12:28 PM To: dbi-users@perl.org Subject: Re: perl DBI on windows 64 Sorry for the mess of replying but for some reason my email client won't include your text when it was added after my signature. There are 2 odbc administrators - one you get

Re: perl DBI on windows 64

On 13.03.2008 19:49, Ramakrishna Raju wrote: And now, I am looking for a web link or a short snippet that does robust error handling of SQL errors. Use the RaiseError DBI attribute, preferably during connect(). And how to process the output of sql print statements. SQL does not

RE: perl DBI on windows 64

something together and then we can compare notes. Thanks, Ramakrishna Raju ( Raju ) [EMAIL PROTECTED] -Original Message- From: Alexander Foken [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 2:41 PM To: Ramakrishna Raju Cc: dbi-users@perl.org Subject: Re: perl DBI on windows 64

RE: Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my pain?

-Original Message- From: BAIER, ANTHONY (TONY), ATTSI [mailto:[EMAIL PROTECTED] Sent: Thursday, November 29, 2007 11:06 AM To: STILWELL, DAVID B (DAVE), ATTLABS; dbi-users@perl.org Subject: Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my

RE: Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my pain?

-Original Message- From: Jonathan Leffler [mailto:[EMAIL PROTECTED] Sent: Thursday, November 29, 2007 12:09 PM To: BAIER, ANTHONY (TONY), ATTSI Cc: STILWELL, DAVID B (DAVE), ATTLABS; dbi-users@perl.org Subject: Re: Perl DBI::prepare Question. My head is sore from banging it against

Re: Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my pain?

There's no solution to your problem below - there is some commentary that may, or may not, be of relevance. On Nov 29, 2007 8:06 AM, BAIER, ANTHONY (TONY), ATTSI [EMAIL PROTECTED] wrote: Can you take a quick look at the code block below and error messages being generated when executing. Any

RE: Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my pain?

-users@perl.org Subject: RE: Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my pain? -Original Message- From: BAIER, ANTHONY (TONY), ATTSI [mailto:[EMAIL PROTECTED] Sent: Thursday, November 29, 2007 11:06 AM To: STILWELL, DAVID B (DAVE

Re: perl dbi memory error?

I am using mysql database. Re: perl dbi memory error? Thread Previous From: John Scoles Date: April 16, 2007 04:35 Subject: Re: perl dbi memory error? Sort answer Yes with a But.. Long answer No with a Maybe.. I guess it would depend on the DBD client you are using. Some

Re: perl dbi memory error?

Sort answer Yes with a But.. Long answer No with a Maybe.. I guess it would depend on the DBD client you are using. Some are more capable than others. For example with DBD::Oracle you can create a cursor on the server sideg and then get that in clumps. Give us the exact DBD clients you are

Re: perl dbi memory error?

By the way: In the 3rd step You are using in Your code $sth-execute (and not $dbh-execute, as You typed in Your message)? Don't You? Best regards Robert ravi kumar schrieb: Hai, I am using perl DBI module for fetching data from database. My database table contains almost 70

RE: Perl DBI Urgent

compiling/installing DBI. -M -Original Message- From: Sanjay Tripathi [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 28, 2007 10:17 AM To: Matthew Ramadanovic; Satya Shiv Mohanty Cc: dbi-users@perl.org Subject: RE: Perl DBI Urgent Matt, As your suggestion, I did like that [EMAIL

RE: Perl DBI Urgent

Sanjay Tripathi wrote: I am using SunOS and Oracle as a DB. To Install DBI I'm using below command perl -MCPAN -e 'install Bundle::DBI' [snip] CPAN.pm: Going to build T/TI/TIMB/DBI-1.54.tar.gz *** Perl versions below 5.6.1

RE: Perl DBI Urgent

-Original Message- From: Garrett, Philip (MAN-Corporate) [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 27, 2007 8:04 PM To: Sanjay Tripathi; dbi-users@perl.org Subject: RE: Perl DBI Urgent Sanjay Tripathi wrote: I am using SunOS and Oracle as a DB. To Install DBI I'm using below

RE: Perl DBI Urgent

How do I will check that Perl is having DBI and DBD(Oracle) Module or not! ~~Sanjay~~~ -Original Message- From: Satya Shiv Mohanty [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 27, 2007 8:00 PM To: Sanjay Tripathi Subject: RE: Perl DBI Urgent Probably u did not add the exact location

RE: Perl DBI Urgent

successfully\n; } print Done\n; -Matt -Original Message- From: Sanjay Tripathi [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 28, 2007 9:13 AM To: Satya Shiv Mohanty Cc: dbi-users@perl.org Subject: RE: Perl DBI Urgent How do I will check that Perl is having DBI and DBD(Oracle) Module

RE: Perl DBI Urgent

Sanjay Tripathi wrote: Please find the Logs for both of Perl Command as an attachment as per your request. Welcome to Dependency Hell. Here is your problem: Writing Makefile for List::Util -- NOT OK Running make test Can't test without successful make Running make install make

RE: Perl DBI Urgent

Sanjay Tripathi wrote: Writing Makefile for List::Util make: not found INSTALL FAILED! You need to install make. You'll also need a C compiler if you don't already have it installed (which you probably don't). - Philip

RE: Perl DBI Urgent

Matthew Ramadanovic wrote: Why not just do something like this: #!/usr/bin/perl eval { use DBI; }; if ($@) { print Couldn't use DBI : [EMAIL PROTECTED]; } else { print Loaded DBI successfully\n; } Output: Can't locate DBI.pm in @INC ... Although this does indeed tell me that DBI is

RE: Perl DBI Urgent

:) Thanks Sanjay Tripathi -Original Message- From: Matthew Ramadanovic [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 28, 2007 7:26 PM To: Sanjay Tripathi; Satya Shiv Mohanty Cc: dbi-users@perl.org Subject: RE: Perl DBI Urgent Why not just do something like this: #!/usr/bin/perl eval { use

RE: Perl DBI Urgent

DBI requires File::Spec. File::Spec requires Scalar::Util. Scalar::Util (packaged alongside List::Util) is failing to install. If you can get Scalar::Util to install, you'll probably have no problem with DBI. Here is one way to try it: # perl -MCPAN -e shell cpan look Scalar::Util (this

RE: Perl DBI Urgent

or clue ~~~Sanjay Tripathi ~~~ -Original Message- From: Sanjay Tripathi Sent: Wednesday, March 28, 2007 7:47 PM To: 'Matthew Ramadanovic'; Satya Shiv Mohanty Cc: dbi-users@perl.org Subject: RE: Perl DBI Urgent Matt, As your suggestion, I did like that [EMAIL PROTECTED] # vi

RE: Perl DBI Urgent

To: Matthew Ramadanovic; Satya Shiv Mohanty Cc: dbi-users@perl.org Subject: RE: Perl DBI Urgent Matt, As your suggestion, I did like that [EMAIL PROTECTED] # vi sanjay_test.pl sanjay_test.pl [New file] #!/usr/bin/perl eval { use DBI; }; if ($@) { print Couldn't use DBI : [EMAIL PROTECTED

RE: Perl DBI Urgent

Sanjay Tripathi wrote: I am using SunOS and Oracle as a DB. To Install DBI I'm using below command perl -MCPAN -e 'install Bundle::DBI' [snip] CPAN.pm: Going to build T/TI/TIMB/DBI-1.54.tar.gz Perl

RE: Perl DBI Urgent

. ** Press return to continue... ~~~ST~~~ -Original Message- From: Garrett, Philip (MAN-Corporate) [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 27, 2007 7:38 PM To: Sanjay Tripathi; dbi-users@perl.org Subject: RE: Perl DBI Urgent It looks like you need to install DBI. - Philip Sanjay

RE: Perl DBI Urgent

: Perl DBI Urgent It looks like you need to install DBI. - Philip Sanjay Tripathi wrote: Hi, I getting problem with Perl/Cgi/DBI. Can you guys help me out. Please see the log below. Aapche Logs: Can't locate DBI.pm in @INC (@INC contains: /app/custom/steve/perl /usr

Re: Perl DBI Urgent

On 3/27/07, Sanjay Tripathi [EMAIL PROTECTED] wrote: Here one more thing I want to add that, I am using perl-5.6.1 and DBI-1.48. Whenever I/m trying to install DBI. It display me messages like below. Perl versions below 5.6.1 are no longer supported by the DBI. Perl versions 5.6.x may fail

RE: Perl DBI Urgent

Kimberly Mount wrote: Can someone please help me out? I've asked a couple of times and haven't had any success. Can you please remove me from this list? I don't know what else to do? Unsubscribe: Send an empty email to [EMAIL PROTECTED] Cc: list, maybe somebody else will find this useful.

RE: Perl DBI Installation error

On Wed, 2 Aug 2006 15:35:47 +0530, Gautam Dutta wrote: Hi Gautam What is full form of BTW? Where will I found it? It's a pity people did not point you to: http://acronymfinder.com/ -- Cheers Ron Savage, [EMAIL PROTECTED] on 3/08/2006 http://savage.net.au/index.html Let the record show:

RE: Perl DBI Installation error

What is full form of BTW? Where will I found it? -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 12:40 AM To: Reidy, Ron; Gautam Dutta; [EMAIL PROTECTED]; dbi-users@perl.org Subject: RE: Perl DBI Installation error BTW - 1.51 is the latest

RE: Perl DBI Installation error

What is gcc ? I am not able to find in ur below said docs. My operating system is HP-Unix. -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 12:33 AM To: Gautam Dutta; [EMAIL PROTECTED]; dbi-users@perl.org Subject: RE: Perl DBI Installation

RE: Perl DBI Installation error

]; dbi-users@perl.org Subject: RE: Perl DBI Installation error What is full form of BTW? Where will I found it? -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 12:40 AM To: Reidy, Ron; Gautam Dutta; [EMAIL PROTECTED]; dbi-users

RE: Perl DBI Installation error

BTW - By the way -Original Message- From: Gautam Dutta [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 4:06 AM To: Reidy, Ron; [EMAIL PROTECTED]; dbi-users@perl.org Subject: RE: Perl DBI Installation error What is full form of BTW? Where will I found it? -Original

RE: Perl DBI Installation error

: RE: Perl DBI Installation error 'gcc not found' is your problem. No gcc, no install. Read these docs: http://www.cpan.org/modules/INSTALL.html http://lso.gmu.edu/OSCR/howtoDBIonLinux.html -Original Message- From: Gautam Dutta [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 01, 2006 3

RE: Perl DBI Installation error

'gcc not found' is your problem. No gcc, no install. Read these docs: http://www.cpan.org/modules/INSTALL.html http://lso.gmu.edu/OSCR/howtoDBIonLinux.html -Original Message- From: Gautam Dutta [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 01, 2006 3:39 AM To: [EMAIL PROTECTED];

  1   2   3   >