make 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.
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
sorry, my mistake :(
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
preze
make test.
Suggestions?
Thanks.
Yeow
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Thursday, June 24, 2010 8:52 PM
To: Yeow Yiew Choong-PBKN64
Cc: dbi-users@perl.org
Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error
Well not havening much luck are we.
At th
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 sta
, 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
e/value should I set?
Thanks.
Yeow
-Original Message-
From: 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
ORAC
]
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
ohn Scoles [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
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 c
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
.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 of these faile then there is something in your network that is
prefenting DBD::Oracle
Yeow
*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 of t
...@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 and
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, s
7;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=(S
::MM" "-e"
"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=(PR
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 orig
2009/11/25 Martin J. Evans :
> 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
>
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 ca
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 a
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 i
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
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 Rele
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
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::Prox
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 about
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 Ora
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
Collaborative Business Experience at www.capgemini.com
-Original Message-
From: Alexander V Alekseev [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 Tu
Message-
From: Alexander V Alekseev [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
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 correct
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
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 installing
tables and data dictionary?
--
Ron 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
: 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
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. R
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::Oracle when
> upgrading from Oracle 9.2.0.4.0 to 10.2.0.2.0?
If only the
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
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 varchar2_
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 ha
obert [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:
#!/us
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/perl
DBI->trace( 2, 'dbitrace.log' );
use warnings;
use FileHandle;
use DBI;
use strict;
use DBI qw(:sql_types);
use Spread
he link:
> > http://ftp.esoftmatic.com/outgoing/DBI/5.8.3/
> > 1.DBI-1.43-5.8.3.tar
> > 2.DBD-Oracle-1.15-5.8.3.tar
> > 3.DBD-ODBC-1.10-5.8.3.tar
> > 4.Test-Simple-0.47-5.8.3.tar
> >
> > and unzipped them using the winzip and all the files have got
> >
-
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 of
the
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.
> Please help me out!
>
> Hi e
.tar
3.DBD-ODBC-1.10-5.8.3.tar
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::Or
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 var
, Ron; 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
-Oracle in previous versions worked, then did not work
When I updated them. Which Oracle home was it looking at?
Anyway thanks again
Gavin
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: 26 August 2005 14:45
To: Gavin W; dbi-users@perl.org
Subject: RE: DBI DBD-Oracle
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
ORACLE_SID=DE
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
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 co
TECTED] - 19/08/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
;
> Extranet
> [EMAIL PROTECTED] - 19/08/2005 10:43
>
>
> 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
Thanks Martin,
Unfortunately unsetting ORACLE_HOME didn't fix that problem (i.e.
OCIEnvCreate still fails).
Michael
Extranet
[EMAIL PROTECTED] - 19/08/2005 10:43
To: dbi-users
cc:
Subject:RE: [dbi] DBD::Oracle, Instantclient and HP-UX...
Michael,
I think
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 ORACLE_HOME.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
Development
On 19-Aug-2005 [EMAIL PROTECTED] wrote:
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:
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 test
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 var
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 any
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;'.
$ c
On Sun, 2004-11-07 at 02:17, Peter J. Holzer wrote:
> On 2004-11-06 18:18:07 -0800, HSIA, GEORGE (SBCSI) wrote:
> There is a readme somewhere which explains how to build perl on HP-UX so
> that DBD::Oracle works.
README.hpux it has been in the last several releases of DBD-Oracle... at
going back
t 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
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 typ
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 t
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 ef
Reidy
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,
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
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
> 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();
>
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 '
: 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
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 = $dbh->selectrow_ar
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 anybo
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
/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
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
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 m
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
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:
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, thi
::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
able to connect at all(?). My Sqlplus connect looks like:
>sqlplus [EMAIL PROTECTED]
which is the same(?) connection I'm using with DBI(?).
Thanks again for the information and the help...
jwm
-Original Message-
From: Gene Dascher [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29
rsday, 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
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 told
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 ftp://ftp.e
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
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: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 lo
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
fetching
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 tak
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 sou
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
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
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
>
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 help
Sunday, July 27, 2003 2:49 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Jeff Urlwin
> Subject: Re: DBI (DBD::Oracle) Repository for ActiveState PPM
> build 805
>
>
>
> Thank you Jeff!
>
> I've been getting a few emails from folks looking
> for xmlproj.c
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::
1 - 100 of 212 matches
Mail list logo