Ben,
Do you have at least the Oracle client installed on these boxes? If
not, you need to install Oracle; if so, use CPAN to load the modules:
$ cpan
CPAN install DBI
CPAN install DBD::Oracle
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Ben Edwards
Just reinstall it after the new Oracle software is installed.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Capacio, Paula J [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 01, 2007 2:07 PM
To: dbi-users@perl.org
Subject: Uninstall DBD-Oracle on HP
Hello,
I built
Well, this is not a Perl/DBI question, really. I personnaly do not use
TWO_TASK as it is an archaic environment variable that has been around
since version 4 of the DB.
If you are interested in using the Easy Connect method, you should read
the Oracle docs:
db_name and
domain_name.
rr
-Original Message-
From: tom r [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 11, 2007 12:37 PM
To: Reidy, Ron; dbi-users@perl.org
Subject: Re: TWO_TASK environment variable
hi ron,
thanks for the response. using sqlnet.ora just doesn't work for me. i
agree
I haven't done VMS work in years, but it used to be the case that when an OS
upgrade was performed, one had to relink shared libraries. Have you tried
relinking DBD::Oracle and DBI?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Since you don't give any information about your BD, I will give you the
way I would do it with Oracle.
I would put the 'x' records into a QUEUE table. Upon entry into the
queue, a DBMS_JOB would start and process the row. Errors can be
generated to the instance alert log, or notification could
Sanjay,
I suggest the following:
1. Upgrade your version of Perl to 5.8.8 (someone else suggested this
already) and put it in a different location (not /usr/bin or
/usr/local/bin). You most definitely will need a C compiler to do this.
2. Change your path in /etc/profile to have this new Perl
This tells me there is something not set in your environment. Have you
tried setting the environment like I specified?
rr
From: joe bayer [mailto:[EMAIL PROTECTED]
Sent: Friday, March 23, 2007 7:28 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users
From: joe bayer [mailto:[EMAIL PROTECTED]
Sent: Friday, March 23, 2007 9:13 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: help with my perl script
I I just installed the ORACLE 10.2.0.3 to another home, and re-run the
script, this time, even perl itself
See below ...
From: joe bayer [mailto:[EMAIL PROTECTED]
Sent: Friday, March 23, 2007 3:33 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: help with my perl script
Dear group, I know it is not DBI related problem, but it is hard
Sumit,
Why are you using such an old version of Perl? It also looks like you
have downloaded ActiveState's Perl. Why not get the latest distro of
Perl from http://www.perl.com/download.csp#sourcecode and build it
yourself? This would almost assuredly eliminate these problems.
--
Ron Reidy
::Oracle with it.
rr
-Original Message-
From: Sumit Shah [mailto:[EMAIL PROTECTED]
Sent: Friday, March 02, 2007 4:59 PM
To: Reidy, Ron
Cc: Fong, Anna; dbi-users@perl.org
Subject: Re: DBI Make Error on HP-UX
Ron,
Perl was pre-installed on HP-UX, which is 5.6.1.
I have an Oracle
Isn't AutoCommit turned off at the database handle level?
DBI-connect('dbi:xxx:', uid, pwd, {AutoCommit = 0})
Sorry, I have not been following this thread.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Wednesday,
Yes - tune your design and application code. MySQL != Oracle in any
way.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc
-Original Message-
From: rami doqa [mailto:[EMAIL PROTECTED]
Sent: Monday, February 26, 2007 3:20 AM
To: dbi-users@perl.org
Subject: DBD::Oracle question?
Hi ALL. Is
But, what do you mean by compatible?
AFAIK, Perl 6 is not even close to being out yet. If it is, then you
would need to use the DBI and DBD::Oracle for Perol 6 (I am very sure
they will be different).
I use Perl 5.8.* and Oracle 8.1, 9.2, 10.1, and 10.2 w/o issue.
--
Ron Reidy
Lead DBA
Array
Well, it works for me out of the box as advertised.
Code snippet:
my $sth_admin_audit_files = $dbh-prepare(qq{
INSERT INTO array_audit.admin_audit_files
(instance_id
,file_crdt
,fname
,file_header
,file_header_raw
)
VALUES
(:instance_id
I think you need to compile against the 32 bit Oracle libraries -
http://research.imb.uq.edu.au/~l.rathbone/solaris/perl.shtml
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Jay Tipton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 07, 2007 3:35 PM
To:
Running makefile.pl is not quite all there is. You need to follow it up
with 'make', 'make test', and 'make install'.
Why don't you just install it with ppm?
--
Ron Reidy
Lead DBA
Array BioPharma, inc.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday,
Terry,
I'm a little confused. The error you are getting clearly indicates to
me you do not have a TNS entry in tnsnames.ora for that ORACLE_SID.
From the error docs:
$ oerr ora 12154
12154, 0, TNS:could not resolve service name
// *Cause: The service name specified is not defined correctly
, February 02, 2007 1:16 PM
To: Reidy, Ron; dbi-users@perl.org
Subject: RE: DBD Oracle connection problem
I am confused too.
My tnsnames.ora file is fine. I did try sqlplus and tnsping, they both
work. Also, if I do not specify the database name (ORACLE_SID is set to
'D102L') the database handle
Support.
So, there you go.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
From: Chong, Wei-Ling [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 30, 2007 9:00 PM
To: Reidy, Ron; dbi-users@perl.org
Subject: RE: Can't call method prepare on an undefined value
Did you install the DBI module?
Did you really type DBi vs. DBI (it makes a huge difference)?
Did you install DBI using ppm?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Tapas Kumar Swain [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 31, 2007 1:27 AM
To:
Well, first of all, the poster on that forum did not state any reason
why he took that road (did Oracle support suggest this; was there a bug,
etc.), so I would take this with a large grain of salt until that route
is closed.
What version of the Oracle client are you running on your web server?
Chong,
I am not a web programmer, but I see some things I would definitely fix
in your program:
1. You should always 'use strict;' and 'use warnings;' - it will
help you find things like this.
2. You should always check your statement handles after all calls
(ora_open()).
3.
Ron,
I suggest you:
1. Use bind variables for your insert statement. It might be that some
character in your variables which is causing the problem.
2. Look at the PL/SQL block that is part of the error message. The
statement fragment PROG.EMPLID NID.NATIONAL_ID prog.admit_term looks
like it
Joel,
To really know understand the problem, you should gather an extended SQL
trace (event 10046) at the DB level at level 8 or higher -
http://orafaq.com/faqdbain.htm#EVENTS
After the program has completed, you will need to get the trace file
from the server's udump directory and format it
Oscar,
Short answer - you cannot (sort of). This is because your shell script
will execute in a sub shell of your perl program.
However, you can do something like this:
# untested
system(export VAR=val; /path/to/your/shell/script.sh);
I think that might work for you.
--
Ron Reidy
Lead DBA
This may not be a DBD::Oracle issue, although your modules look a little
dated. Did you check you instance alert log and find the generated
trace file?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, January
Sorry - snow bound for 2 days.
To determine DBI version:
$ perl -CDBI -e 'print $DBI::Version
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 20, 2006 1:32 PM
To: Reidy, Ron; dbi-users@perl.org
Subject: RE: Unix: Oracle User Identified
Is this AS Perl? If so, use ppm to install DBD::Oracle, after you
install an Oracle client.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 21, 2006 3:02 AM
To: dbi-users@perl.org
Subject: regarding installing dbd-oracle
Hi,
when i am
Mark,
Shouldn't the password be blank?
$dbh = $DBI-connect(dbi:Oracle:, /, , ...);
This is what I use for SYS connections, analogous to using the SQL*Plus
command 'connect / as sysdba'.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: [EMAIL PROTECTED]
Paula,
Unless you are keeping the older versions of Oracle on the system, I
would definitely rebuild both DBD::Oracle and DBI when moving to a new
client.
I'm not a Windows guy, but if you install DBD::Oracle under a 9.2 client
and then remove that client, replacing it with a 10.2 client,
What errors are you getting (ORA- or TNS-)?
Are you defining the other variables necessary - NLS* LD_LIBRARY_PATH,
etc. for your ORACLE_HOME?
Can you tnsping the DBs from your web server? What about connecting via
SQL*Plus?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original
'ALTER is not a valid PL/SQL command. You need to use 'EXECUTE
IMMEDIATE' for this command. The Oracle PL/SQL docs describe this
command.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Ravi Malghan [mailto:[EMAIL PROTECTED]
Sent: Monday, November 27, 2006 3:55 PM
Kindness it is ...
Your statement only has one bind variable (?). The other bind
variable is actually a Perl variable. Your execute will fail because
of this.
However, there is another issue. You cannot substitute bind variables
in this manner. Your attempt to dynamically build column names
This is not a DBI or a perl issue.
Read your error stack and resolve your Oracle issue.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Sumitra Gatade [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 07, 2006 6:01 AM
To: dbi-users@perl.org
Subject: DBI - error
Have you performed a 10046 trace? What (if any) init parameters were
changed prior to moving to 10g? Do you have up to date CBO stats on
your tables and data dictionary?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Sanjay Noronha [mailto:[EMAIL PROTECTED]
Sent:
perldoc perlfunc
From: Ammayappa SELVAKUMAR [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 22, 2006 11:58 AM
To: Reidy, Ron; dbi-users@perl.org
Subject: RE : Unlink command fails as well system call fails sometimes...
No, I have not checked the return
Have you checked the return code?
-Original Message-
From: Ammayappa SELVAKUMAR [mailto:[EMAIL PROTECTED]
Sent: Friday, October 20, 2006 10:14 AM
To: dbi-users@perl.org
Subject: Unlink command fails as well system call fails sometimes...
Dear All,
I am using unlink commad to delete
This is not a DBI issue. In Oracle, orphaned processes are harvested by
the SMON process. Your DBA should know this and be able to act
accordingly by setting SQL*Net parameters on the server and waking up
the SMON process to harvest the orphans.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
Did you run 10046 traces on the code?
Have you profiled the code?
I switched to these same versions a couple of years ago, and have had no
problems.
rr
-Original Message-
From: Oscar Gomez [mailto:[EMAIL PROTECTED]
Sent: Friday, September 08, 2006 9:04 AM
To: dbi-users@perl.org
, September 08, 2006 9:28 AM
To: Reidy, Ron
Subject: RE: switching perl version
Hi Ron, thanks for your reply
I haven't tried the 10046 trace, because I still am studying how to do
it.
but what is the relationship or the reliance between the cpu performance
and
oracle under the new versions install
Oscar,
Have you determined what is slow? Is it the DB and if so, which queries
are slow? Have you run 10046 traces against your processes to determine
the waits?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Oscar Gomez [mailto:[EMAIL PROTECTED]
Sent:
Sure,
What are you doing in GlabalRoutines.pm at line 88? Are you fetching a
large result set into memory (hash or array)?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 05, 2006 11:38 AM
To:
Why don't you just try them?
rr
-Original Message-
From: Elangovan, Sasikala [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 29, 2006 6:04 AM
To: Jared Still
Cc: Jared Still; dbi-users@perl.org
Subject: RE: Oralce10g database compatible Perl version, DBD and DBI -on
URGENT Basis
Hi,
What happens if you try to connect to that same DB instance using
SQL*plus? Does your CGI have use the same tnsnames.ora file as the
command line user?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Angus McIntyre [mailto:[EMAIL PROTECTED]
Sent: Friday, August 18,
a thought.
rr
-Original Message-
From: Angus McIntyre [mailto:[EMAIL PROTECTED]
Sent: Friday, August 18, 2006 12:07 PM
To: dbi-users@perl.org
Subject: RE: ORA-01017 ... but only when script is run as CGI
On Fri, August 18, 2006 1:21 pm, Reidy, Ron wrote:
What happens if you try to connect
Did you install the Oracle client (not too sure what you mean when you
say you installed oic)?
What Perl module are you trying to install?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 16, 2006 3:17 AM
To: dbi-users@perl.org
Subject: what
The search directory is the same that SQL*Plus will use. See the Oracle
docs for this.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Rowe, Dolores A [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 6:29 AM
To: dbi-users@perl.org
Subject: Oracle and DBI
If you mean will it use OID to resolve TNS addresses, then yes You
don't need to make any changes to the connect string. The DBI will
connect to the database just like SQL*Plus will.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL
)
Directory_server_type=oid
You can read about this in the OID/LDAP Oracle manuals.
Giddy up.
rr
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 12:07 PM
To: Reidy, Ron; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID) instead of TNS
No. The list is a search order - tnsnames will be checked first, then
OID.
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 3:06 PM
To: Reidy, Ron; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names
Hi
to clarify this issue. When/if you get this information, would
you mind posting it back to this group?
rr
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 6:18 PM
To: Reidy, Ron; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID
Stephen,
This is old news. A CHAR type in Oracle has always been stored in the
DB padded with spaces to for the length of the column. A VARCHAR2 is a
better choice for variable length character type columns.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc
-Original Message-
From: Stephen
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
Google is your friend.
If you do not know what gcc is, you have bigger problems than not
getting DBI installed.
-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
No, permissions on some file at the OS level. You never make it into
the DB.
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 3:46 PM
To: Reidy, Ron; DBI-Users
Subject: RE: Invalid authorization specification (SQL-28000)
Do you mean
'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];
BTW - 1.51 is the latest release. You might consider using that
release.
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 01, 2006 1:03 PM
To: Gautam Dutta; [EMAIL PROTECTED]; dbi-users@perl.org
Subject: RE: Perl DBI Installation error
'gcc not found
Permissions on something?
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 3:20 PM
To: DBI-Users
Subject: Invalid authorization specification (SQL-28000)
Hi All,
I don't know what is causing the following error, but I can successfully
, July 21, 2006 9:20 AM
To: Reidy, Ron; dbi-users@perl.org
Subject: RE: (Fwd) dbd-oracle-1.16
Hi Reidy, Thanks
The permissions are oracle.oinstall
--
Open WebMail Project (http://openwebmail.org)
-- Original Message ---
From: Reidy, Ron [EMAIL PROTECTED]
To: Tim Bunce [EMAIL
To: Reidy, Ron; dbi-users@perl.org
Subject: RE: (Fwd) dbd-oracle-1.16
Ok,
drwxr-xr-x 3 oracle oinstall 4096 Jul 21 10:26
/opt/local/m01/app/oracle/product/8.17/lib/
-rwxr-xr-x 1 oracle oinstall 6352174 Jul 21 10:26
/opt/local/m01/app/oracle/product/8.17/lib/libclntsh.so.8.0
Running the script from
SQL*Plus is not required to connect from Perl, unless you would like to
run SQL*Plus as a piped process or with expect from within Perl.
You will need to (at a minimum) install an Oracle client on the machine
running the Perl scripts, along with the DBI and DBD::Oracle modules.
The README files
To: Reidy, Ron; DBI-Users
Subject: RE: sth-do()
Hi Ron,
Here is the error message, however, this external table does not exist.
DBD::ODBC::db do failed: [unixODBC]ERROR: Relation
'b_sdl_123456_p_dlvrb_study_att' already exists (SQL-HY000)(DBD: Execute
immediate failed err=-1) at ./try.pl line 54
And the error is?
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Friday, June 30, 2006 1:51 PM
To: DBI-Users
Subject: sth-do()
Hi All,
I need to issue commands such as (CREATE TABLE, DROP TABLE, ALTER
TABLE, etc...), however, whenever I use
From oerr:
$ oerr ora 12541
12541, 0, TNS:no listener
// *Cause: The connection request could not be completed because the
listener
// is not running.
// *Action: Ensure that the supplied destination address matches one of
// the addresses used by the listener - compare the TNSNAMES.ORA entry
Did you install an Oracle client (at least)? Did you read the README*
files for each module?
-Original Message-
From: Lihong Sun [mailto:[EMAIL PROTECTED]
Sent: Monday, June 26, 2006 12:49 PM
To: dbi-users@perl.org
Subject: dbi-users@perl.org
Dear folks,
I have a question for you
Put the path to that Perl interpreter into /etc/profile before the paths
to the other Perl interpreters.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: LLC [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 22, 2006 4:52 PM
To: dbi-users@perl.org
Subject: multiple perl
Isn't this an ODBC thing? Did you look at the DBD::ODBC docs?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Ben [mailto:[EMAIL PROTECTED]
Sent: Friday, June 23, 2006 1:48 PM
To: dbi-users@perl.org
Subject: Stupid newbie question?
Hey guys, I'm very green at DBI
The easiest way to do this is to use PL/SQL and the 'execute immediate'
statement.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Ready, Mike [mailto:[EMAIL PROTECTED]
Sent: Monday, June 19, 2006 8:58 AM
To: dbi-users@perl.org
Subject: Creating an oracle temp table
No true. The DBD::Oracle module essentially is a Pro*C wrapper around
your Perl code.
You network might be slow, or your database instance might be badly
configured, or you application design might be bad, or you might write
bad queries. This could make it appear that Perl is slow. Do not be
Comments below ...
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 08, 2006 10:47 PM
To: List - DBI users
Subject: Oracle schema names: sqlplus 'v' Perl
This is Oracle V 10.02.0010 for Windows.
Under
The O'Reilly book is the bible.
-Original Message-
From: Malka Cymbalista [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 04, 2006 8:16 AM
To: dbi-users@perl.org
Subject: regular expresions
Can anyone recommend a good book on regular expressions. I don't need a
beginners book - I know how
Neither DBI nor DBD::Oracle are installed as part of the Perl distro.
To see if either module is installed:
$ perl -MDBI -e '0'
$ perl -MDBD::Oracle -e '0'
If you need to install either module, google will be your friend.
-Original Message-
From: R, Rajsekar [mailto:[EMAIL PROTECTED]
You will need to determine the source of your Perl binary. The best way
to determine this is to:
$ perl -V
And look for which C compiler was used to build Perl. If your Perl is
not from ActiveState, I believe you will not be able to use ppm at all.
If you indeed, need to rebuild Perl, you
Read the DBD:Oracle README files. You need to set some environment
variables before running 'make test'.
--
Ron Reidy
Lead DBA
Arrray BioPharma, Inc.
-Original Message-
From: Brian Duke [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 31, 2006 5:00 PM
To: dbi-users@perl.org
Subject: DBD
I came across this issue at a former client site years ago. I
recommended changing all the SQL*Plus scripts into DBI calls. This was
rejected to save $. That is when I stumbled across the Expect module.
I have used in many ways since and find its use indispensable.
Expect.pm and the expect
use Expect;
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 23, 2006 12:40 PM
To: DBI-Users
Subject: how to invoke .sql file from dbi
Hello all,
We have bunch of sql files ( .sql ) that we want to invoke from dbi (
Oracle ).
How does it work.
Joe,
What OS and version, version of DBI, version of DBD::Oracle?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 24, 2006 8:35 AM
To: dbi-users@perl.org
Cc: [EMAIL PROTECTED]
Subject: (Fwd) Just a quick
How did you download and install?
-Original Message-
From: David Andre [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 23, 2006 1:51 AM
To: dbi-users@perl.org
Subject: problem with dbi module.
Hi,
I'm David ANDRE from caterpillar in Belgium.
i try to use the DBI module with perl 5.8.3 on
This is somewhat off topic as it has nothing to do with DBI nor Perl.
However ...
When a connection request is made to an Oracle database instance, the
TNS listener receives this request. If the listener is configured to
create dedicated sessions, a new process is created, connected to the
No, I do not know you are a DBA; maybe YOU cannot describe the problem
well enough.
-Original Message-
From: Drozdowski, Catharine [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 23, 2006 10:11 AM
To: Reidy, Ron; dbi-users@perl.org
Subject: RE: Identify PID for remote database handle
Not according to this:
http://ppm.activestate.com/BuildStatus/5.8.html
-Original Message-
From: Robert Hicks [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 11, 2006 1:04 PM
To: dbi-users@perl.org
Subject: Re: DBD-Oracle.ppd
If you are running ActiveState Perl DBD::Oracle is in PPM now.
I think you need to use a lower version of DBI - check the changelogs
and readme docs.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Jon Baldassari [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 10, 2006 8:47 AM
To: dbi-users@perl.org
Subject: DBI-1.14
I
Change your sqlnet.ora to read:
Names.directory_path = (LDAP)
This assumes you have a proper ldap.ora file in the same location as
your sqlnet.ora.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Alexander Foken [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 02,
1. Look in the data dictionary
2. Select from the table and trap the appropriate error code
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 27, 2006 4:33 PM
To: List - DBI users
Subject: Checking if a table exist
Hi All,
Does anyone know of
http://search.cpan.org/~pythian/DBD-Oracle-1.17/Oracle.pm#Other_Data_Typ
es
-Original Message-
From: Riccardo Bonuccelli [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 26, 2006 8:46 AM
To: dbi-users@perl.org
Subject: Oracle functions through DBI?
Hello,
I was wondering (and found
Get a 10046 trace of the process. This will tell you exactly what the
DB is waiting for.
I have had no issues with the TNS listener to date.l
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006
-Original Message-
From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 3:43 PM
To: Reidy, Ron
Cc: dbi-users@perl.org
Subject: RE: Oracle connect hangs forever
On Tue, 2006-04-25 at 15:19 -0600, Reidy, Ron wrote:
Get a 10046 trace of the process
Install Test::More
sudo perl -MCPAN -e 'install Test::More'
-Original Message-
From: Holstein, Thomas E CTR DISA PAC
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 29, 2006 6:02 PM
To: 'dbi-users@perl.org'
Subject: DBI blues
Hi, I am trying to install DBI to run a DBtest Script that
ppm 'install Test::More'
-Original Message-
From: Paresh Rathod [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 29, 2006 6:35 AM
To: dbi-users@perl.org
Subject: Upgrade.. DBI
Sir,
Please provide me the help to upgrade the latest of DBI.
I am using Oracle 9
It shows
Google is my friend. I can be your friend also:
http://codecomments.com/PERL_DBI/message824574.html
Read the comment from Andy Hassal.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Kedar Joshi -X (kedajosh - Infosys at Cisco)
[mailto:[EMAIL PROTECTED]
Sent:
What version of Perl are you running?
Have you properly installed DBI?
-Original Message-
From: Ganesh Prasad A K [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 21, 2006 4:31 AM
To: dbi-users@perl.org
Subject: DBI.pm
Can't locate loadable object for module DBI in @INC (@INC
Have you looked into the Oracle error docs? What happens if you
'tnsping MAINO1'?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Angela Chan [mailto:[EMAIL PROTECTED]
Sent: Friday, March 10, 2006 9:24 AM
To: dbi-users@perl.org
Subject: ORA-12154 message
Hi,
What is happening? What Oracle version, Perl version DBI/DBD::Oracle
versions?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Hariharan Venkata-Chinnaswamy
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 01, 2006 9:43 PM
To: dbi-users@perl.org
Subject: inserting
, 2006 3:51 PM
To: Reidy, Ron
Cc: Hariharan Venkata-Chinnaswamy; dbi-users@perl.org
Subject: Re: inserting XML Document into Oracle database using a stored
procedure
Here is the version information
Perl Verion is 5.8.5
Oracle client version is 9.0
DBI version is 1.45
DBD::Oracle version is 1.15
My comments in line ...
-Original Message-
From: Hariharan Venkata-Chinnaswamy
[mailto:[EMAIL PROTECTED]
Sent: Thursday, March 02, 2006 4:03 PM
To: Alexander Foken; hariharan.venkata-chinnaswamy
Cc: dbi-users@perl.org
Subject: RE: inserting XML Document into Oracle database using a
What is your environment? Did you read the README* files that came with
DBD::Oracle and DBI? Do you have an Oracle client (at least) installed
on this machine?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Angela Chan [mailto:[EMAIL PROTECTED]
Sent: Monday,
have Net8 (8.1.7) Oracle Client installed on my machine.
Thanks
Angela
Reidy, Ron [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
What is your environment? Did you read the README* files that came with
DBD::Oracle and DBI? Do you have an Oracle client (at least) installed
The prepare statement in DBI will prepare and then execute the
statement. This is, essentially tow PARSE calls against the dictionary
cache.
Look at using ora_check_sql
(http://search.cpan.org/~timb/DBD-Oracle-1.16/Oracle.pm#Prepare_postpone
d_till_execute) to eliminate this issue.
If the
1 - 100 of 387 matches
Mail list logo
