test
9) should still fail with a different error
10) set the TNS_HOME
11) rerun the make test
12) should conenct
My last gasp at it.
Cheers
John
Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error
Date: Fri, 25 Jun 2010 16:06:32 +0800
From: pbk...@motorola.com
To: sco...@pythian.com
Don't know what else to say.
You either have a bad perl or DBI/DBD install or something on the network
permission side is blocking you.
Can't really help more than that.
Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error
Date: Mon, 28 Jun 2010 19:06:23 +0800
From: pbk
produkt bedzie mial takie pola (poki co)
wyszukiwanie po nazwie,producencie,statusie
product_name
product_description
product_producer
product_status_id
product_price
product_price_currency_id
product_price_datetime
product_created_datetime
product_modified_datetime
product_url
sorry, my mistake :(
[mailto:sco...@pythian.com]
Sent: Wednesday, June 23, 2010 7:19 PM
To: Yeow Yiew Choong-PBKN64
Cc: dbi-users@perl.org
Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error
Yeow Yiew Choong-PBKN64 wrote:
ok you had these set before
I just noticed you have
TNS_ADMIN =/opt/instantclient_10_2/network
]
Sent: Wednesday, June 23, 2010 7:19 PM
To: Yeow Yiew Choong-PBKN64
Cc: dbi-users@perl.org
Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error
Yeow Yiew Choong-PBKN64 wrote:
ok you had these set before
I just noticed you have
TNS_ADMIN =/opt/instantclient_10_2/network/admin
that should
: Yeow Yiew Choong-PBKN64
Sent: Thursday, June 24, 2010 11:00 AM
To: 'John Scoles'
Cc: dbi-users@perl.org
Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error
Hi all,
Tried TNS_ADMIN =/opt/instantclient_10_2/ and
ORACLE_USERID=scott/ti...@zmy12sora02 but still same error.
I have set ORACLE_HOME
, 2010 11:00 AM
To: 'John Scoles'
Cc: dbi-users@perl.org
Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error
Hi all,
Tried TNS_ADMIN =/opt/instantclient_10_2/ and
ORACLE_USERID=scott/ti...@zmy12sora02 but still same error.
I have set ORACLE_HOME=/opt/instantclient_10_2/ and many different
On 06/24/2010 05:52 AM, John Scoles wrote:
Well not havening much luck are we.
At this point I think you either have a bad Perl, DBI or DBD::Oracle
installation and or a you have multiple installations of DBI and
DBD::Oracle.
---deleted on purpose ;)
Perhaps it might help to start
test, it cannot connect. Why?
Thanks.
Yeow
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Tuesday, June 22, 2010 6:44 PM
To: Yeow Yiew Choong-PBKN64
Cc: dbi-users@perl.org
Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error
How are you connecting with SQLPLus
Yiew Choong-PBKN64
Cc: dbi-users@perl.org
Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error
How are you connecting with SQLPLus?
Still failed with TNS_ADMIN configured exported.
I tried another user with dba role but same error.
sqlplus can connect but DBD::Oracle cannot, how
*From:* John Scoles [mailto:sco...@pythian.com]
*Sent:* Friday, June 18, 2010 7:36 PM
*To:* Yeow Yiew Choong-PBKN64
*Subject:* Re: Perl 5.8.9 DBI/DBD::Oracle make test error
last change TNS_ADMIN
set this to the dir where you tnsnames.ora is located
If all
]
Sent: Friday, June 18, 2010 7:36 PM
To: Yeow Yiew Choong-PBKN64
Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error
last change TNS_ADMIN
set this to the dir where you tnsnames.ora is located
If all of these faile then there is something in your network that is
prefenting DBD::Oracle from
...@pythian.com]
Sent: Friday, June 18, 2010 12:04 AM
To: Yeow Yiew Choong-PBKN64
Cc: dbi-users@perl.org
Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error
Yeow Yiew Choong-PBKN64 wrote:
I really doubt there is a scott/tiger user on you Oracle box
set the ORACLE_USERID to a value user
test_harness(0, 'blib/lib', 'blib/arch') t/*.t
t/01base# Test loading DBI, DBD::Oracle and version
t/01baseok
t/10general.DBI
connect('','scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zmy12s
ora02)(PORT=1521))(CONNECT_DATA=(SID=CGISSRND)))',...) failed
# Test loading DBI, DBD::Oracle and version
t/01baseok
t/10general.DBI
connect('','scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zmy12s
ora02)(PORT=1521))(CONNECT_DATA=(SID=CGISSRND)))',...) failed: ERROR
OCIEnvNlsCreate. Check ORACLE_HOME (Linux
Forgot to cc this reply to the list
-Original Message-
From: CAMPBELL, ED (ATTBST)
Sent: Thursday, June 17, 2010 12:52 PM
To: 'John Scoles'
Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error
The scott/tiger user in Oracle is Locked with an expired password by
default, so you need
cmurta...@gmail.com (Colin Murtaugh) writes:
Hi --
I'm running into a strange problem with a script that uses DBI and
DBD::Oracle. Once my script connects to my database, I can't use ctrl-c to
exit (or ctrl-z to background it). I end up having to open another shell
and kill the original
2009/11/25 Martin J. Evans martin.ev...@easysoft.com:
Colin Murtaugh wrote:
Hi --
I'm running into a strange problem with a script that uses DBI and
DBD::Oracle. Once my script connects to my database, I can't use ctrl-c
to
exit (or ctrl-z to background it). I end up having to open
Hi --
I'm running into a strange problem with a script that uses DBI and
DBD::Oracle. Once my script connects to my database, I can't use ctrl-c to
exit (or ctrl-z to background it). I end up having to open another shell
and kill the original process manually. As you can imagine, this wreaks
Colin Murtaugh wrote:
Hi --
I'm running into a strange problem with a script that uses DBI and
DBD::Oracle. Once my script connects to my database, I can't use ctrl-c to
exit (or ctrl-z to background it). I end up having to open another shell
and kill the original process manually. As you
I've just given an answer to this question at StackOverflow.com:
http://stackoverflow.com/questions/370425/perl-oracle-multithreaded
If you disagree with what I said (Tim, or anyone involved with DBD::Oracle),
either correct me on SO, or add your own answer, or just let me know and
I'll correct
Hi,
I have a quick question . I have an Oracle 10g running on a Sun 9.5 .
I Want to access the Database from perl . I am aware that I need DBI
and DBD module to interface it . However do I also need to install and
configure the Oracle client 'OLITE_10.3.0.2.0_SOLARIS' (Oracle
Database Lite 10g
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
After getting the current versions of DBI and DBD::Oracle built and working, I
no longer got the error. When I moved my fix from our development
environment to our test environment, I found that I still got the error. I
started removing the items in my fix from the development environment to
Hello Rich,
i checked one of my Solaris Sparc boxes. There is a much more current
DBI version installed:
perl -MDBI -e 'DBI-installed_versions'
Perl: 5.008005(sun4-solaris)
OS : solaris (2.9)
DBI : 1.48
DBD::Sponge : 11.10
DBD::Proxy
I’m having a problem with a DBI script on our Solaris systems. The scripts run
fine on my Linux workstation. The script will return the correct data and then
displays the error. I have found many places discussing this error, but none of
them has a solution. If you need more information
On 2008-01-29 19:14:51 -0800, Jonathan Leffler wrote:
On Jan 29, 2008 5:31 AM, Mohammed, Shafi [EMAIL PROTECTED]
wrote:
I need following files.
As has already been explained to you -- you need to get those files from a
legitimate source, namely Oracle, or your authorized Oracle
Hello ,
Now I want to use DBI for my current project.
Here I have trying to install DBD::ORACLE PACKAGE it is thronging error.
And it is now allowing to install this package.
Please help us in installing this package.
Please tell me what are the steps to be taken care while
To: John Scoles
Cc: Mohammed, Shafi; dbi-users@perl.org
Subject: Re: DBI-DBD::ORACLE EROR
Hello!
On Tue, 29 Jan 2008, John Scoles wrote:
It would be nice to see the output for the Makefile.PL as well
Looks like either one of few things
1) you do not have the full oracle 9
Hello!
On Tue, 29 Jan 2008, John Scoles wrote:
It would be nice to see the output for the Makefile.PL as well
Looks like either one of few things
1) you do not have the full oracle 9 client installed
2) you do not have the ORACLE_HOME= or LD_LIBRARY_PATH set correctly
It would be nice to see the output for the Makefile.PL as well
Looks like either one of few things
1) you do not have the full oracle 9 client installed
2) you do not have the ORACLE_HOME= or LD_LIBRARY_PATH set correctly
3) you do not have execute permissions on the *.h files
Have a look at
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 29, 2008 6:56 PM
To: John Scoles
Cc: Mohammed, Shafi; dbi-users@perl.org
Subject: Re: DBI-DBD::ORACLE EROR
Hello!
On Tue, 29 Jan 2008, John Scoles wrote:
It would be nice to see the output for the Makefile.PL as well
Looks
On Jan 29, 2008 5:31 AM, Mohammed, Shafi [EMAIL PROTECTED]
wrote:
I need following files.
As has already been explained to you -- you need to get those files from a
legitimate source, namely Oracle, or your authorized Oracle supplier.
Nothing else will work; no-one who respects the law will
Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Sanjay Noronha [mailto:[EMAIL PROTECTED]
Sent: Monday, November 06, 2006 7:47 PM
To: dbi-users@perl.org
Subject: Insert/Update performance issues with Oracle 10gR2 + DBI +
DBD::Oracle
We're upgrading from 8i to 10g (using
We're upgrading from 8i to 10g (using materialized views and more).
We're having strange issues with simple inserts and updates.
Here's what we observed:
For the foll. query
UPDATE job_descr SET phase_id = 2 WHERE jobid = 11576242
1. Runs in a fraction of a second from Toad
2.
: Monday, November 06, 2006 7:47 PM
To: dbi-users@perl.org
Subject: Insert/Update performance issues with Oracle 10gR2 + DBI +
DBD::Oracle
We're upgrading from 8i to 10g (using materialized views and more).
We're having strange issues with simple inserts and updates.
Here's what we observed
Should it be necessary to recompile DBI and/or DBD::Oracle when upgrading
from Oracle 9.2.0.4.0 to 10.2.0.2.0?
Our DBA's recently did this upgrade, and since then, I've been unable to get
DBI working 100%. The lingering problem is that I cannot select character
fields. If I do select
Might be useful to mention that we use DBI version 1.37 and DBD::Oracle
version 1.14.
_
From: Dan Werner [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 4:36 PM
To: 'dbi-users@perl.org'
Subject: DBI/DBD::Oracle and Oracle 10g
Should it be necessary to recompile DBI and/or DBD
Hi,
How can I bind an Perl array to a PL/SQL function's
input/output that take PL/SQL associative arrays?
For Example;
In the following PL/SQL function:
function my_func
( p_1 in my_coll
, r_1 out my_coll
) return pls_integer;
The my_coll is a PL/SQL associative array
[mailto:[EMAIL PROTECTED]
Sent: Saturday, 21 January 2006 6:17 AM
To: dbi-users@perl.org
Subject: Perl dbi/dbd-oracle/Decode function
Hi list
Without decode the following script works fine but with decode it is
giving errors, is there a way to make decode work?
Script follows:
#!/usr/bin
for 5.8.7 in my experience ;)
Jeff
Regards,
Hirosi Taguti
[EMAIL PROTECTED]
-Original Message-
From: uresh.kuruhuri [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 03, 2005 8:41 PM
To: dbi-users@perl.org
Subject: Could not install DBI, DBD::Oracle for AS Perl
-
From: uresh.kuruhuri [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 03, 2005 4:41 AM
To: dbi-users@perl.org
Subject: Could not install DBI, DBD::Oracle for AS Perl. Please help me
out!
Hi everybody,,,
I have found esoftmatic.com showing the instructions for the installation
PROTECTED]
-Original Message-
From: uresh.kuruhuri [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 03, 2005 8:41 PM
To: dbi-users@perl.org
Subject: Could not install DBI, DBD::Oracle for AS Perl.
Please help me out!
Hi everybody,,,
I have found esoftmatic.com showing
4.Test-Simple-0.47-5.8.3.tar
and unzipped them using the winzip and all the files have got created in 'blib'
directory.
But I could not find a proper guidance for the installation with these tar
files.
Can you please help me out in installing DBI, DBD::Oracle in my machine with
these tar files
On Fri, Aug 26, 2005 at 10:58:22AM -0400, Ford, Richard wrote:
We are encountering a problem when we connect to an Oracle database and do not
provide the database name in the connect string.
The ORACLE_HOME that the DBD was compiled against is
/app/oracle/client
The Oracle ENV variables
; dbi-users@perl.org
Subject: RE: DBI DBD-Oracle connection failure woth ORA-12705
SOLVED Thanks Ron,
I have another oracle home for Oracle9ias . NLS_LANG was set right in
The database oracle_home, but set as NA in the IAS home.
I have set an environment variable NLS_LANG so that all homes
Environment = Windows XP, perl 5.6 (activestate)
I recently upgraded my DBI module to 1.32
And DBD-Oracle to 1.16
I have an Oracle 9 database on my PC, and have been connecting to it using
DBI with no problems.
On upgrading to the above versions (I think the prior DBD was 1.12)
My
Metalink not 158654.1
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Gavin W [mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 2:03 AM
To: dbi-users@perl.org
Subject: DBI DBD-Oracle connection failure woth ORA-12705
Environment = Windows XP
We are encountering a problem when we connect to an Oracle database and do not
provide the database name in the connect string.
The ORACLE_HOME that the DBD was compiled against is
/app/oracle/client
The Oracle ENV variables defined outside of perl are:
ORACLE_HOME=/app/oracle/DEV
To: dbi-users
cc:
Subject:RE: [dbi] DBD::Oracle, Instantclient and HP-UX...
Michael,
I think with InstantClient OCIEnvCreate fails if you set ORACLE_HOME. You
need
to make sure libclntsh.so is on your dynamic linker search path
(LD_LIBRARY_PATH) and do /not/ set
/2005 13:57
Please respond to [EMAIL PROTECTED]
To:Michael PEPPLER
cc:martin.evans, dbi-users
Subject:RE: [dbi] DBD::Oracle, Instantclient and HP-UX...
Tree setting SHLIB_PATH to the same value as LD_LIBRARY_PATH. Try doing
this before you build DBD::Oracle. (You are doing
Hi,
I was recently going through the process of manually installing DBI 1.48
and DBD::Oracle (I prefer the manual route), and couldn't complete the
install due to items missing from @INC. I'm working on a Linux box.
The only way I was able to correct the problem was by either modifying
the
Which linux? What is the output of 'perl -V'? What was missing?
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Smith, Sharon Michelle (OSLO) [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 21, 2005 1:14 PM
To: dbi-users@perl.org
Subject: DBI DBD
On 11/26/2004 08:14 AM, Chris Holt said:
Thanks , I needed some one to tell me it was definately permissions.
It made me look harder at the perms on higher level directories. Now
I'll look at my connection problem .
Can't connect to data source exua, no database driver specified and
DBI_DSN env
After being prepped by experiences of others in the README.aix file. I beleive
(see below), I have a good installation. But on running my fist test prog I
appear to have a permissions problem. This litlle ditty does not fail when run
as root, but anyone else and it aborts on the 'use DBI;'.
$
On 11/25/2004 08:03 AM, Chris Holt said:
After being prepped by experiences of others in the README.aix
file. I beleive (see below), I have a good installation. But
on running my fist test prog I appear to have a permissions
problem. This litlle ditty does not fail when run as root,
but anyone
On 2004-11-06 18:18:07 -0800, HSIA, GEORGE (SBCSI) wrote:
Urgent request or help from our dbi-user community:
I have tried 7 different ways to reinstall DBI-1.43 and DBD-1.15 for
Perl 5.6.1 on the HPUX 11, Oracle 9.2.0, Apache Server, since 7 AM this
morning. They all failed with two types
of
this community!
George
SBC
-Original Message-
From: Peter J. Holzer [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 06, 2004 11:17 PM
To: [EMAIL PROTECTED]
Subject: Re: Urgent Help of HP/DBI/DBD/Oracle 9.2
On 2004-11-06 18:18:07 -0800, HSIA, GEORGE (SBCSI) wrote:
Urgent request or help from
Urgent request or help from our dbi-user community:
I have tried 7 different ways to reinstall DBI-1.43 and DBD-1.15 for
Perl 5.6.1 on the HPUX 11, Oracle 9.2.0, Apache Server, since 7 AM this
morning. They all failed with two types of DBI or DBD errors.
(Type I)
After running a Perl script to
On 2004-09-07 08:40:33 -0600, Reidy, Ron wrote:
I've never seen before insert trigger being slower than doing the same
thing in the client code. I guess it would depend on what you are
doing in the trigger and how many sequences are cached (but the amount
cached would also have the same
Hallo,
why not using the returing clause?
$sth-prepare ( insert into foo (my_id, data) values (my_id_seq.nextval,?) returning
my_id into ? );
$sth-bind_param( 1, bar);
my $id;
$sth-bind_param_inout( 2, \$id, 12);
$sth-execute();
Tuesday, September 7, 2004, 4:05:09 AM, Jared wrote:
my
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]
Sent: Monday, September 06, 2004 9:06 PM
To: Reidy, Ron
Cc: Jean-Pierre Utter Löfgren; DBI List
Subject: RE: How to use sequences in DBI/DBD::Oracle with bind
On Tue, 2004-08-31 at 07:36, Reidy
my $start_num = $dbh-selectrow_array( select my_id_seq.nextval from
dual);
my @seq = ( $start_num..100,000 ); # some end number
$sth-prepare ( insert into foo (my_id, data) values (?,?) );
$sth-bind_param( 1, shift(@seq) );
$sth-bind_param( 2, bar);
$sth-execute();
the 'select from
On Tue, 2004-08-31 at 07:36, Reidy, Ron wrote:
Use a before insert trigger to populate the column.
Triggers have the cachet of being a neat way to
automatically populate key columns, and I have
used them many times myself.
They are also much slower than the posters original code.
Jared
Does anybody have a clue on how to bind oracle sequences.
Background:
Due to the large amount of data to be loaded into our oracle9i db by our
applications, a bulk-load software would have been our first choice to
handle the inserts. However, since our data is higly dynamic in its
construction,
I'm no Oracle expert, but I've always done it the way you originally did it:
$sth-prepare ( insert into foo (my_id, data) values
(my_id_seq.nextval, 'bar') );
$sth-execute();
I searched for seq in 'perldoc DBD::Oracle' and found this under LOB locator stuff:
On 2004-08-31 13:19:52 +0200, Jean-Pierre Utter Löfgren wrote:
Using DBI/DBD, it handles inserts using sequneces very nicely as long
as I do
$sth-prepare ( insert into foo (my_id, data) values
(my_id_seq.nextval, 'bar') );
$sth-execute();
But if I rearange the code to be more
Thanks for your response, Hardy!
I read that too, but since I dynamicaly build the meta-sql code in
another application, I haven't really control over knowing where the
sequence are located and wether the occcur in a statment or not.
Kind of tricky this one.
Thanks also Andy and Jon for your
On Tue, Aug 31, 2004 at 01:19:52PM +0200, Jean-Pierre Utter Löfgren wrote:
Does anybody have a clue on how to bind oracle sequences.
I don't think you have to.
is however that I use sequences in the database inserts for various
reasons, as some inserts use the same primary key, sub-data
/DBD::Oracle with bind
Does anybody have a clue on how to bind oracle sequences.
Background:
Due to the large amount of data to be loaded into our oracle9i db by our
applications, a bulk-load software would have been our first choice to
handle the inserts. However, since our data is higly
Sorry, I meant to reply to the list.
In most cases a trigger probably is the best.
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 10:54 AM
To: Helck, Timothy
Subject: RE: How to use sequences in DBI/DBD::Oracle with bind
A trigger is better
try $data = 'bar';$sth-prepare (insert into foo (my_id, data)
values(my_id_seq.nextval,?));$sth-execute($data);What you are doing
below is passing the string value my_id_seq.nextval to the field
my_id.
Jean-Pierre Utter Lfgren [EMAIL PROTECTED] 08/30 10:19 pm
Does anybody
Alternative solution could be like this, but it's based on assumption that
the sequence is exclusively used by current application/transaction...
At the start of program fetch my_id_seq.nextval to a variable and build
a sequence array starting with that nextval.
my $start_num =
To: Jean-Pierre Utter Löfgren
Cc: [EMAIL PROTECTED]
Subject: Re: How to use sequences in DBI/DBD::Oracle with bind
Alternative solution could be like this, but it's based on assumption that
the sequence is exclusively used by current application/transaction...
At the start of program fetch
On Tue, Aug 31, 2004 at 07:54:40AM -0400, Hardy Merrill wrote:
I'm no Oracle expert, but I've always done it the way you originally did it:
$sth-prepare ( insert into foo (my_id, data) values
(my_id_seq.nextval, 'bar') );
$sth-execute();
I searched for seq in 'perldoc
for the information and the help...
jwm
-Original Message-
From: Gene Dascher [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 12:48 PM
To: Moon, John
Subject: RE: [CGI] DBI DBD::Oracle
Try looking at this page to see if it can give you any direction:
http://www.fors.com/velpuri2/ERRORS/TWO
::errstr
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Moon, John [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 1:14 PM
To: '[EMAIL PROTECTED]'
Subject: DBI DBD::Oracle
I originally sent this to the CGI list so please excuse me if you
I have ActiveState Perl 5.8.3.
I used the PPM to install the DBD-Oracle driver to my pc:
C:\ppm install ftp://ftp.esoftmatic.com/outgoing/5.8.3/DBI.ppd
But I got the Error: Failed to download URL
ftp://ftp.esoftmatic.com/outgoing/5.8.3/DBI.ppd: 404 Can't chdir to
5.8.3
So, I went to
George, Jeff has now told you *twice* what you need to do, and you
haven't done what he suggested yet. If you're going to ask for help
here you need to at least try what people suggest. And
just-so-you-know, asking for phone numbers isn't really appropriate.
Here are the ftp url's that Jeff
, June 24, 2004 4:44 AM
To: [EMAIL PROTECTED]; HSIA, GEORGE (SBCSI)
Subject: Re: DBI,DBD-Oracle install for AS Perl URGENT!!
George, Jeff has now told you *twice* what you need to do, and you
haven't done what he suggested yet. If you're going to ask for help
here you need to at least try what
Tim,
Oracle 8.1.7
DBI 1.28
DBD::Oracle 1.12
I hope this email does not irriatate you but I really need some help. I have an Oracle
DBA I need to work with who doesn't seem to how to write PL/SQL for Perl DBI. He
insists on writting stored procedures which loop through the results set
On 02/04/2004 06:56 AM, Michael Cesar wrote:
Oracle 8.1.7
DBI 1.28
DBD::Oracle 1.12
I hope this email does not irriatate you but I really need some help.
I have an Oracle DBA I need to work with who doesn't seem to how to
write PL/SQL for Perl DBI. He insists on writting stored procedures
which
On 02/04/2004 12:55 PM, Michael Cesar wrote:
Heres the entire script.
Michael Cesar
#!/usr/local/bin/perl -w
use strict;
use DBI;
use Data::Dumper;
use DBD::Oracle qw(:ora_types);
my (@result_arref,@row);
my $dbh = DBI-connect(
'dbi:Oracle:XXX',
'abc',
On 02/04/2004 06:09 PM, Michael Cesar wrote:
Thanks a million...
BTW, if you are really putting the SELECT text in the script,
prepare()ing a SELECT by itself and executing that would be more
efficient and avoids having a cursor returned from a package.
Why is this so? My DBA wants everything
Hi,
I installed perl modules DBI-1.32 DBD::Oracle 1.09. I had chosen these
versions b'coz they were already running perfectly on another machine with
same environment(Linux 7.2, Perl 5.6.0 Oracle-8.1.7). After installation i
ran my perl-script that connects to oracle db. It ran perfectly
All,
I have just spent far too long building perl 5.8.0, DBI-1.38 and
DBD-Oracle-1.14
on HPUX 11.0 ( an L2000 machine ) with Oracle 9.0.1.
Having finally succeeded I thought I'd share my knowledge !!
Yes, I know it's in all those README files but it takes much careful
reading.
Unpack the perl
All, ( last send was truncated by list server!?)
I have just spent far too long building perl 5.8.0, DBI-1.38 and
DBD-Oracle-1.14
on HPUX 11.0 ( an L2000 machine ) with Oracle 9.0.1.
Having finally succeeded I thought I'd share my knowledge !!
Yes, I know it's in all those README files but it
On Mon, 11 Aug 2003 08:48:54 -0500 Forotanrad, Bahman [EMAIL PROTECTED] wrote:
I have several perl scripts which use sybperl. I am in the process of
moving my data off Sybase to Oracle 8i and 9i on AIX 5.1. In order to
re-write my perl scripts to interface with Oracle, I need to use
Hi,
as i am a very unexperienced user. could someone tell me how to install dbi
dbd using an oracle 9i
database on windows 2000. it would be nice, if you tell me also what
versions are needed. pls reply
to my email address as i am no member of the mailing list
regards
volker
Hello,
I have several perl scripts which use sybperl. I am in the process of
moving my data off Sybase to Oracle 8i and 9i on AIX 5.1. In order to
re-write my perl scripts to interface with Oracle, I need to use
something similar to sybperl. I've been reading about oraperl. Would
you please
Thank you Jeff!
I've been getting a few emails from folks looking
for xmlproj.com, and had no place to send them.
This is much appreciated.
Jared
On Monday 07 July 2003 12:22, Jeff Urlwin wrote:
Hi.
I've setup an ActiveState repository for DBI, DBD::Oracle and DBD::ODBC for
use
On Wed, Jul 09, 2003 at 08:54:52AM -0400, Jeff Urlwin wrote:
I would propose that you instead try to get DBD::Oracle into
the ActiveState repository. (Note that DBD::ODBC already is
there.) From my experience with DBD::mysql I know that
I could NOT agree with you more. However,
Hi list,
How do I verify whether DBI/DBD Oracle is installed on Solaris 7 server?, please let
me know.
-
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
/DBD Oracle
Hi list,
How do I verify whether DBI/DBD Oracle is installed on Solaris 7 server?,
please let me know.
-
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
Hi, Jeff,
Quoting Jeff Urlwin [EMAIL PROTECTED]:
One thing to keep in mind is that you *should* get your
binary built
modules from the same location. So, if you want DBD::Oracle, make
sure you get DBI from my site.
this is what bothers me. First of all, note that the current
Hi, Jeff,
Quoting Jeff Urlwin [EMAIL PROTECTED]:
One thing to keep in mind is that you *should* get your binary built
modules
from the same location. So, if you want DBD::Oracle, make sure you get
DBI from my site.
this is what bothers me. First of all, note that the current release
is
Hi, Jeff,
Quoting Jeff Urlwin [EMAIL PROTECTED]:
Jochen -- I agree with you, but until someone gets Oracle to write it
to ActiveState or ActiveState works it out with Oracle, I'll do the
best I can.
of course I wasn't aware of such legal nonsense. My apologize,
in that case I can of course
Hi, Jeff,
Quoting Jeff Urlwin [EMAIL PROTECTED]:
Jochen -- I agree with you, but until someone gets Oracle
to write it
to ActiveState or ActiveState works it out with Oracle, I'll do the
best I can.
of course I wasn't aware of such legal nonsense. My
apologize, in that
Quoting Jeff Urlwin [EMAIL PROTECTED]:
I don't have a problem with that, in principle. I guess I could talk
to
Jenda Krynicky (sp) too, since he seems to have some modules up and
seems to
use DBI. I don't know Randy, can you send me an e-mail address or
contact
information?
See
1 - 100 of 186 matches
Mail list logo
