RE: Uninstall DBD-Oracle on HP

[Reidy, Ron]

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 DBD-Oracle for version 10 using a /usr/oracle/rdbms directory.
However, now the DBAs want me to build it against a /usr/oracle/client
directory instead.  What is the best way to uninstall DBD-Oracle? 
Do I delete each directory and file that was created by the 'make
install' or is there an easier way?
Thanks in advance,
Paula 
   

This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended to be for the use of the individual or entity
named above. If you are not the intended recipient, please be aware that
any disclosure, copying, distribution or use of the contents of this
information is prohibited. Please notify the sender  of the delivery
error by replying to this message, or notify us by telephone
(877-633-2436, ext. 0), and then delete it from your system.

RE: Trying to set up DBI for oracle

[Reidy, Ron]

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 [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 01, 2007 9:30 AM
To: dbi-users@perl.org
Subject: Trying to set up DBI for oracle

I am trying to set up DBI Oracle stuff on a couple of boxes.  One is
Ubuntu Feiesty and the other is running SunOS 5.8.

I have been using the following test script.

#!/usr/bin/perl
use DBI;
$dbh = DBI->connect( "dbi:Oracle:gen3", "user", "pass" );


Linux
---
I get:
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC
contains: /etc/perl /usr/local/lib/perl/5.8.8
/usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5
/usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at
(eval 3) line 3.
Perhaps the DBD::Oracle perl module hasn't been fully installed, or
perhaps the capitalisation of 'Oracle' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge.
 at ./db.pl line 5

SunOS
--
I get:
install_driver(Oracle) failed: Can't load
'/opt/local/perl/5.6.1/lib/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/
Oracle.so'
for module DBD::Oracle: ld.so.1: db.pl: fatal: libclntsh.so.8.0: open
failed: No such file or directory at
/opt/local/perl/5.6.1/lib/5.6.1/sun4-solaris/DynaLoader.pm line 206.
 at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at ./db.pl line 5

Which I guess are both similar errors.  Anyone know what the modules I
need and how to add them.  I am a perl newbee.

Regards,
Ben
--
Ben Edwards - Bristol, UK
If you have a problem emailing me use
http://www.gurtlush.org.uk/profiles.php?uid=4
(email address this email is sent from may be defunct)

This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended to be for the use of the individual or entity
named above. If you are not the intended recipient, please be aware that
any disclosure, copying, distribution or use of the contents of this
information is prohibited. Please notify the sender  of the delivery
error by replying to this message, or notify us by telephone
(877-633-2436, ext. 0), and then delete it from your system.

RE: TWO_TASK environment variable

[Reidy, Ron]

Why do you put your connect info in single quotes?

Here is my stuff.

First, sqlnet.ora:
$ cat sqlnet.ora
DISABLE_OOB = ON

NAMES.DEFAULT_DOMAIN = xx.com

#TRACE_LEVEL_CLIENT = on
#trace_level_client=16
#trace_file_client=client
#trace_directory_client=/tmp
#trace_level_client=admin
#trace_file_client=ron

SQLNET.EXPIRE_TIME = 0

#NAMES.DIRECTORY_PATH= (TNSNAMES)
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, ezconnect)

AUTOMATIC_IPC = OFF

Next, output from tnsping:
$ tnsping yy

TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on
11-APR-2007 12:47:05

Copyright (c) 1997, 2006, Oracle.  All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

Used LDAP adapter to resolve the alias
Attempting to contact
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=aaa.xxxyyy.com)(
PORT=999)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=yy.xx.com)(INST
ANCE_NAME=yy)(GLOBAL_NAME=yy.xx.com)))
OK (0 msec) 

Last, my connection (using EZ Connect) to the DB via SQL*Plus:

$ sqlplus uid/[EMAIL PROTECTED]:/yy.xx.com

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 11 12:45:22 2007

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

SQL>

I think your problem is that you are not spcifying a service name in
your connection (your tnsnames.ora file does not show this - only a
sid).  In my connection, I am using the GLOBAL_NAME as shown from my
tnsping.  When I used the "sid" type of argument (INSTANCE_NAME in my
tnsping output), sqlplus gave me the TNS-12154 error.  So, I think you
should use the GLOBAL_NAME as defined by the init parameters 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 with you about hidden files -- i don't like them.  that's why i'd
like to 
find a better way.   here's what happens using sqlnet.ora:

-
[~] cat sqlnet.ora
NAMES.DIRECTORY_PATH=(ezconnect, tnsnames) [~] sqlplus
'fs_public/[EMAIL PROTECTED]/iwebdb'

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 11 12:30:48 2007

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in
connect descriptor


Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[~] cat tnsnames.ora
infra=(description=(address=(protocol=tcp)(host=infradb.fs.usda.gov)
(port=1521))(connect_data=(sid=iwebdb)))
[~] sqlplus 'fs_public/[EMAIL PROTECTED]'

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 11 12:31:13 2007

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

-


but if i create a .tnsnames.ora file, i can use 

sqlplus 'fs_public/[EMAIL PROTECTED]'

and it works just fine.

did i make a mistake somewhere?

thanks,
tom


-- 
a celebrity is a person who works hard all his life to become well
known, then 
wears dark glasses to avoid being recognized.  --fred allen

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: TWO_TASK environment variable

[Reidy, Ron]

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:
http://download-east.oracle.com/docs/cd/B19306_01/network.102/b14212/nam
ing.htm#i498306

Pay close attention to the section on setting up NAMES.DIRECTORY_PATH in
your sqlnet.ora file.  When set up properly, it works for me, using
version 10.2.0.2 and 10.2.0.3.


Also, I would strongly advise against using .*.ora file (hidden files).
In my opinion, this is a really bad habit to get into and could lead to
a lot of confusion and frustration trying to debug SQL*Net issues.


--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: tom r [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 11, 2007 11:07 AM
To: dbi-users@perl.org
Subject: TWO_TASK environment variable

reading man DBD::Oracle gives an in depth explanation on how the
TWO_TASK environment variable can be used.  however, when i tried to use
it in place of .tnsnames.ora nothing worked.  i believe that sql*plus
does not use TWO_TASK.

-
[~] cat .tnsnames.ora
infra=(description=(address=(protocol=tcp)(host=infradb.fs.usda.gov)
(port=1521))(connect_data=(sid=iwebdb)))
[~] sqlplus 'fs_public/[EMAIL PROTECTED]'

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 11 10:36:04 2007

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit
Production With the Partitioning, OLAP and Data Mining options

SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release
10.1.0.5.0 - 64bit Production With the Partitioning, OLAP and Data
Mining options [~] printenv | grep TWO
TWO_TASK=T:infradb.fs.usda.gov:iwebdb
[~] sqlplus 'fs_public/fs_public'

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 11 10:35:35 2007

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

-


in addition, it appears sql*plus doesn't even allow one to specify the
connection parameters on the command line.

-
[~] sqlplus 'fs_public/[EMAIL PROTECTED]/sid=iwebdb'

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 11 10:35:43 2007

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

-

unless i'm missing something here, it seems sql*plus must use the
.tnsnames.ora file.

tom



--
turn off the computer and go outside. i hear the special 3d effects are
stunning.  --anonymous

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: DBI->connect failed: ERROR OCIEnvInit

[Reidy, Ron]

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 PROTECTED]
Sent: Mon 4/9/2007 2:33 AM
To: dbi-users@perl.org
Subject: DBI->connect failed: ERROR OCIEnvInit 
 
Hi,

We are getting "DBI->connect failed: ERROR OCIEnvInit " when attempting
to connect an Oracle 9.2.0.5 instance on VMS AXP 8.3 platform. OS is
recently upgraded from V.7.3 to 8.3. 


perl "-V" output:

Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
  Platform:
osname=VMS, osvers=F7.3-1, archname=VMS_AXP
uname='VMS hearns F7.3-1'
config_args='-des'
hint=none, useposix=false, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=undef usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
  Compiler:
cc='CC/DECC', ccflags
='/Include=[]/Standard=Relaxed_ANSI/Prefix=All/Obj=.obj/NoList/NOANSI_AL
IAS',
optimize='',
cppflags='undef'
ccversion='60290006', gccversion='', gccosandvers='undef'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='int',
lseeksize=4
alignbytes=8, usemymalloc=N, prototype=define
  Linker and Libraries:
ld='Link', ldflags ='/NoTrace/NoMap'
libpth=/sys$share /sys$library
libs= 
perllibs= 
libc=(DECCRTL), so=exe, useshrplib=undef, libperl=undef
  Dynamic Linking:
dlsrc=dl_vms.c, dlext=exe, d_dlsymun=undef, ccdlflags=''
cccdlflags='', lddlflags='/Share'


Characteristics of this PERLSHR image: 
  Compile-time options: DEBUGGING
  Built under VMS
  Compiled at Jan 11 2002 08:38:53
  %ENV:
PERL="$PERL_ROOT:[00]PERL.EXE"
PERLDOC="$PERL_ROOT:[00]PERL.EXE PERL_ROOT:[LIB.POD]PERLDOC.COM
-T"
  @INC:
perl_root:[lib.VMS_AXP.5_6_1]
perl_root:[lib]
perl_root:[lib.site_perl.VMS_AXP]
perl_root:[lib.site_perl]
/perl_root/lib/site_perl


DBD-ORACLE-1_06
DBI-1_13

Do I need to recompile my DBI and DBD or install the latest Perl just
because the OS is upgraded? 


Thanks in advance.




This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: dealing with lengthy (time) query sets

[Reidy, Ron]

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 be sent to a
management console, etc.  In any case, by pushing the row into the QUEUE
table, further processing is asynchronous and your program would not
have a delay.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.   

-Original Message-
From: WoodShop [mailto:[EMAIL PROTECTED] 
Sent: Saturday, April 07, 2007 1:03 AM
To: dbi-users@perl.org
Subject: dealing with lengthy (time) query sets

I currently have script/program that simply takes input lines and does
work on them.
updating tables accordingly and all is good.
however every 'x' input lines i need to call a subroutine that does some
work on the database that takes a while, like 1 or 2 min. however i
can't have the program become unresponsive for that long.

My original idea was to spawn a thread off the subroutine and then it
could go do all the work it likes leaving the main section to continue
on chugging through input. However when I tried this i got errors about
"""handle 3 is owned by thread 61f010 not current thread 11deb70
(handles can't be shared between threads and your driver may need a
CLONE method added) """

So i gave up on that and figured i do it with fork, however there are
apparently issues with keeping the database connection associated with
that.

My last resort which i know works is to make another script that makes
its own database connection does its work and dies. I would run this
script when i need to by making exec "..." calls and passing my
parameters via the command line args. I'v done this before and i know it
works, but it just seems ugly and hacked together and i can't help but
think there must be a better way, i can't be the only person that has to
deal with situations like this..

--

Alex Anagnos
Student: Northern Michigan University
[EMAIL PROTECTED]



This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Perl DBI Urgent

[Reidy, Ron]

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 found before
the Perl that is a standard part of your O/S.
3.  Install DBI/DBD::Oracle and other modules you need to get things
rolling. 

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Sanjay Tripathi [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, March 28, 2007 8: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 PROTECTED] # vi sanjay_test.pl
"sanjay_test.pl" [New file]
#!/usr/bin/perl
eval {
use DBI;
};
if ($@) {
print "Couldn't use DBI : [EMAIL PROTECTED]";
} else {
print "Loaded DBI successfully\n";
}
eval {
use DBD::Oracle;
};
if ($@) {
print "Couldn't use DBD::ORACLE : [EMAIL PROTECTED]"; } else { print "Loaded
DBD::Oracle successfully\n"; } print "Done\n";

[EMAIL PROTECTED] # perl sanjay_test.pl

Can't locate DBI.pm in @INC (@INC contains:
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at sanjay_test.pl
line 3.
BEGIN failed--compilation aborted at sanjay_test.pl line 3.
[EMAIL PROTECTED] #


Still I'm facing same problem any Idea :)

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 DBI;
};
if ($@) {
print "Couldn't use DBI : [EMAIL PROTECTED]";
} else {
print "Loaded DBI successfully\n";
}
eval {
use DBD::Oracle;
};
if ($@) {
print "Couldn't use DBD::ORACLE : [EMAIL PROTECTED]"; } else { print "Loaded
DBD::Oracle 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 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 of the DBI.pm in ur script.
Assuming that ur DBI.pm is at /usr/perl5/lib/sun4-solaris/DBI.pm, then u
need to include it using following:-

use lib "/usr/perl5/lib/sun4-solaris";

in ur script.

Also for " Premature end of
script headers" I think u r not mentioning the output type of the
document u r trying to display. Like u use print "Content-type:
text/html\n\n"; for html output.

Hope this helps u.

Regards
Satya Shiv


-Original Message-
From: Sanjay Tripathi [mailto:[EMAIL PROTECTED]

Sent: Tuesday, March 27, 2007 5:41 PM
To: dbi-users@perl.org
Subject: Perl DBI Urgent

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/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .
/app/custom/steve/perl /app/custom/perl /heb/appl/ewa/perl/bin/perl) at
/app/w3/steve/cgi/ewa_new_user.cgi line 3.

BEGIN failed--compilation aborted at /app/w3/steve/cgi/ewa_new_user.cgi
line 3.

[Tue Mar 27 06:47:06 2007] [error] [client x.x.x.x] Premature end of
script headers: /app/w3/steve/cgi/ewa_new_user.cgi







Then I tried


[EMAIL PROTECTED] # perl -e 'use DBI; print $DBI::VERSION,"\n";'




Can't locate loadable object for module DBI in @INC (@INC contains:
/usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int
/usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at DBI.pm line
254

BEGIN failed--compilation aborted at DBI.pm line 254.

Compilation failed in require at -e line 1.

BEGIN failed--compilation aborted at -e line 1.










Thanks

ST


 CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any 

RE: help with my perl script

[Reidy, Ron]

Because you pointed your ORACLE_HOME variable at this new install and
then issued "startup nomount" in your script, it just naturally follows
you would have a second instance up and running.  So, obviously, perl is
working and so is your script.

 

So, let's start over.  You are trying to mimic an interactive session
with RMAN.  I assume you are a DBA and you have read the Oracle backup
and recovery and RMAN documents.  If you are not familiar with these,
you should read and understand them.

 

Next, I suggest the following:

 

1.  Open a session on your server and Set your environment using
oraenv
2.  Start RMAN like you would in your script.
3.  Issue the commands you are trying to get your script to the RMAN
process you are running.  Note the results.

 

Do not set your environment using the %ENV hash - use oraenv.  I cannot
stress this enough.  I know one of the mantras of Perl is TMTOWTDI, but
this does not hold true for the use of oraenv.  I have been a DBA for
almost 10 years and have been working with Perl since version 4 and this
is by far the easiest way to set up your environment and to keep things
running.

 

Good luck.

 

rr

 



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 stopped running.
===
The script is like this:
#!/usr/bin/perl

my $ORACLE_HOME = "/opt/oracle/product_10g_2";
$ENV{ORACLE_HOME}=$ORACLE_HOME;
my $ORACLE_SID="test";
$ENV{ORACLE_SID}=$ORACLE_SID;
my $backup_log = "backup_log.log";

open RMAN, "| /opt/oracle/product_10g_2/bin/rman target=sys/temp" or die
"Can't pipe to $!";
print RMAN "startup nomount\n";
print RMAN "exit\n";
close RMAN;
=

[EMAIL PROTECTED] dba]$ ps -eaf|grep pmon
ora92 8178 1  0 22:31 ?00:00:00 ora_pmon_test
ora9210212 1  0 23:04 ?00:00:00 ora_pmon_test

The SID did passed, but somehow this "test" is different from that
"test", how can that be possible?

Thanks for your help.


"Reidy, Ron" <[EMAIL PROTECTED]> wrote:

Then there is something wrong with your environment.  Have you tried
using oraenv to set you environment vs. setting the %ENV hash?  In cron,
it would look like this:

 

(export ORAENV_ASK=NO && export ORACLE_SID=test && . oraenv &&
/path/to/rman/script)

 

There are other environment variables that are set in oraenv.

 

Another question I have to ask - is the DB running?  

 

--

Ron Reidy

Lead DBA

Array BioPharma, Inc.

 



From: joe bayer [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 23, 2007 4:25 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: help with my perl script

 

Thanks for your prompt response.

I tried 
$ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}="test"

It did not work.



"Reidy, Ron" <[EMAIL PROTECTED]> wrote:

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 to
find some one who knows perl, shell and Oracle.

I am trying to write a RMAN script, 
==
#!/usr/bin/perl

my $ORACLE_HOME = "/opt/oracle/product_10g/test/10.2";
$ENV{ORACLE_HOME}=$ORACLE_HOME;
my $ORACLE_SID="test";
$ENV{ORACLE_SID}=test;  # what is this?  Shouldn't this read
$ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}="test"
my $backup_log = "/backup/backup_log.log";

open RMAN, "| /opt/oracle/product_10g/eratest/10.2/bin/rman
target=sys/temp log=$backup_log" or die "Can't pipe to $!";
print RMAN "exit\n";
close RMAN;
==

It works in command line, but when I put it into crontab job, I always
get 
===
connected to target database (not started)
RMAN> 
===
The script does not recognize the sid, what can I do to fix it?

Thanks very much for your help.

  



No need to miss a message. Get email on-the-go
<http://us.rd.yahoo.com/evt=43910/*http:/mobile.yahoo.com/mail%0d%0a> 
with Yahoo! Mail for Mobile. Get started.
<http://us.rd.yahoo.com/evt=43910/*http:/mobile.yahoo.com/mail%0d%0a> 



size=2 width="100%" align=center> 

This electronic message transmission is a PRIVATE communication which
contains information 
which may be confidential or privileged. The information is intended to
be for the use of the individual

RE: help with my perl script

[Reidy, Ron]

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@perl.org
Subject: RE: help with my perl script

 

Yes, DB is running.  If I run 
./test.sh, there is no problem.

The problem comes only when I put it in cron.



"Reidy, Ron" <[EMAIL PROTECTED]> wrote:

Then there is something wrong with your environment.  Have you tried
using oraenv to set you environment vs. setting the %ENV hash?  In cron,
it would look like this:

 

(export ORAENV_ASK=NO && export ORACLE_SID=test && . oraenv &&
/path/to/rman/script)

 

There are other environment variables that are set in oraenv.

 

Another question I have to ask - is the DB running?  

 

--

Ron Reidy

Lead DBA

Array BioPharma, Inc.

 



From: joe bayer [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 23, 2007 4:25 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: help with my perl script

 

Thanks for your prompt response.

I tried 
$ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}="test"

It did not work.



"Reidy, Ron" <[EMAIL PROTECTED]> wrote:

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 to
find some one who knows perl, shell and Oracle.

I am trying to write a RMAN script, 
==
#!/usr/bin/perl

my $ORACLE_HOME = "/opt/oracle/product_10g/test/10.2";
$ENV{ORACLE_HOME}=$ORACLE_HOME;
my $ORACLE_SID="test";
$ENV{ORACLE_SID}=test;  # what is this?  Shouldn't this read
$ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}="test"
my $backup_log = "/backup/backup_log.log";

open RMAN, "| /opt/oracle/product_10g/eratest/10.2/bin/rman
target=sys/temp log=$backup_log" or die "Can't pipe to $!";
print RMAN "exit\n";
close RMAN;
==

It works in command line, but when I put it into crontab job, I always
get 
===
connected to target database (not started)
RMAN> 
===
The script does not recognize the sid, what can I do to fix it?

Thanks very much for your help.

  



No need to miss a message. Get email on-the-go
<http://us.rd.yahoo.com/evt=43910/*http:/mobile.yahoo.com/mail%0d%0a> 
with Yahoo! Mail for Mobile. Get started.
<http://us.rd.yahoo.com/evt=43910/*http:/mobile.yahoo.com/mail%0d%0a> 



size=2 width="100%" align=center> 

This electronic message transmission is a PRIVATE communication which
contains information 
which may be confidential or privileged. The information is intended to
be for the use of the individual 
or entity named above. If you are not the intended recipient, please be
aware that any disclosure, 
copying, distribution or use of the contents of this information is
prohibited. Please notify the sender 
of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), 
and then delete it from your system.

 

  



No need to miss a message. Get email on-the-go
<http://us.rd.yahoo.com/evt=43910/*http:/mobile.yahoo.com/mail%0d%0a> 
with Yahoo! Mail for Mobile. Get started.
<http://us.rd.yahoo.com/evt=43910/*http:/mobile.yahoo.com/mail%0d%0a> 

 

  



TV dinner still cooling?
Check out "Tonight's Picks"
<http://us.rd.yahoo.com/evt=49979/*http:/tv.yahoo.com/>  on Yahoo! TV.

RE: help with my perl script

[Reidy, Ron]

Then there is something wrong with your environment.  Have you tried
using oraenv to set you environment vs. setting the %ENV hash?  In cron,
it would look like this:

 

(export ORAENV_ASK=NO && export ORACLE_SID=test && . oraenv &&
/path/to/rman/script)

 

There are other environment variables that are set in oraenv.

 

Another question I have to ask - is the DB running?  

 

--

Ron Reidy

Lead DBA

Array BioPharma, Inc.

 



From: joe bayer [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 23, 2007 4:25 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: help with my perl script

 

Thanks for your prompt response.

I tried 
$ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}="test"

It did not work.



"Reidy, Ron" <[EMAIL PROTECTED]> wrote:

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 to
find some one who knows perl, shell and Oracle.

I am trying to write a RMAN script, 
==
#!/usr/bin/perl

my $ORACLE_HOME = "/opt/oracle/product_10g/test/10.2";
$ENV{ORACLE_HOME}=$ORACLE_HOME;
my $ORACLE_SID="test";
$ENV{ORACLE_SID}=test;  # what is this?  Shouldn't this read
$ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}="test"
my $backup_log = "/backup/backup_log.log";

open RMAN, "| /opt/oracle/product_10g/eratest/10.2/bin/rman
target=sys/temp log=$backup_log" or die "Can't pipe to $!";
print RMAN "exit\n";
close RMAN;
==

It works in command line, but when I put it into crontab job, I always
get 
===
connected to target database (not started)
RMAN> 
===
The script does not recognize the sid, what can I do to fix it?

Thanks very much for your help.

  



No need to miss a message. Get email on-the-go
<http://us.rd.yahoo.com/evt=43910/*http:/mobile.yahoo.com/mail%0d%0a> 
with Yahoo! Mail for Mobile. Get started.
<http://us.rd.yahoo.com/evt=43910/*http:/mobile.yahoo.com/mail%0d%0a> 



size=2 width="100%" align=center> 

This electronic message transmission is a PRIVATE communication which
contains information 
which may be confidential or privileged. The information is intended to
be for the use of the individual 
or entity named above. If you are not the intended recipient, please be
aware that any disclosure, 
copying, distribution or use of the contents of this information is
prohibited. Please notify the sender 
of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), 
and then delete it from your system.

 

  



No need to miss a message. Get email on-the-go
<http://us.rd.yahoo.com/evt=43910/*http:/mobile.yahoo.com/mail%0d%0a> 
with Yahoo! Mail for Mobile. Get started.
<http://us.rd.yahoo.com/evt=43910/*http:/mobile.yahoo.com/mail%0d%0a> 

RE: help with my perl script

[Reidy, Ron]

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 to
find some one who knows perl, shell and Oracle.

I am trying to write a RMAN script, 
==
#!/usr/bin/perl

my $ORACLE_HOME = "/opt/oracle/product_10g/test/10.2";
$ENV{ORACLE_HOME}=$ORACLE_HOME;
my $ORACLE_SID="test";
$ENV{ORACLE_SID}=test;  # what is this?  Shouldn't this read
$ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}="test"
my $backup_log = "/backup/backup_log.log";

open RMAN, "| /opt/oracle/product_10g/eratest/10.2/bin/rman
target=sys/temp log=$backup_log" or die "Can't pipe to $!";
print RMAN "exit\n";
close RMAN;
==

It works in command line, but when I put it into crontab job, I always
get 
===
connected to target database (not started)
RMAN> 
===
The script does not recognize the sid, what can I do to fix it?

Thanks very much for your help.

  



No need to miss a message. Get email on-the-go
<http://us.rd.yahoo.com/evt=43910/*http:/mobile.yahoo.com/mail%0d%0a> 
with Yahoo! Mail for Mobile. Get started.
<http://us.rd.yahoo.com/evt=43910/*http:/mobile.yahoo.com/mail%0d%0a> 


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Internal Error while compiling Pro*C program

[Reidy, Ron]

This doesn't look like a Perl/DBI issue.

Google is my friend, it can be yours also:
http://www.google.com/search?q=INTERNAL+ERROR%3A+Failed+assertion+%5BPGE
+Code%3D90105%5D&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&c
lient=firefox-a


-Original Message-
From: RaviChandra Chelikam [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 22, 2007 11:49 AM
To: dbi-users@perl.org
Subject: Internal Error while compiling Pro*C program


Hi



While executing the   make -f aggregator_proc.mk cnm_atmfr_aggregator

 

while compiling i am facing following error :

 

proc  config=/opt/cnm/ld/7.0/shared/pcscfg.cfg iname=cnm_aggregator

 

Pro*C/C++: Release 10.2.0.2.0 - Production on Thu Mar 22 10:41:07 2007

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

System default option values taken from:
/usr/local/opt/oracle/product/ldcnmd/precomp/admin/pcscfg.cfg

 

 

INTERNAL ERROR: Failed assertion [PGE Code=90105]

 

*** Error code 139

make: Fatal error: Command failed for target `cnm_aggregator.c'

 

 

 

could u plz let me know, what could cause the error and plz tell how to
solve this issue.

 

 

Thanks & Regards

 Ravi

 






 
Disclaimer:

This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review at http://www.techmahindra.com/Disclaimer.html";>http://www.techmahind
ra.com/Disclaimer.html externally and http://tim.techmahindra.com/Disclaimer.html";>http://tim.techmahind
ra.com/Disclaimer.html internally within Tech Mahindra.




This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: .pl code errors after oracle upgrade

[Reidy, Ron]

1.  Permissions on $ORACLE_HOME/lib
2.  Not setting the correct Oracle environment vars before executing the
script
3.  Uninstall of 8.1.7.4 Oracle software
4.  Did you rebuild DBD::Oracle to use the newly installed Oracle
software?

Impossible to tell since we have nothing but an error message.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Arokia Samy Joseph [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 08, 2007 2:19 AM
To: dbi-users@perl.org
Subject: .pl code errors after oracle upgrade

Hi,

We recently upgraded our oracle database 8.1.7.4 to 9.2.6.0  After
the update we tried to execute a .pl code.  The following error is
listed. Your suggestion / solution is much appreciated .  Thanks!


==
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/Oracl
e.so' for module DBD::Oracle: ld.so.1: perl: fatal: libclntsh.so.8.0:
open failed: No such file or directory at
/usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206, 
line 1.
 at (eval 2) line 3
Compilation failed in require at (eval 2) line 3,  line 1.
Perhaps a required shared library or dll isn't installed where expected
 at /pelican_app/dv41/arbor/bin/replicate_oracle.pl line 686

==

Regards,
Joseph




This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: DBI Make Error on HP-UX

[Reidy, Ron]

Sumit,

The Perl that ships with AS will work with AS.  Using a different
version of Perl is (I think) not supported by Oracle.

What exactly are you trying to accomplish by installing
Perl/DBI/DBD::Oracle outside of AS?  I think (again, not sure) that the
bundled Perl ships with both DBI and DBD::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 Application Server that comes with its own version of 
Perl which is 5.5.3. I am not sure if I will be able to link Oracle 
Application Server to the latest Perl release.

I will try to build the Perl as you suggested. Do I need any additional 
options during the Configure stage for it to work with DBI and then 
DBD::Oracle?

Thanks
Sumit

Reidy, Ron wrote:
> 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
> Lead DBA
> Array BioPharma, Inc.
>
> -Original Message-
> From: Sumit Shah [mailto:[EMAIL PROTECTED] 
> Sent: Friday, March 02, 2007 4:16 PM
> To: Fong, Anna; dbi-users@perl.org
> Subject: Re: DBI Make Error on HP-UX
>
> I tried to compile it with gcc. I get the socket.h errors. I checked
the
>
> output of 'perl -V' and even perl was compiled with gcc. I am not sure

> why I am getting the same errors.
>
> I would highly appreciate your help with this.
>
> Thanks
> Sumit
>
>
> # perl -V
> Summary of my perl5 (revision 5.0 version 6 subversion 1)
configuration:
>   Platform:
> osname=hpux, osvers=11.00, archname=PA-RISC1.1-thread-multi
> uname='hp-ux llbertha b.11.00 u 9000800 2002402864 unlimited-user 
> license '
> config_args='-des -Dcf_by=ActiveState 
> [EMAIL PROTECTED] -Uinstallusrbinperl
-Ud_sigsetjmp 
> -Dusethreads -Duseithreads -Duselargefiles 
> -Dinc_version_list=5.6.0/$archname 5.6.0 -Dcc=gcc 
> -Accflags=-mpa-risc-1-1 -fPIC -Dd_attribut=undef -Darchname=PA-RISC1.1

> -Dcccdlflags=-fPIC -Dprefix=/opt/perl'
> hint=recommended, useposix=true, d_sigaction=define
> usethreads=define use5005threads=undef useithreads=define 
> usemultiplicity=define
> useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
> use64bitint=undef use64bitall=undef uselongdouble=undef
>   Compiler:
> cc='gcc', ccflags ='-DUSE_REENTRANT_API -D_POSIX_C_SOURCE=199506L 
> -D_HPUX_SOURCE -L/lib/pa1.1 -DUINT32_MAX_BROKEN -mpa-risc-1-1 -fPIC 
> -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE 
> -D_FILE_OFFSET_BITS=64',
> optimize='-O',
> cppflags='-DUSE_REENTRANT_API -D_POSIX_C_SOURCE=199506L 
> -D_HPUX_SOURCE -L/lib/pa1.1 -DUINT32_MAX_BROKEN -mpa-risc-1-1 -fPIC 
> -fno-strict-aliasing -I/usr/local/include'
> ccversion='', gccversion='2.9-hppa-991112',
gccosandvers='hpux11.00'
> intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
> d_longlong=define, longlongsize=8, d_longdbl=define,
longdblsize=16
> ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',

> lseeksize=8
> alignbytes=8, usemymalloc=n, prototype=define
>   Linker and Libraries:
> ld='ld', ldflags =' -L/usr/local/lib'
> libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
> libs=-lnsl -lnm -lndbm -lmalloc -ldld -lm -lpthread -lc -lndir 
> -lcrypt -lsec
> perllibs=-lnsl -lnm -lmalloc -ldld -lm -lpthread -lc -lndir
-lcrypt 
> -lsec
> libc=/lib/libc.sl, so=sl, useshrplib=false, libperl=libperl.a
>   Dynamic Linking:
> dlsrc=dl_hpux.xs, dlext=sl, d_dlsymun=undef, ccdlflags='-Wl,-E '
> cccdlflags='-fPIC', lddlflags='-b -L/usr/local/lib'
>
>
> Characteristics of this binary (from libperl):
>   Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES 
> PERL_IMPLICIT_CONTEXT
>   Locally applied patches:
> ActivePerl Build 633
>   Built under hpux
>   Compiled at Jun 17 2002 21:04:57
>   @INC:
> /opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi
> /opt/perl/lib/5.6.1
> /opt/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi
> /opt/perl/lib/site_perl/5.6.1
> /opt/perl/lib/site_perl
> .
> # make
>  /bin/sh -c true
>  /bin/sh -c true
>  /bin/sh -c true
> /usr/bin/perl -I/opt/perl/lib/5.6

RE: DBI Make Error on HP-UX

[Reidy, Ron]

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
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Sumit Shah [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 02, 2007 4:16 PM
To: Fong, Anna; dbi-users@perl.org
Subject: Re: DBI Make Error on HP-UX

I tried to compile it with gcc. I get the socket.h errors. I checked the

output of 'perl -V' and even perl was compiled with gcc. I am not sure 
why I am getting the same errors.

I would highly appreciate your help with this.

Thanks
Sumit


# perl -V
Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
  Platform:
osname=hpux, osvers=11.00, archname=PA-RISC1.1-thread-multi
uname='hp-ux llbertha b.11.00 u 9000800 2002402864 unlimited-user 
license '
config_args='-des -Dcf_by=ActiveState 
[EMAIL PROTECTED] -Uinstallusrbinperl -Ud_sigsetjmp 
-Dusethreads -Duseithreads -Duselargefiles 
-Dinc_version_list=5.6.0/$archname 5.6.0 -Dcc=gcc 
-Accflags=-mpa-risc-1-1 -fPIC -Dd_attribut=undef -Darchname=PA-RISC1.1 
-Dcccdlflags=-fPIC -Dprefix=/opt/perl'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define 
usemultiplicity=define
useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
  Compiler:
cc='gcc', ccflags ='-DUSE_REENTRANT_API -D_POSIX_C_SOURCE=199506L 
-D_HPUX_SOURCE -L/lib/pa1.1 -DUINT32_MAX_BROKEN -mpa-risc-1-1 -fPIC 
-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE 
-D_FILE_OFFSET_BITS=64',
optimize='-O',
cppflags='-DUSE_REENTRANT_API -D_POSIX_C_SOURCE=199506L 
-D_HPUX_SOURCE -L/lib/pa1.1 -DUINT32_MAX_BROKEN -mpa-risc-1-1 -fPIC 
-fno-strict-aliasing -I/usr/local/include'
ccversion='', gccversion='2.9-hppa-991112', gccosandvers='hpux11.00'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', 
lseeksize=8
alignbytes=8, usemymalloc=n, prototype=define
  Linker and Libraries:
ld='ld', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
libs=-lnsl -lnm -lndbm -lmalloc -ldld -lm -lpthread -lc -lndir 
-lcrypt -lsec
perllibs=-lnsl -lnm -lmalloc -ldld -lm -lpthread -lc -lndir -lcrypt 
-lsec
libc=/lib/libc.sl, so=sl, useshrplib=false, libperl=libperl.a
  Dynamic Linking:
dlsrc=dl_hpux.xs, dlext=sl, d_dlsymun=undef, ccdlflags='-Wl,-E '
cccdlflags='-fPIC', lddlflags='-b -L/usr/local/lib'


Characteristics of this binary (from libperl):
  Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES 
PERL_IMPLICIT_CONTEXT
  Locally applied patches:
ActivePerl Build 633
  Built under hpux
  Compiled at Jun 17 2002 21:04:57
  @INC:
/opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi
/opt/perl/lib/5.6.1
/opt/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi
/opt/perl/lib/site_perl/5.6.1
/opt/perl/lib/site_perl
.
# make
 /bin/sh -c true
 /bin/sh -c true
 /bin/sh -c true
/usr/bin/perl -I/opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi 
-I/opt/perl/lib/5.6.1 /opt/perl/lib/5.6.1/ExtUtils/xsubpp  -typemap 
/opt/perl/lib/5.6.1/ExtUtils/typemap -typemap typemap Perl.xs > Perl.xsc

&& mv Perl.xsc Perl.c
gcc -c  -DUSE_REENTRANT_API -D_POSIX_C_SOURCE=199506L 
-D_HPUX_SOURCE -L/lib/pa1.1 -DUINT32_MAX_BROKEN -mpa-risc-1-1 -fPIC 
-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE 
-D_FILE_OFFSET_BITS=64 -O-DVERSION=\"1.37\"  -DXS_VERSION=\"1.37\" 
-fPIC -I/opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi/CORE -Wall 
-Wno-comment Perl.c
In file included from 
/opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi/CORE/perl.h:722,
 from DBIXS.h:19,
 from Perl.xs:1:
/usr/include/sys/socket.h:439: parse error before "sendfile"
/usr/include/sys/socket.h:439: parse error before "bsize_t"
/usr/include/sys/socket.h:441: parse error before "sendpath"
/usr/include/sys/socket.h:441: parse error before "bsize_t"
/usr/include/sys/socket.h:456: parse error before "__sendfile64"
/usr/include/sys/socket.h:456: parse error before "bsize_t"
/usr/include/sys/socket.h:457: parse error before "__sendpath64"
/usr/include/sys/socket.h:457: parse error before "bsize_t"
/usr/include/sys/socket.h:459: parse error before "sendfile"
/usr/include/sys/socket.h: In function `sendfile':
/usr/include/sys/socket.h:459: parse error before "bsize_t"
/usr/include/sys/socket.h: At top level:
/usr/include/sys/socket.h:460: parse error before "sendpath"
/usr/include/sys/socket.h: In function `sendpath':
/usr/include/sys/socket.h:460: parse error before "bsize_t"
Perl.c: At top le

RE: Perl-Postgres connection: 'Commit' method not found in DBI. Advice?

[Reidy, Ron]

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, February 28, 2007 6:12 PM
To: Alexander Foken; Andrew Edson
Cc: dbi-users@perl.org
Subject: Re: Perl-Postgres connection: 'Commit' method not found in DBI. Advice?

yep--
Aparently postgres thinks its smarter than anyone that wants to use it and has 
Auto-commit ALWAYS turned on
If you find a way to turn this *feature* off let me know because it is 
massively counter intuitive to normal operation of any other db on the planet
Thanks,
Martin--
--- 
This e-mail message (including attachments, if any) is intended for the use of 
the individual or entity to which it is addressed and may contain information 
that is privileged, proprietary , confidential and exempt from disclosure. If 
you are not the intended recipient, you are notified that any dissemination, 
distribution or copying of this communication is strictly prohibited.
--- 
Le présent message électronique (y compris les pièces qui y sont annexées, le 
cas échéant) s'adresse au destinataire indiqué et peut contenir des 
renseignements de caractère privé ou confidentiel. Si vous n'êtes pas le 
destinataire de ce document, nous vous signalons qu'il est strictement interdit 
de le diffuser, de le distribuer ou de le reproduire.
- Original Message - 
From: "Alexander Foken" <[EMAIL PROTECTED]>
To: "Andrew Edson" <[EMAIL PROTECTED]>
Cc: 
Sent: Wednesday, February 28, 2007 11:55 AM
Subject: Re: Perl-Postgres connection: 'Commit' method not found in DBI. Advice?


> Please post some code, it seems like there is something wrong in 
> purge_acnt. Line 242 and a few lines before and after should be 
> interesting, and the lines around DBI->connect.
> 
> Alexander
> 
> On 28.02.2007 16:50, Andrew Edson wrote:
>> I am working with a perl file intended to enter a postgresql database (as 
>> user postgres), select a list of key values based on one of those values and 
>> delete any records which match the returned results.  The purpose of the 
>> program is to delete inactive records from the database that are over two 
>> years in age.
>>
>>   (For the record, the system in question is running SuSE 9.3 os, Apache2, 
>> Postgres 8.1.3, and appears to be running Perl 5.8.6)
>>
>>   When I first ran the perl script, it did not appear to be working; 
>> entering the database afterwards would show that the data was still present. 
>>  After finding and uncommenting a 'commit' statement at the end, I am now 
>> ending up with the error message 
>>
>>   Can't locate object method "commit" via package "DBI::st" at ./purge_acnt 
>> line
>> 242 (#1)
>> (F) You called a method correctly, and it correctly indicated a package
>> functioning as a class, but that package doesn't define that particular
>> method, nor does any of its base classes.  See perlobj.
>>   Uncaught exception from user code:
>> Can't locate object method "commit" via package "DBI::st" at 
>> ./purge_acnt line 242.
>>  at ./purge_acnt line 242
>> Database handle destroyed without explicit disconnect at ./purge_acnt line 
>> 242.
>> Database handle destroyed without explicit disconnect at ./purge_acnt line 
>> 242.
>>
>>   I am asuming that the last two lines are because the program crashed, 
>> artificially severing the connections to the DB.  (The last couple of lines 
>> of the program are normal disconnect statements, but occur after the 
>> 'commit' line that triggered the error.)  It's the rest of the error that I 
>> am confused about.  If I am reading it correctly, it seems to be saying that 
>> there is no 'commit' function in the DBI.  Do I need to update my DBI files 
>> somehow, or is there another way to prevent this error from occuring?  And 
>> if I have to update, would someone please be kind enough to link me to a 
>> good set of instructions on doing so?
>>
>>   Thank you for your consideration.
>>
>>  
>> -
>> Sucker-punch spam with award-winning protection.
>>  Try the free Yahoo! Mail Beta.
>>   
> 
> 
> -- 
> Alexander Foken
> mailto:[EMAIL PROTECTED]  http://www.foken.de/alexander/
> 
>

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877

RE: :Oracle question?

[Reidy, Ron]

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 there a relation between the version of
DBD::Oracle and Oracle 10g.
The performance of executing the SQL statements is low
comparing to mysql performance.
Can any body advice me what to do to avoid this
performance issue

Regards,
Dakka, Rami



 


Don't get soaked.  Take a quick peak at the forecast
with the Yahoo! Search weather shortcut.
http://tools.search.yahoo.com/shortcuts/#loc_weather

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Oracle 10G and perl v5.8.0

[Reidy, Ron]

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 BioPharma, Inc.

-Original Message-
From: Krishnan, Vijaya [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 14, 2007 12:29 PM
To: dbi-users@perl.org
Cc: Lootens, Robin
Subject: Oracle 10G and perl v5.8.0

Just wanted to know if Oracle 10G and perl v5.8.0 are compatible or an
upgrade to perl 6 would be required. 
 
Thanks,
Vijaya
 
Vijaya Krishnan 
Commercial / Government Card Technology and Payment Services 
Treasury and Payments Services (TPS) Technology 
Ph:704-683-0881(W);704-841-4358(H) 
Pager:877-470-9172 Pin 470-9172 
Email: [EMAIL PROTECTED]
  

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: :Oracle - Any advance on inserting CLOB to XMLTYPE?

[Reidy, Ron]

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
  ,TO_DATE(:file_crdt, 'DD/MM/ HH24:MI:SS')
  ,:fname
  ,SYS.XMLType.CREATEXML(:file_header)
  ,:file_header_raw
  )
RETURNING admin_audit_file_id, crmo
INTO  :admin_audit_file_id, :crmo
  }) || die $DBI::errstr;

Running on 

1.  RH Linux 3.0 and 4.0
2.  DBI v1.47
3.  DBD::Oracle v1.16
4.  Oracle v9.2.0.5.0; v10.2.1.0.3; v10.2.0.2.0

My files are around the order of 37Kb in size and I do nothing special
with them (aside from convert the text into XML).  My user has only
insert on the table with the XMLTYPE in it.

Does the user running the Perl program have INSERT privs on the table?
Is there a synonym issue or a role issue?

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.


-Original Message-
From: Paul Gallagher [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 12, 2007 12:04 PM
To: dbi-users@perl.org
Subject: DBD::Oracle - Any advance on inserting CLOB to XMLTYPE?

It seems the current state of affairs is that for inserting to XMLTYPE
fields:
a) for <32k, can just insert text
b) for >32k, must insert to CLOB, then use a procedure to update XMLTYPE
(see
http://www.issociate.de/board/post/206125/DBD::Oracle_and_XMLType.html
for a summary of the details)

Personally I've tried just about every trick in the book to try and
get a direct-insert of large xml documents into xmltype fields, but to
no avail.

What troubles me is that this _should_ work:
# NB: CREATE TABLE tryit ( formname VARCHAR(25), x XMLTYPE )
INSERT INTO tryit  (formname, x) VALUES (?, XMLTYPE(?))"

$sth = $dbh->prepare( "INSERT INTO tryit  (formname, x) VALUES (?,
XMLTYPE(?))" );
$sth->bind_param(1,  "INSERTXMLTYPE" );
$sth->bind_param(2, XMLout( \%dslong , RootName => "books"), { TYPE =>
SQL_CLOB } );
$sth->execute  or warn "INSERTXMLTYPE creation failure";

but it actually just gives ORA-00942: table or view does not exist.
this is a bogus message (search metalink for "XMLTYPE ORA-00942"). try
an alternative like "INSERT INTO tryit  (formname, x) VALUES (?,
XMLTYPE(CAST(? as CLOB)))" and you get ORA-00932: inconsistent
datatypes.

All of the above is old news I think.

Why I raise this now is that I discovered the python guys seem to have
got it working OK. See
http://blog.gmane.org/gmane.comp.python.db.cx-oracle/month=20050401

connection = cx_Oracle.Connection("user/pw  tns")
cursor = connection.cursor()
cursor.setinputsizes(value = cx_Oracle.CLOB)
cursor.execute("insert into xmltable values (xmltype(:value))",
value = "A very long XML string")

Seems very much like a binding issue on the DBI/DBD side.

Any thoughts?

~paul

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: :Oracle on Solaris 10 and Oracle 10g

[Reidy, Ron]

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: dbi-users@perl.org
Cc: Jay Tipton
Subject: DBD::Oracle on Solaris 10 and Oracle 10g

I am trying to get DBD::Oracle installed on a Solaris 10 system (64bit)
with
Oracle 10g.
I downloaded DBD-Oracle-1.19.

As root, I run  perl Makefile.PL , which seems to run successfully, but
when
I run make test, I get:
ld:fatal: file Oracle.o :  wrong ELF class: ELFCLASS32 

I can see no reference to this error in any of the READMEs, but it would
seem that it is a 
64 bit related problem?

Thanks for any help.


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Problem getting Perl and DBI to work in Win32 environment

[Reidy, Ron]

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, February 06, 2007 6:32 AM
To: dbi-users@perl.org
Subject: Problem getting Perl and DBI to work in Win32 environment

Don't follow the installation order for Perl and DBI module.

Getting the following error:

C:\Admin\COBRA\Cobra>trigger_cognos-DEV.pl
Can't locate loadable object for module DBI in @INC (@INC contains:
C:/Program Files/Perl/lib C:/Program Files/Perl/site/lib .) at
C:/Program Files/Perl/site/lib/DBI.pm line 259
BEGIN failed--compilation aborted at C:/Program
Files/Perl/site/lib/DBI.pm line 259.
Compilation failed in require at
C:\Admin\COBRA\Cobra\trigger_cognos-DEV.pl line 4.
BEGIN failed--compilation aborted at
C:\Admin\COBRA\Cobra\trigger_cognos-DEV.pl line 4.

DBI.pm says "# If you get an error here like "Can't find loadable object
..."
# then you haven't installed the DBI correctly. Read the README
# then install it again."

but I did run makefile.pl, but am confused about exactly what and in
what order things need to be done.

Kind regards,

Allen Alloway
Private Label Technology Services
Chase Card Services
Phone: (804) 727 6722
SDN network: 59-6722




**
This transmission may contain information that is privileged,
confidential, legally privileged, and/or exempt from disclosure under
applicable law. If you are not the intended recipient, you are hereby
notified that any disclosure, copying, distribution, or use of the
information contained herein (including any reliance thereon) is
STRICTLY PROHIBITED. Although this transmission and any attachments are
believed to be free of any virus or other defect that might affect any
computer system into which it is received and opened, it is the
responsibility of the recipient to ensure that it is virus free and no
responsibility is accepted by JPMorgan Chase & Co., its subsidiaries and
affiliates, as applicable, for any loss or damage arising in any way
from its use. If you received this transmission in error, please
immediately contact the sender and destroy the material in its entirety,
whether in electronic or hard copy format. Thank you.
**


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: DBD Oracle connection problem

[Reidy, Ron]

I saw the warnings, but I don't think they are a problem.

Are you the same user when you execute the Perl program and the sqlplus
command?  If not, do you have local tnsnames.ora and/or sqlnet.ora
files?

rr

-Original Message-
From: Terry Maragakis [mailto:[EMAIL PROTECTED] 
Sent: Friday, 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 can be created without a problem:

$dbh = DBI->connect("DBI:Oracle:",'scott/tiger','');  (works fine)

It is when I try to specify the database name as follows:

$dbh = DBI->connect("DBI:Oracle:D102L",'scott/tiger',''); 

that I am getting the error. I am getting an error when I try this as
well:

$dbh = DBI->connect("DBI:Oracle:",'[EMAIL PROTECTED]','tiger');

I did get a warning during compilation (see my original email) that may
be related to the problem.


-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Friday, February 02, 2007 2:01 PM
To: Terry Maragakis; dbi-users@perl.org
Subject: RE: DBD Oracle connection problem

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 in the
// TNSNAMES.ORA file.
// *Action:  Make the following checks and correct the error:
//   - Verify that a TNSNAMES.ORA file exists and is in the
proper
// place and accessible. See the operating system specific
manual
// for details on the required name and location.
//   - Check to see that the service name exists in one of the
// TNSNAMES.ORA files and add it if necessary.
//   - Make sure there are no syntax errors anywhere in the
file.
// Particularly look for unmatched parentheses or stray
characters.
// Any error in a TNSNAMES.ORA file makes it unusable. See
// Chapter 4 in the SQL*Net V2 Administrator's Guide. If
// possible, regenerate the configuration files using the
Oracle
// Network Manager.

So, from the machine you are trying to run the Perl program from, can
you:

1.  tnsping D102L
2.  sqlplus scott/[EMAIL PROTECTED]

What other environment variables might you have set (i.e. TWO_TASK)?

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Terry Maragakis [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 02, 2007 12:50 PM
To: dbi-users@perl.org
Subject: DBD Oracle connection problem

I am having a problem establishing a connection with my database.

 

The following connection specification in my program

 

$dbh = DBI->connect("DBI:Oracle:D102L",'scott/tiger','');

 

Is giving me the error:

 

DBI connect('D102L','scott/tiger',...) failed: ORA-12154: TNS:could not
resolve the connect identifier specified (DBD ERROR: OCIServerAttach) at
./test.pl line 17

 

When I have my environment variable ORACLE_SID set to  'D102L'  I can
establish the connection without specifying the database name:

 

$dbh = DBI->connect("DBI:Oracle:",'scott/tiger','');
(works fine)

 

I did get the following warnings during the DBD compilation, the problem
may be related to those:

 

dbdimp.c: In function `ora_db_login6':

dbdimp.c:385: warning: cast to pointer from integer of different size

dbdimp.c:399: warning: cast to pointer from integer of different size

dbdimp.c:409: warning: cast to pointer from integer of different size

dbdimp.c:413: warning: cast to pointer from integer of different size

dbdimp.c: In function `dbd_rebind_ph_char':

dbdimp.c:1169: warning: cast from pointer to integer of different size

 

 

sqlplus works without any problems.

 

 

The environment is Solaris 10 x86 64 bit. Oracle version is 10.2 64 bit
and I am running the perl program on the database server.

 

Any ideas?


This electronic message transmission is a PRIVATE communication which
contains
information which may be confidential or privileged. The information is
intended 
to be for the use of the individual or entity named above. If you are
not the 
intended recipient, please be aware that any disclosure, copying,
distribution 
or use of the contents of this information is prohibited. Please notify
the
sender  of the delivery error by replying to this message, or notify us
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: DBD Oracle connection problem

[Reidy, Ron]

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 in the
// TNSNAMES.ORA file.
// *Action:  Make the following checks and correct the error:
//   - Verify that a TNSNAMES.ORA file exists and is in the
proper
// place and accessible. See the operating system specific
manual
// for details on the required name and location.
//   - Check to see that the service name exists in one of the
// TNSNAMES.ORA files and add it if necessary.
//   - Make sure there are no syntax errors anywhere in the
file.
// Particularly look for unmatched parentheses or stray
characters.
// Any error in a TNSNAMES.ORA file makes it unusable. See
// Chapter 4 in the SQL*Net V2 Administrator's Guide. If
// possible, regenerate the configuration files using the
Oracle
// Network Manager.

So, from the machine you are trying to run the Perl program from, can
you:

1.  tnsping D102L
2.  sqlplus scott/[EMAIL PROTECTED]

What other environment variables might you have set (i.e. TWO_TASK)?

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Terry Maragakis [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 02, 2007 12:50 PM
To: dbi-users@perl.org
Subject: DBD Oracle connection problem

I am having a problem establishing a connection with my database.

 

The following connection specification in my program

 

$dbh = DBI->connect("DBI:Oracle:D102L",'scott/tiger','');

 

Is giving me the error:

 

DBI connect('D102L','scott/tiger',...) failed: ORA-12154: TNS:could not
resolve the connect identifier specified (DBD ERROR: OCIServerAttach) at
./test.pl line 17

 

When I have my environment variable ORACLE_SID set to  'D102L'  I can
establish the connection without specifying the database name:

 

$dbh = DBI->connect("DBI:Oracle:",'scott/tiger','');
(works fine)

 

I did get the following warnings during the DBD compilation, the problem
may be related to those:

 

dbdimp.c: In function `ora_db_login6':

dbdimp.c:385: warning: cast to pointer from integer of different size

dbdimp.c:399: warning: cast to pointer from integer of different size

dbdimp.c:409: warning: cast to pointer from integer of different size

dbdimp.c:413: warning: cast to pointer from integer of different size

dbdimp.c: In function `dbd_rebind_ph_char':

dbdimp.c:1169: warning: cast from pointer to integer of different size

 

 

sqlplus works without any problems.

 

 

The environment is Solaris 10 x86 64 bit. Oracle version is 10.2 64 bit
and I am running the perl program on the database server.

 

Any ideas?


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Installation of DBD Oracle

[Reidy, Ron]

How did you "try to install" DBD::Oracle?
What is the output of 'perl -V' on your solaris box?

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Anh Dao Nguyen [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 01, 2007 9:12 AM
To: dbi-users@perl.org
Subject: Installation of DBD Oracle

Hello,

After installing DBI, I tried to install DBD-Oracle-1.19 on my solaris
10 
(sparc 64bit).
I have Oracle Database 10g (10.2.0.1.0 - 64bit) installed on the
machine.

I got the following error messages:


ld: fatal: file Oracle.o: wrong ELF class: ELFCLASS32
ld: fatal: File processing errors. No output written to 
blib/arch/auto/DBD/Oracle/Oracle.so
*** Error code 1
make: Fatal error: Command failed for target 
`blib/arch/auto/DBD/Oracle/Oracle.so'


Could you please help me to solve the problem?
Thanks
Anh-Dao



This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: :Oracle, cursor_sharing, and ORA-01008

[Reidy, Ron]

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?
Is there some sort of incompatibility between the client and 10.2.0.3?
Can you connect via SQL*Plus from that web server?

Is there anything in the 10.2.0.3 release notes that suggest there is an
issue regarding cursor_sharing?

Have you logged an SR with Oracle support?  If not, you probably should.

--
Ron Reidy,
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Andrew McFarlane [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 31, 2007 3:31 PM
To: dbi-users@perl.org
Subject: DBD::Oracle, cursor_sharing, and ORA-01008

I ran into a problem with queries executed on an intranet site.  The web

server was running with Apache on a Windows XP Pro machine using DBI
1.53 
and DBD::Oracle 1.19.  The database server was upgraded from Oracle
10.2.0.2 
to 10.2.0.3.

As soon as the upgrade happened, all of my queries failed that were
using 
bound variables with the error: ORA-01008:  not all variables bound

I found a message on forums.oracle.com ( 
http://forums.oracle.com/forums/thread.jspa?messageID=1647779� )

that described the same issue as I was having.  As you can see from that

thread, the resolution was to change the server setting of
cursor_sharing to 
EXACT.

Other Oracle clients such as SQL*Plus were able to query the server 
successfully before the configuration change was made.

My questions are--why did I have to make the configuration change?  Why
can 
SQL*Plus handle the queries but Oracle::DBD 1.19 could not?

Thanks.

Andrew McFarlane

_
Valentine's Day -- Shop for gifts that spell L-O-V-E at MSN Shopping 
http://shopping.msn.com/content/shp/?ctId=8323,ptnrid=37,ptnrdata=24095&;
tcode=wlmtagline


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: error in locating loadable object in DBI module.

[Reidy, Ron]

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: dbi-users@perl.org
Subject: error in locating loadable object in DBI module.

Hi,

 

I am new to perl. I am using  Active state perl for windows XP
version5.8.8.

I am trying export data from text file to an remote sql server database
.I
have followed  the code given in URL
http://www.oreillynet.com/pub/a/databases/2006/12/21/dts-imports.html

.

But I am getting error in the module DBI.pm that is "can't locate
loadable
object for module DBi in @INC.

 

I have gone through the module where it is written it will show if
installation is wrong. But I am using active state perl  and I have
saved
the source file in perl lib folder.

So kindly help me out on this issue. Kindly let me know  what I have to
do
for proper installation.

 

 

Thanks And Regards,

 

Tapas Kumar Swain

Phone No-+919968106138

 

--
DISCLAIMER

This email and any files transmitted with it are confidential and are
solely for the use of the individual or entity to which it is addressed.
Any use, distribution, copying or disclosure by any other person is
strictly prohibited. If you receive this transmission in error, please
notify the sender by reply email and then destroy the message. Opinions,
conclusions and other information in this message that do not relate to
official business of the company shall be understood to be neither given
nor endorsed by NIIT Ltd. or NIIT Technologies Ltd. Any information
contained in this email, when addressed to Clients is subject to the
terms and conditions in governing client contract.


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Can't call method "prepare" on an undefined value

[Reidy, Ron]

Chong,

 

You have not left the realm of DBI/perl issues.  This is an Oracle
issue.  From the error docs:

 

$ oerr ora 1804

01804, 0, "failure to initialize timezone information"

// *Cause: The timezone information file was not properly read.

// *Action: Please contact Oracle Customer 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

 

Hi,

 

The error happen on the line to connect to that database:

$lda = &ora_login('','[EMAIL PROTECTED]','dlbest')

 

If I add "or die $ora_errstr" on the same line, it returns error below:

$lda = &ora_login('','[EMAIL PROTECTED]','dlbest') or die $oraerrstr;

 

(UNKNOWN OCI STATUS 1804) OCIInitialize. Check ORACLE_HOME and NLS
settings etc.

 at /oracle/app/http/dl/web/cgi/eppcd/ppcd_approval_ora.pl line 33.

 

I have set ORACLE_HOME and NLS env string on top of the perl script, but
still getting the same error.

This script is working fine I located the script in same server as the
database.

 

Please help.

Thanks a lot.

 

 

 

 



From: Reidy, Ron [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 31, 2007 12:19 AM
To: Chong, Wei-Ling; dbi-users@perl.org
Subject: RE: Can't call method "prepare" on an undefined value

 

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.  You should always use bind variables to avoid SQL injection.
4.  Line #92 looks suspicious to me - shouldn't there be two "\n"
characters to avoid the "premature end of script headers" error (see
http://htmlfixit.com/cgi-tutes/tutorial_Common_Web_dev_error_messages_an
d_what_they_mean.php)?

 

--

Ron Reidy

Lead DBA 

Array BioPharma, Inc.

 

 

 



From: Chong, Wei-Ling [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 30, 2007 3:23 AM
To: dbi-users@perl.org
Subject: Can't call method "prepare" on an undefined value

 

Hi, I have one oracle database located at server A and setup the Oracle
HTTP Server at Server B. Both server are Solaris server. I have
installed DBI and DBD into Server B and setup the oraperl in my perl
script.

When I run the perl script, I am getting error:

 

 

Can't call method "prepare" on an undefined value at
/oracle/app/http/product/OA

S10.1.2.0.2/perl/lib/site_perl/5.6.1/sun4-solaris/Oraperl.pm line 121.

[Tue Jan 30 16:39:26 2007] [error] [client 165.204.172.185] [ecid:
1170146365:16

5.204.178.123:1213:0:7,0] Premature end of script headers:
/oracle/app/http/dl/w

eb/cgi/eppcd/ppcd_approval_ora.pl

 

It works fine when the oraperl is located same server as the database. I
search through internet and it might due to connection string problem. I
am able to sqlplus to this database in Server B: sqlplus
[EMAIL PROTECTED]

 

Attached is my perl script. Is there any error on my oraperl code?

 

Please help, very appriate.

Thanks.

 

Best Regards,

Chong

 



This electronic message transmission is a PRIVATE communication which
contains information 
which may be confidential or privileged. The information is intended to
be for the use of the individual 
or entity named above. If you are not the intended recipient, please be
aware that any disclosure, 
copying, distribution or use of the contents of this information is
prohibited. Please notify the sender 
of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), 
and then delete it from your system.

RE: Clob insert problem on a Oracle db with DBI

[Reidy, Ron]

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 is missing commas.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Ron S Cetnar [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 30, 2007 1:10 PM
To: dbi-users@perl.org
Subject: Clob insert problem on a Oracle db with DBI

I have a problem inserting a line of text into a CLOB data field in
Oracle.  The version of PERL is 5.8 running on a AIX server 5.2.  It
looks like when I'm doing the insert, it is looking at the text to
execute.  The text is a sql statement that I'm trying to load.

Any help would be greatly appreciated.

Thanks.

Ron

Below is my insert statement and the error ORACLE error that I'm
getting.  

PERL statement to do the insert:



$sqlexec = qq{INSERT INTO ua_ps_sql_text_tble (sql_id,
sql_type, market, sql_text)
values ('$prog', '$ext', '$space_out',
'$sql_line')};
  $sth=$dbh->prepare($sqlexec); 
  $sth->execute;


On the 5th line down about 2/3 in is the <*> where the possble error
occurs:



DBD::Oracle::st execute failed: ORA-00917: missing comma (DBD ERROR:
error possibly near <*> indicator at char 367 in 'INSERT INTO
ua_ps_sql_text_tble (sql_id, sql_type, market, sql_text)
values ('uaad2dar', 'sqr', ' ', 'begin-SELECT
distinct  PROG.EMPLID NID.NATIONAL_ID prog.admit_term  from PS_ACAD_PROG
PROG,  PS_ACAD_PLAN PLAN, PS_PERS_NID NID where PROG.EMPLID \=
NID.EMPLID AND SYSDATE between (prog.action_dt - 5) and (prog.action_dt
+ 5) AND PROG.ACAD_CAREER \= \'<*>UGRD\' AND PROG.INSTITUTION \=
\'ALBNY\' AND PROG.PROG_STATUS \= \'AC\' AND PROG.acad_prog not in
(\'UNIHS\',\'GENS2\',\'GENST\',\'GENCO\',\'UIELP\',\'VISIT\',\'SANON\',\
'SASUN\',\'CROSS\',\'HSVIS\') AND PROG.EFFDT \=  (select max(EFFDT) from
PS_ACAD_PROG PROG1 where PROG1.EMPLID \= PROG.EMPLID  AND
PROG1.ACAD_CAREER \= PROG.ACAD_CAREER AND PROG1.STDNT_CAR_NBR \=
PROG.STDNT_CAR_NBR AND PROG1.PROG_STATUS \= \'AC\' AND PROG1.acad_prog
not in
(\'UNIHS\',\'GENS2\',\'GENST\',\'GENCO\',\'UIELP\',\'VISIT\',\'SANON\',\
'SASUN\',\'CROSS\',\'HSVIS\') AND PROG1.EFFDT <\= sysdate) AND
PROG.EFFSEQ \= (select max(EFFSEQ) from PS_ACAD_PROG PROG2 wh

*
Ron Cetnar
 
Supervising Programmer/Analyst/Oracle DBA
University applications Development (UAD)
 
Building:  Management Service Center - 100 
Room 110
1400 Washington Ave
Albany, NY 1
Work Phone:  518 437-4535
Fax Number:  518 437-4540
Email Address: [EMAIL PROTECTED]
 
**
 

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Can't call method "prepare" on an undefined value

[Reidy, Ron]

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.  You should always use bind variables to avoid SQL injection.
4.  Line #92 looks suspicious to me - shouldn't there be two "\n"
characters to avoid the "premature end of script headers" error (see
http://htmlfixit.com/cgi-tutes/tutorial_Common_Web_dev_error_messages_an
d_what_they_mean.php)?

 

--

Ron Reidy

Lead DBA 

Array BioPharma, Inc.

 

 

 



From: Chong, Wei-Ling [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 30, 2007 3:23 AM
To: dbi-users@perl.org
Subject: Can't call method "prepare" on an undefined value

 

Hi, I have one oracle database located at server A and setup the Oracle
HTTP Server at Server B. Both server are Solaris server. I have
installed DBI and DBD into Server B and setup the oraperl in my perl
script.

When I run the perl script, I am getting error:

 

 

Can't call method "prepare" on an undefined value at
/oracle/app/http/product/OA

S10.1.2.0.2/perl/lib/site_perl/5.6.1/sun4-solaris/Oraperl.pm line 121.

[Tue Jan 30 16:39:26 2007] [error] [client 165.204.172.185] [ecid:
1170146365:16

5.204.178.123:1213:0:7,0] Premature end of script headers:
/oracle/app/http/dl/w

eb/cgi/eppcd/ppcd_approval_ora.pl

 

It works fine when the oraperl is located same server as the database. I
search through internet and it might due to connection string problem. I
am able to sqlplus to this database in Server B: sqlplus
[EMAIL PROTECTED]

 

Attached is my perl script. Is there any error on my oraperl code?

 

Please help, very appriate.

Thanks.

 

Best Regards,

Chong

 


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: environment variable

[Reidy, Ron]

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
Array BioPharma, Inc.

-Original Message-
From: Oscar Gomez [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 17, 2007 8:59 AM
To: dbi-users@perl.org
Subject: environment variable

how can i export a variable from program perl to shell script through
environment 
variable.

Thank you

--
Open WebMail Project (http://openwebmail.org)


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: :Oracle: Row cache fetch ahead on cursor returned from PL/SQL stored proc?

[Reidy, Ron]

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 with tkprof for easy
reading.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc

-Original Message-
From: Joel Noble [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 19, 2007 11:07 AM
To: dbi-users@perl.org
Subject: DBD::Oracle: Row cache fetch ahead on cursor returned from
PL/SQL stored proc?


Hello, all!

I'm having slow performance reading from a cursor that is returned from
a stored procedure.  Network tracing and strace confirms that a
round-trip is being done to the Oracle DB to fetch each row, with no
pre-caching.  Using DBI-1.52, DBD-Oracle-1.18 on Linux with Perl 5.8.5
and the ora10202_32 client.

If I'm reading the DBD::Oracle docs correctly, a cursor returned from a
PL/SQL stored proc will be considered a "nested cursor" (even though
there are no cursors nested inside the rows returned).  So, I've set the
ora_max_nested_cursors and the RowCacheSize database handle attributes
right after connecting.  (I've also tried them in the connect.)  This
does not seem to change the behavior.

Here's some sample code I've culled out of my program.  Any ideas
welcome!

[...]

my $dbh =  DBI->connect( "dbi:Oracle:$config{'OracleDB'}", 
 $config{'OracleUser'}, 
 $config{'OraclePassword'},
  { RaiseError=> 1,
PrintError => 0,
AutoCommit => 1 } ) ;

$dbh->{RowCacheSize} = 10;
$dbh->{ora_max_nested_cursors} = 16;

##
## Pull cursor, dump to file
##

my $cursor;
my @errors;
open (DUMPFILE, '>', "/tmp/dumpfile.txt");

eval {
my $sth = $dbh->prepare( q{
  BEGIN
SOME_PKG.GET_CURSOR(:someid,:cursor );
  END;
} );
$sth->bind_param(":someid", 42);
$sth->bind_param_inout(":cursor", \$cursor, 0, {ora_type =>
ORA_RSET});
$sth->execute;
};

if ($@) {
print STDERR "$DBI::err -- $DBI::errstr\n";
} else {
while (my @row = $cursor->fetchrow_array) {
  print DUMPFILE join ("\t",@row) . "\n";
}
}

[...]



Thank you!

Joel Noble
[EMAIL PROTECTED]



This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Problems using an old version of DBI to connect to a remote Oracle 10g database

[Reidy, Ron]

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 08, 2007 9:04 AM
To: dbi-users@perl.org
Subject: Problems using an old version of DBI to connect to a remote
Oracle 10g database

Dear all,

Appreciate if someone can help me with this.

I have a Solaris 5.6 Generic_105181-33 box on which I have Perl version
5.005_03.
I also have Perl modules DBI (version 1.14) and DBD::Oracle (version
1.06 - I think?? - how can I check this?)
I am using the following string to connect to a remote Oracle 10g
instance:

my $dbh = DBI->connect
("dbi:Oracle:$environment",$nsm_login,$nsm_password) || die "Unable to
connect to $environment: $DBI::errstr\n";

...where $environment is the instance name - this is defined in
tnsnames.ora.

I am getting the following error:

ORA-03113: end-of-file on communication channel (DBD: login failed)

I can connect OK from the command line using:

sqlplus login/[EMAIL PROTECTED]

I suspect that I need newer versions of Perl, DBI and DBD.

Can anyone confirm this?

Thanks,
Dave S

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: regarding installing dbd-oracle

[Reidy, Ron]

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 trying to install DBD-Oracle i am getting the following error 
please help my os is windows 2000

E:\trans\install_software\DBD-Oracle-1.18>perl makefile.pl
*** Warning: Colons in the current directory path 
(E:/trans/install_software/D
-Oracle-1.18) may cause problems
Using DBI 1.38 installed in C:\iw-home\iw-perl\vendor\lib/auto/DBI

Configuring DBD::Oracle for perl 5.008002 on MSWin32 (MSWin32-x86-multi)

Remember to actually *READ* the README file! Especially if you have any 
proble
..

Using Oracle in E:/oracle/ora92
DEFINE _SQLPLUS_RELEASE = "902000100" (CHAR)
Oracle version 9.2.0.1 (9.2)
Found oci directory
Using OCI directory 'oci'
Found oci/lib/MSVC/oramts.lib library
Found oci/lib/MSVC/oratypes.lib library

  Unable to find required Oracle OCI files for the build.  Please 
check
  that you have your OCI installed in your oracle home 
(E:/oracle/ora92)
  directory and that it has the following files (and probably more):

E:/oracle/ora92\oci\include\oratypes.h
E:/oracle/ora92\oci\lib\MSVC\.lib

  Please install OCI or send comments back to dbi-users@perl.org
  if you have an OCI directory other than oci.

  Alternatively, if you're using ActiveState perl on Windows try
ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DBI.ppd
ppm install 
ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DBD-Oracle.ppd

   at makefile.pl line 258.

What to do ?


*
Regards & Thanks

B.Deepika Devi
Polaris Software Lab Limited
34 IT Highway, Navalur
Chennai-603103,  INDIA
Phone - 91-044-27435001  Extn - 6452
Mobile - 98414-57347


This e-Mail may contain proprietary and confidential information and is
sent for the intended recipient(s) only.  If by an addressing or
transmission error this mail has been misdirected to you, you are
requested to delete this mail immediately. You are also hereby notified
that any use, any form of reproduction, dissemination, copying,
disclosure, modification, distribution and/or publication of this e-mail
message, contents or its attachment other than by its intended
recipient/s is strictly prohibited.

Visit us at http://www.polaris.co.in

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Unix: Oracle User Identified Externally

[Reidy, Ron]

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 Externally

Tried this, but still not working.   DO you know how to determine which
version of DBI you are using?

Mark Cummings

-Original Message-----
From: Reidy, Ron [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 20, 2006 11:10 AM
To: Cummings, Mark; dbi-users@perl.org
Subject: RE: Unix: Oracle User Identified Externally

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] [mailto:[EMAIL PROTECTED]

Sent: Wednesday, December 20, 2006 10:58 AM
To: dbi-users@perl.org
Subject: Unix: Oracle User Identified Externally

I am migrating an Oracle 9i to Oracle 10g database, and Perl 5.0.4 to
Perl 5.8.7 in Sun Solaris environment.

My old Perl/DBI script was able to connect via this method:
use DBI;
$dbd = 'Oracle';
$user = '/'; $password = '/';
$dbh = DBI->connect ($dbname, $user, $password, $dbd);

This is not working with new version of Perl/DBI.

I have changed script to connect correctly:
use DBI;
$dbd = 'Oracle';
$user = 'scott'; $password = 'tiger';
$dbh = DBI->connect ("dbi:$dbd:$dbname",$user, $password);

But need to be able to connect with user identified externally (as
before).

I cannot find documentation on proper syntax or if a fix was made in
later version of DBI.

Can anyone help?

Mark Cummings


This electronic message transmission is a PRIVATE communication which
contains
information which may be confidential or privileged. The information is
intended 
to be for the use of the individual or entity named above. If you are
not the 
intended recipient, please be aware that any disclosure, copying,
distribution 
or use of the contents of this information is prohibited. Please notify
the
sender  of the delivery error by replying to this message, or notify us
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Unix: Oracle User Identified Externally

[Reidy, Ron]

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] [mailto:[EMAIL PROTECTED]

Sent: Wednesday, December 20, 2006 10:58 AM
To: dbi-users@perl.org
Subject: Unix: Oracle User Identified Externally

I am migrating an Oracle 9i to Oracle 10g database, and Perl 5.0.4 to
Perl 5.8.7 in Sun Solaris environment.

My old Perl/DBI script was able to connect via this method:
use DBI;
$dbd = 'Oracle';
$user = '/'; $password = '/';
$dbh = DBI->connect ($dbname, $user, $password, $dbd);

This is not working with new version of Perl/DBI.

I have changed script to connect correctly:
use DBI;
$dbd = 'Oracle';
$user = 'scott'; $password = 'tiger';
$dbh = DBI->connect ("dbi:$dbd:$dbname",$user, $password);

But need to be able to connect with user identified externally (as
before).

I cannot find documentation on proper syntax or if a fix was made in
later version of DBI.

Can anyone help?

Mark Cummings


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: DBD-Oracle and Oracle versions

[Reidy, Ron]

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, doesn't
the DBD::Oracle stop working?

Just my $0.02 worth.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Capacio, Paula J [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 19, 2006 1:16 PM
To: dbi-users@perl.org
Subject: DBD-Oracle and Oracle versions

>From lurking around this mail list over the years,
I've seen numerous items relating to building 
DBD-Oracle against a specific version of the Oracle
client software on *nix systems.  

Example: if DBD-Oracle was built using version 9, 
then the Oracle client is upgraded to 10g; 
it is necessary to rebuild DBD-Oracle with the 10g client.   

I have used Perl on HP/UNIX, AIX, Linux and Windows.
On the *nix systems, Perl came with the OS and I have
had to install the DBI and DBD-Oracle modules using 
the standard make process.  On windows, I used 
ActiveState Active Perl and PPM to install DBI and 
DBD-Oracle modules.  In the windows environment I 
never have to worry about which version of the Oracle
client is present and I can upgrade to a different 
client version of Oracle without having to reinstall 
the DBD-Oracle module.  

What trick allows PPM modules to work regardless of 
Oracle client versions?  Ultimately, I'd like to know 
if there is a way to 'make' the modules on *nix systems
so that they don't rely on a specific version?

Thanks in advance,
Paula

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Connecting to more than one Oracle database

[Reidy, Ron]

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 Message-
From: Malka Cymbalista [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 11, 2006 7:04 AM
To: modperl@perl.apache.org; dbi-users@perl.org
Subject: Re: Connecting to more than one Oracle database

Hello to all of you, Last week I sent an email asking how to connect to
more than one remote Oracle database.  My problem was that in my
startup.pl file, I am setting the following environment variables:
ORACLE_HOME, ORACLE_SID, TWO_TASK and TNS_ADMIN.  If I am trying to
connect to 2 different databases, then ORACLE_SID and TWO_TASK are not
the same and I did not know what to do.
SEveral people answered me and said that I should not define 
ORACLE_SID and TWO_TASK  in startup.pl but that I should define both
databases in tnsnames.ora and simply connect giving the name of the
database.  
 
So now, I am doing the following:
My tnsnames.ora looks like:
 
asdb =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = computer1.weizmann.ac.il)(PORT
= 1521))
)
(CONNECT_DATA =
  (SERVICE_NAME = asdb.weizmann.ac.il)
)
  )
 
asdb2 =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = computer2.weizmann.ac.il)(PORT
= 1521))
)
(CONNECT_DATA =
  (SID = ORCL92)
)
  )
I connect in the following manner:
 
DBI->connect("DBI:Oracle:asdb","user1","password1");
and
DBI->connect("DBI:Oracle:asdb2","user2","password2");
 
I have a script that works from the command line but does not work when
I run it from the web. When I run from the web it gives very
inconsistent results.  Sometimes it succeeds in connecting to the first
database I specify and sometimes it can't connect to either. I tried
specifying the environment variables ORACLE_SID and TWO_TASK from within
the script but that didn't seem to help consistently.  That is,
sometimes it worked and sometimes it didn't and we couldn't figure out
exactly when it would or would not work. 
Does anyone know how I can connect via the web to 2 different oracle
databases sitting on 2 different machines from within the same script.
 
Thanks for any help.
 
 
 
Malka Cymbalista
Webmaster, Weizmann Institute of Science
[EMAIL PROTECTED] 
08-934-3036

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: DBD Oracle: multiple statements in a single execute?

[Reidy, Ron]

'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
To: dbi-users@perl.org
Subject: DBD Oracle: multiple statements in a single execute?

Hi: my dba has asked to execute a alter statement before the select 
statement. So I need to run the following

alter session set db_file_multiblock_read_count = 128;
SELECT ED.utime, ED.info, ED.agent_id FROM EVENT_DATA ED WHERE ED.utime 
between $period order by ED.utime;

where $period is a string such as "190 and 300".

I tried the following
   my $sql = qq{
 BEGIN
alter session set db_file_multiblock_read_count = 128;
SELECT ED.utime, ED.info, ED.agent_id FROM EVENT_DATA ED
WHERE 
ED.utime between $period order by ED.utime;
 END; };
   print "Running\n$sql\n";
   my $sth = $dbh->prepare($sql);
   $sth->execute();


I get the following error

DBD::Oracle::st execute failed: ORA-06550: line 3, column 5:
PLS-00103: Encountered the symbol "ALTER" when expecting one of the 
following:

   begin case declare exit for goto if loop mod null pragma
   raise return select update while with 
 <<
   close current delete fetch lock insert open rollback
   savepoint set sql execute commit forall merge
pipe
The symbol "update was inserted before "ALTER" to continue. (DBD ERROR: 
error possibly near <*> indicator at char 14 in '
BEGIN
<*>alter session set 
db_file_multiblock_read_count = 128;
SELECT ED.utime, ED.info, ED.agent_id
FROM 
EVENT_DATA ED WHERE ED.utime between 1164650400 and 1164653940 order by 
ED.utime;
END; ') [for Statement "
BEGIN
alter session set 
db_file_multiblock_read_count = 128;
SELECT ED.utime, ED.info, ED.agent_id
FROM 
EVENT_DATA ED WHERE ED.utime between 1164650400 and 1164653940 order by 
ED.utime;
END; "] at 
/actuate/AcServer/reports_scripts/report_functions.pl line 48.
=

Could someone help.

Thanks
Ravi 



This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: DBI in a web context

[Reidy, Ron]

I would definitely wrap the entire transaction in an eval {}.  But, I'm
not sure if I would croak/die when a failure occurs vs. report the error
and go back.

rr

-Original Message-
From: Robert Hicks [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 10, 2006 1:40 PM
To: dbi-users@perl.org
Subject: DBI in a web context

I have a couple forms for an in-house application. The user fills out 
the fields and then submits which update a back end Oracle database.

I have looked for examples but can't really find anything.

How is it best to catch errors when doing DBI stuff in web applications?

Wrap the insert "code" in an eval statement? Croak or die statements? I 
am thinking eval because I can set autocommit to "off" and then do 
rollbacks if $@ has an error.

Suggestions and comments welcome?

Robert

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Bind variable question

[Reidy, Ron]

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 will
fail.  You will need to use 'EXECUTE IMMEDIATE' to perform this type of
action.

The PL/SQL documents and the Pro*C documents can give you light on how
this might be accomplished.  This type of coding may be beyond the
capabilities of DBD::Oracle (at least, I have not looked into this) and
you might need to resort to using OCI::Oracle to get this level of
control.

On another note, I as a DBA am horrified to see this type of coding
practice.  Building dynamic SQL, especially in a high transaction
environment, will wreak havoc on your instance's SGA.  This type of
application coding is the number one way to keep an application from
scaling.

Just something to think about.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Berlage, Steve [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 09, 2006 3:37 PM
To: dbi-users@perl.org
Subject: Bind variable question


Here is what I am trying to do:




$UPDATE_COMPANY_STRING = "ccompStreet = ?";

$UPDATE_COMPANY_VALUE_STRING = "\$tmpccompStreet";




$sql="UPDATE clientcomp SET $UPDATE_COMPANY_STRING WHERE ccompid = ?"; 


$sthUpdate = $dbh->prepare($sql);

$sthUpdate->execute($UPDATE_COMPANY_VALUE_STRING, $tmpstcompid);




Obviously there are many more fields that _may_ be added to the 2
variables that are in all caps (I only showed 1 for simplicity).  I only
add the fields that need to be updated to those 2 variables.  It does
what I expect it to do except for the last line.  I want the
$UPDATE_COMPANY_VALUE_STRING to be expanded to the actual string it
contains before the "execute" is run.  I've tried a bunch of different
ways to make it happen - all to no avail.  I either get errors or end up
with "$tmpccompStreet" in the database (instead of the value that
$tmpccompStreet contains).




Hopefully it's clear what I'm trying to accomplish here.  Please be kind
- I'm relatively new to pl/sql :)




Thanks,




Steve



Confidentiality Notice: The material in this e-mail is intended only for
the use of the individual to whom it is addressed and may contain
information that is confidential, privileged, and exempt from disclosure
under applicable law. If you are not the intended recipient, be advised
that the unauthorized use, disclosure, copying, distribution, or the
taking of any action in reliance on this information is strictly
prohibited. If you have received this e-mail in error, please
immediately notify us at 866-335-3289 to arrange for the return of this
material to us. Thank You.

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Insert/Update performance issues with Oracle 10gR2 + DBI + DBD::Oracle

[Reidy, Ron]

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: 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:

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.  Runs in a fraction of a second from sqlplus
3.  Takes 5 seconds(!) using Oracle 10gR2, DBI 1.53, DBD::Oracle
1.18 

 

The code is essentially as follows:

 

my $sql = "SELECT ...";

my $sth = $dbh->prepare( $sql ) || die "Preparing $sql\n";

$sth->execute || die "Died: $sql\n";

 

A DBI Trace around the $sth->execute where the 5s is spent shows the
foll:

 

 

DBI 1.53-nothread default trace level set to 0x0/10 (pid 24811)

>> prepare DISPATCH (DBI::db=HASH(0x9ca599c) rc1/2 @2 g0 ima2201
pid#24811) at test.pl line 30 via  at test.pl line 20

-> prepare for DBD::Oracle::db (DBI::db=HASH(0x9ca599c)~0x9ca84cc
'UPDATE job_descr SET phase_id = 2, status_id = 10039

   WHERE  jobid = 11576242')

New DBI::st (for DBD::Oracle::st, parent=DBI::db=HASH(0x9ca84cc),
id=)

dbih_setup_handle(DBI::st=HASH(0x9ca85f8)=>DBI::st=HASH(0x9ca8a10),
DBD::Oracle::st, 9ca8604, Null!)

dbih_make_com(DBI::db=HASH(0x9ca84cc), 9ca8790, DBD::Oracle::st,
216, 0) thr#0

dbih_setup_attrib(DBI::st=HASH(0x9ca8a10), Err,
DBI::db=HASH(0x9ca84cc)) SCALAR(0x9abf0f4) (already defined)

dbih_setup_attrib(DBI::st=HASH(0x9ca8a10), State,
DBI::db=HASH(0x9ca84cc)) SCALAR(0x9abf154) (already defined)

dbih_setup_attrib(DBI::st=HASH(0x9ca8a10), Errstr,
DBI::db=HASH(0x9ca84cc)) SCALAR(0x9abf124) (already defined)

dbih_setup_attrib(DBI::st=HASH(0x9ca8a10), TraceLevel,
DBI::db=HASH(0x9ca84cc)) 0 (already defined)

dbih_setup_attrib(DBI::st=HASH(0x9ca8a10), FetchHashKeyName,
DBI::db=HASH(0x9ca84cc)) 'NAME' (already defined)

dbih_setup_attrib(DBI::st=HASH(0x9ca8a10), HandleSetErr,
DBI::db=HASH(0x9ca84cc)) undef (not defined)

dbih_setup_attrib(DBI::st=HASH(0x9ca8a10), HandleError,
DBI::db=HASH(0x9ca84cc)) undef (not defined)

OCIHandleAlloc(9cc5208,9d05d80,OCI_HTYPE_STMT,0,0)=SUCCESS

OCIStmtPrepare(9ce426c,9cdbf90,'UPDATE job_descr SET phase_id =
2, status_id = 10039

   WHERE  jobid = 11576242',91,1,0)=SUCCESS

OCIAttrGet(9ce426c,OCI_HTYPE_STMT,9d05d84,0,24,9cdbf90)=SUCCESS

dbd_st_prepare'd sql UPDATE (pl1, auto_lob1, check_sql1)

dbd_describe skipped for UPDATE

<- prepare= DBI::st=HASH(0x9ca85f8) at test.pl line 30 via  at
test.pl line 20

 

 

Before execute

>> execute DISPATCH (DBI::st=HASH(0x9ca85f8) rc1/1 @1 g0 ima1041
pid#24811) at test.pl line 33 via  at test.pl line 20

-> execute for DBD::Oracle::st (DBI::st=HASH(0x9ca85f8)~0x9ca8a10)

dbd_st_execute UPDATE (out0, lob0)... 

HERE IS WHERE THE CONNECTION SEEMS TO BLOCK

OCIStmtExecute(9cdbf1c,9ce426c,9cdbf90,1,0,0,0,32)=SUCCESS

OCIAttrGet(9ce426c,OCI_HTYPE_STMT,bfffa7b8,0,9,9cdbf90)=SUCCESS

OCIAttrGet(9ce426c,OCI_HTYPE_STMT,bfffa7b6,0,10,9cdbf90)=SUCCESS

dbd_st_execute UPDATE returned (SUCCESS, rpc1, fn5, out0)

<- execute= 1 at test.pl line 33 via  at test.pl line 20

After execute

 

 

>> DESTROY DISPATCH (DBI::st=HASH(0x9ca85f8) rc1/1 @1 g0 ima4
pid#24811) at test.pl line 20 via  at test.pl line 20

<> DESTROY(DBI::st=HASH(0x9ca85f8)) ignored for outer handle (inner
DBI::st=HASH(0x9ca8a10) has ref cnt 1)

>> DESTROY DISPATCH (DBI::st=HASH(0x9ca8a10) rc1/1 @1 g0 ima4
pid#24811) at test.pl line 20 via  at test.pl line 20

-> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x9ca8a10)~INNER)

dbd_st_destroy

OCIHandleFree(9ce426c,OCI_HTYPE_STMT)=SUCCESS

<- DESTROY= undef at test.pl line 20 via  at test.pl line 20

DESTROY (dbih_clearcom) (sth 0x9ca8a10, com 0x9d05d00, imp
DBD::Oracle::st):

   FLAGS 0x182591: COMSET Warn RaiseError PrintError PrintWarn
ShowErrorStatement LongTruncOk

   PARENT DBI::db=HASH(0x9ca84cc)

   KIDS 0 (0 Active)

   IMP_DATA undef

   LongReadLen 64000

   NUM_OF_FIELDS -1

   NUM_OF_PARAMS 0

dbih_clearcom 0x9ca8a10 (com 0x9d05d00, type 3) done.

 

ELAPSED: 5.100781

 

 

Any help will be much appreciated.

 


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclos

RE: DBI - error

[Reidy, Ron]

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 


Hi,
 
I am trying to execute the stored procedure using dbh. The procedure
details are as follows: 
proc_dequeue( BALID,strRequestXML,strStatus)
 
where: 
BALID - Integer,
strRequestXML - XMLType,
strStatus - varchar
 
The perl script implemented is : 
 
my $sth = $dbh1->prepare("begin
proc_dequeue(:BALID,:strRequestXML,:strStatus); end;");
 
$sth->bind_param_inout(":BALID",\$o_balid,20,\%attr );
$sth->bind_param_inout(":strRequestXML",\$o_requestXML,5,\%attr);
$sth->bind_param_inout(":strStatus",\$o_status,2,\%attr);
 
and the error message i am getting is :
 
DBD::Oracle::st execute failed: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'proc_dequeue'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored (DBD ERROR: OCIStmtExecute) at ./ListenerBalA
line 32.
DBD::Oracle::st execute failed: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'proc_dequeue'
 
Please help me to resolve this problem.
 
Thanks in advance.
 
Regards,
Sumitra

 

 






Tech Mahindra, formerly Mahindra-British Telecom.
 
Disclaimer:

This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review at http://www.techmahindra.com/Disclaimer.html";>http://www.techmahind
ra.com/Disclaimer.html externally and http://tim.techmahindra.com/Disclaimer.html";>http://tim.techmahind
ra.com/Disclaimer.html internally within Tech Mahindra.




This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Unlink command fails as well system call fails sometimes...

[Reidy, Ron]

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 code...

 

It is failing sometimes...

 

How to check the retzrn code...

 

Regards

Selva

 Message d'origine 
    De: Reidy, Ron 
Date: sam. 21.10.2006 00:06 
À: Ammayappa SELVAKUMAR; dbi-users@perl.org 
Cc: 
Objet: RE: Unlink command fails as well system call fails sometimes...

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 a file .

Some times it deletes and sometimes it is not...

I tried with system call(rm command)...

This also works sometimes and sometimes it is not...



Could any one help me...



Regards

Selva






This electronic message transmission is a PRIVATE communication which 
contains
information which may be confidential or privileged. The information is 
intended
to be for the use of the individual or entity named above. If you are 
not the
intended recipient, please be aware that any disclosure, copying, 
distribution
or use of the contents of this information is prohibited. Please notify 
the
sender  of the delivery error by replying to this message, or notify us 
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Unlink command fails as well system call fails sometimes...

[Reidy, Ron]

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 a file .

Some times it deletes and sometimes it is not...

I tried with system call(rm command)...

This also works sometimes and sometimes it is not...

 

Could any one help me...

 

Regards

Selva

 

 


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Does any one experiencing this problem?

[Reidy, Ron]

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.

-Original Message-
From: Kong, Alan [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 22, 2006 10:09 AM
To: Alexander Foken
Cc: dbi-users@perl.org
Subject: RE: Does any one experiencing this problem?

Alexander,

This is the problem for me because I am using PERL as CGI for web
applications where the script is querying the data from Oracle database.
And if the process is taking too long to return the data to user
browser, sometimes, the user will then close the browser or click "STOP"
in the browser.  In that case, the Oracle process will be staying there
forever.  This led to the problem of Oracle backup process which is
waiting for all processes to complete.  Therefore, we need to do a clean
up on those orphan processes periodically.  But because of all Oracle
child processes initiated by PERL are with parent id of 1, the clean up
process doesn't know which one is supposed to removed.

Thanks in advance.
Alan



-Original Message-
From: Alexander Foken [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 22, 2006 11:49 AM
To: Kong, Alan
Cc: dbi-users@perl.org
Subject: Re: Does any one experiencing this problem?

Why is that a problem for you?

If you are running some kind of Unix, process 1 is init ("the parent of
all processes"), new processes with a parent id of 1 are simply new,
independant process groups, that do not get killed when the process
group with your perl script is killed. (I think this is an isolated
transaction-handling process forked by the oracle client library.)  man
2 setsid

If you are running Windows, ID 1 is NOT special.

Alexander

On 22.09.2006 17:27, Kong, Alan wrote:
> Hi all,
>
> My system is running an Oracle10G server with PERL DBI, whenever I run

> the perl scripts with DBD connect, there will be an Oracle sub-process

> with parent ID of 1.  Normally, the sub-process should have a parent 
> ID = pid of the perl script.  Running any other scripts with SQL*PLUS 
> is behaving normal though.
>
> Does anyone have experience the same problem before?
>
> Thanks,
> Alan
>
>   


--
Alexander Foken
mailto:[EMAIL PROTECTED]  http://www.foken.de/alexander/


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: switching perl version

[Reidy, Ron]

The differences are big.  I won't go into them here because these are
off topic, but if your DB was an 8.1 and migrated in place to 10g, you
will have performance problems, especially if there were no changes made
to init parameters, you changes hardware platforms (word size), etc.

Another poster said Perl is the last place you should look, and I agree.
Your issues are almost assuredly database centric.  You should eliminate
this as a candidate before you do anything else and the best way to do
this is process profiling using 10046 trace files to determine the
issues.

Cary Milsap has a really exceptional book on this subject -
http://www.oreilly.com/catalog/optoraclep/.  You should get a copy and
read it several times because it is a bigger subject than most can
imagine.

You should also be looking on metalink for answers on how to trace
sessions, although the links I sent you the other day should work fine
for starters.

Performance issues are a large vague subject and until you can pinpoint
the issues, you are like a cat chasing its tail - lots of effort, little
reward or progress.

rr

-Original Message-
From: Oscar Gomez [mailto:[EMAIL PROTECTED] 
Sent: Friday, 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.

thanks a lot 
--
Open WebMail Project (http://openwebmail.org)


-- Original Message ---
From: "Reidy, Ron" <[EMAIL PROTECTED]>
To: "Oscar Gomez" <[EMAIL PROTECTED]>, 
Sent: Fri, 8 Sep 2006 09:26:47 -0600
Subject: RE: switching perl version

> 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
> Subject: switching perl version
> 
> A perl program executing in linux Redhat 7.0, perl version 5.6,
>  oracle 8i was using 30% cpu approx. Now I'm running the same 
> program in linux enterprise ES 4, perl v. 5.8.5, Oracle 10g. uses 
> 60% cpu. I'd like to know what's happening because the performance 
> is slower and the difference is wide big. Do you think this perl new 
> version (5.8.5) takes more cpu ? I appreciate any idea you could 
> give me to improve my performance.
> 
> --
> Open WebMail Project (http://openwebmail.org)
> 
> This electronic message transmission is a PRIVATE communication 
> which contains information which may be confidential or privileged. 
> The information is intended to be for the use of the individual or 
> entity named above. If you are not the intended recipient, please be 
> aware that any disclosure, copying, distribution or use of the 
> contents of this information is prohibited. Please notify the sender 
>  of the delivery error by replying to this message, or notify us by 
> telephone (877-633-2436, ext. 0), and then delete it from your system.
--- End of Original Message ---

RE: switching perl version

[Reidy, Ron]

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
Subject: switching perl version

A perl program executing in linux Redhat 7.0, perl version 5.6, oracle
8i was
using 30% cpu approx. Now I'm running the same program in linux
enterprise ES 4,
perl v. 5.8.5, Oracle 10g. uses 60% cpu. I'd like to know what's
happening
because the performance is slower and the difference is wide big.
Do you think this perl new version (5.8.5) takes more cpu ?
I appreciate any idea you could give me to improve my performance.

--
Open WebMail Project (http://openwebmail.org)


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Oracle TAF with DBD::Oracle???

[Reidy, Ron]

Andre,

Can you tnsping liprod02?  Can you connect to liprod02 via SQL*Plus?

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Andre Heine [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 07, 2006 10:09 AM
To: dbi-users@perl.org
Subject: Oracle TAF with DBD::Oracle???

Hello @all,

can someone help me with my Oracle TAF Problem?

I'm trying to write an DBI script, that should use Failover (Oracles
TAF).
But I can't connect to the "SERVICE_NAME", when I used the
"INSTANCE_NAME" the 
connect works fine.

Is there a way to use DBI/DBD::Oracle with TAF?

Thanks for any hints

Greetings from germany

Andre

 
Won't work:
my $dbh = DBI->connect("dbi:Oracle:LIPROD02",'user','pass',
 {RaiseError => 1, AutoCommit =>
1 })  
  or die "$DBI::errstr";

Works fine:
my $dbh = DBI->connect("dbi:Oracle:LIPROD021",'user','pass',
 {RaiseError => 1, AutoCommit =>
1 })  
  or die "$DBI::errstr";


--tnsnames.ora--
---


LIPROD02 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.60)(PORT = ))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.59)(PORT = ))
(LOAD_BALANCE = yes)
(FAILOVER=on)
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = liprod02)
)
  )

LIPROD021 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.60)(PORT = ))
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = liprod02)
  (INSTANCE_NAME = liprod021)
)
  )

LIPROD022 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.9.59)(PORT = ))
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = liprod02)
  (INSTANCE_NAME = liprod022)
)
  )

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: processor use

[Reidy, Ron]

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: Wednesday, September 06, 2006 1:55 PM
To: dbi-users@perl.org
Subject: processor use

I did migration from oracle 8i, linux Redhat 7.0 to oracle 10g linux
Enterprise Es. programs Perl were but slow, the question is if I can
compile
the programs in Perl or give priority to some programs when executing.
I think that the problem is processor use.
any ideas
thanks

--
Open WebMail Project (http://openwebmail.org)


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: :ODBC::st execute failed: [unixODBC]ERROR: crossed reserve : Out of memory

[Reidy, Ron]

So, which is it - errors at 3.8M rows, or 350K rows?  When you get
errors at 350K, are you array fetching or row-at-a-time fetching?  What
does -1 mean in the error message?

-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 05, 2006 12:15 PM
To: Loo, Peter # PHX; Reidy, Ron; DBI-Users
Subject: RE: :ODBC::st execute failed: [unixODBC]ERROR: crossed reserve
: Out of memory


Now I am getting the following error after fetching approximately
350,000 rows.

DBD::ODBC::st fetch failed: [unixODBC] (SQL-)(DBD: st_fetch/SQLFetch
err=-1) at /usr/local/apps/ppv/devl/bin/sdl.pl line 228,  line 53. 

Peter

-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 05, 2006 10:45 AM
To: Reidy, Ron; DBI-Users
Subject: RE: :ODBC::st execute failed: [unixODBC]ERROR: crossed reserve
: Out of memory


Hi Ron,

I am returning approximately 3.8 million rows.  Here is the code:

  $sqlString = qq{ select   distinct x.ptnt_gid, x.prdct_gid,
x.rx_fill_dte,
 x.claim_gid, x.ovrd_days_sply_nbr,
 x.clfsn_grace_prd_nbr, 'N',
 x.rx_fill_dte +
x.ovrd_days_sply_nbr,
 x.rx_fill_dte -
to_date('1980-01-01', '-MM-DD'),
 x.rx_fill_dte +
(x.ovrd_days_sply_nbr * 2)
   from p_dlvrb_rx_claim_extract x,
p_dlvrb_ptnt_list y
   wherex.dlvrb_gid = y.dlvrb_gid
   and  x.ptnt_gid = y.ptnt_gid
   order by x.ptnt_gid, x.prdct_gid, x.rx_fill_dte,
x.claim_gid };
  $sqlString =~ s/\s+/ /g;
  print STDERR "sqlString is: $sqlString\n";
  $sth = sub_prepare($driver, $dbh, $sqlString);
  $sth = sub_execute($driver, $dbh, $sth);
  my ($ptnt, $prdct, $fill_dte, $claim, $days_sply, $grace, $class,
$cted, $since);
  $sth->bind_columns( undef, \$ptnt, \$prdct, \$fill_dte, \$claim,
\$days_sply, \$grace, \$class, \$cted, \$since, \$twice ); 


LINE 88 of GlobalRoutines.pm

  sub sub_execute($$$) {
print STDERR "\n* sub_execute() *\n\n";
my ($dbDriver, $dbh, $sth) = @_;
print STDERR "DATABASE DRIVER IS: $dbDriver\n";
print STDERR "DATABASE HANDLE IS: $dbh\n";
print STDERR "STATEMENT HANDLE IS:$sth\n";
eval { $sth->execute(); };<<<<<<<<<<<<<<<<<<<<<<
if ($@) {
  $MESSAGE = "sub_execute() - $@";
  $STATUS = $FAILURE;
  sub_exit();
      }
print STDERR "RETURN STATEMENT HANDLE IS: $sth\n\n";
return($sth);
} #<=== (End of sub_execute)

 
Peter

-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 05, 2006 10:41 AM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: :ODBC::st execute failed: [unixODBC]ERROR: crossed reserve
: Out of memory

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: DBI-Users
Subject: DBD::ODBC::st execute failed: [unixODBC]ERROR: crossed reserve
: Out of memory

Hi,
 
Will you kindly tell me what this error message is talking about?
 
DBD::ODBC::st execute failed: [unixODBC]ERROR:  crossed reserve : Out of
memory
 (SQL-HY000)(DBD: st_execute/SQLExecute err=-1) at
/usr/local/apps/common/devl/bin/GlobalRoutines.pm line 88,  line 53.
 
Thanks.
 
Peter

This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended to be for the use of the individual or entity
named above. If you are not the intended recipient, please be aware that
any disclosure, copying, distribution or use of the contents of this
information is prohibited. Please notify the sender  of the delivery
error by replying to this message, or notify us by telephone
(877-633-2436, ext. 0), and then delete it from your system.



This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.


This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.

RE: :ODBC::st execute failed: [unixODBC]ERROR: crossed reserve : Out of memory

[Reidy, Ron]

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: DBI-Users
Subject: DBD::ODBC::st execute failed: [unixODBC]ERROR: crossed reserve
: Out of memory

Hi,
 
Will you kindly tell me what this error message is talking about?
 
DBD::ODBC::st execute failed: [unixODBC]ERROR:  crossed reserve : Out of
memory
 (SQL-HY000)(DBD: st_execute/SQLExecute err=-1) at
/usr/local/apps/common/devl/bin/GlobalRoutines.pm line 88,  line 53.
 
Thanks.
 
Peter

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Oralce10g database compatible Perl version, DBD and DBI -on URGENT Basis

[Reidy, Ron]

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,

Currently I'm using perl version 5.6.1 with DBD-Oracle v1.15 and Perl
DBI v1.28 in Oracle9i database. 
Kindly let me know if these version is compatible against Oracle 10g
database.

Best Regards,
Sasikala,
GPSy Development Team,
HP-GDIC,Chennai,India,
Ph:+91-44-3985 3015.  


-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 25, 2006 7:31 PM
To: Elangovan, Sasikala
Cc: Jared Still; dbi-users@perl.org
Subject: RE: Oralce10g database compatible Perl version, DBD and DBI -on
URGENT Basis

Please go to perl.com and download the current stable version of the
Perl source code.  It will be called stable.tar.gz.

The version is 5.8.something.

On Fri, 2006-08-25 at 09:51 +0530, Elangovan, Sasikala wrote:
> Hi,
>  
> I am new to this enviroinment. Kindly mention the version explicitly.
>  
> 
> Best Regards,
> Sasikala,
> GPSy Development Team,
> HP-GDIC,Chennai,India,
> Ph:+91-44-3985 3015.  
> 
>  
> 
> 
> 
> From: Jared Still [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 24, 2006 11:21 PM
> To: Elangovan, Sasikala
> Cc: dbi-users@perl.org
> Subject: Re: Oralce10g database compatible Perl version, DBD and DBI
> 
> 
> The current one.
> 
> 
> On 8/24/06, Elangovan, Sasikala <[EMAIL PROTECTED]> wrote: 
> 
> 
>   Hi,
>   
>   I would like to know the Oralce10g database compatible Perl
version, 
> DBD
>   and DBI.This will be used in HP-UX11V2 O/S.
>   
>   
>   Best Regards,
>   Sasikala,
>   GPSy Development Team,
>   HP-GDIC,Chennai,India, 
>   Ph:+91-44-3985 3015.
>   
> 
> 
> 
> 


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: ORA-01017 ... but only when script is run as CGI

[Reidy, Ron]

So, there is no private tnsnames.ora nor $TNS_ADMIN defined on the
server (or in httpd.conf) at all?  I ask again, because if either of
these situations exists, that would explain the problem.

BTW - Having Apache in the same group as the oracle software might be a
gaping security hole.  Just 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 to that same DB instance using
> SQL*plus?

sqlplus connects without problems, using the same username and password
as
the script (as mentioned, the script runs fine from the command line,
but
fails to connect when run as a CGI).

> Does your CGI have use the same tnsnames.ora file as the
> command line user?

As far as I know, yes. It's using the same $ORACLE_HOME. The
'tnsnames.ora' file is world-readable (and in any case, the 'apache'
user
has been added to the 'oracle' group that owns all the files in the
Oracle
install).

Thanks for your help,

Angus

> --
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.
>
> -Original Message-
> From: Angus McIntyre [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 18, 2006 10:39 AM
> To: dbi-users@perl.org
> Subject: ORA-01017 ... but only when script is run as CGI
>
> I'm using current versions of DBI and DBD::Oracle in a CGI script,
> Oracle
> 10.2 client talking to an Oracle 9 database, RedHat Linux. The script
> previously ran successfully on a similar machine with the Oracle 9
> client.
>
> I have a simple test script, in which the username, password and SID
are
> hardcoded. If I run this script from the command line, it connects
> without
> problems.
>
> If I call the script as a CGI script, I get ORA-01017 in
> OCISessionBegin,
> which is the bad username or password error.
>
> As far as I can tell, environment variables are the same in both
> contexts,
> the same tnsnames.ora file is used, and so forth. I have identified
and
> resolved permissions errors, so I think that isn't the problem.
>
> Has anyone encountered something similar, or does anyone have any
> suggestions for other things that I should check in order to resolve
> this?
>
> Thanks,
>
> Angus
>
>
> This electronic message transmission is a PRIVATE communication which
> contains
> information which may be confidential or privileged. The information
is
> intended
> to be for the use of the individual or entity named above. If you are
not
> the
> intended recipient, please be aware that any disclosure, copying,
> distribution
> or use of the contents of this information is prohibited. Please
notify
> the
> sender  of the delivery error by replying to this message, or notify
us by
> telephone (877-633-2436, ext. 0), and then delete it from your system.
>
>
>

RE: ORA-01017 ... but only when script is run as CGI

[Reidy, Ron]

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, 2006 10:39 AM
To: dbi-users@perl.org
Subject: ORA-01017 ... but only when script is run as CGI

I'm using current versions of DBI and DBD::Oracle in a CGI script,
Oracle
10.2 client talking to an Oracle 9 database, RedHat Linux. The script
previously ran successfully on a similar machine with the Oracle 9
client.

I have a simple test script, in which the username, password and SID are
hardcoded. If I run this script from the command line, it connects
without
problems.

If I call the script as a CGI script, I get ORA-01017 in
OCISessionBegin,
which is the bad username or password error.

As far as I can tell, environment variables are the same in both
contexts,
the same tnsnames.ora file is used, and so forth. I have identified and
resolved permissions errors, so I think that isn't the problem.

Has anyone encountered something similar, or does anyone have any
suggestions for other things that I should check in order to resolve
this?

Thanks,

Angus


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: what to do ?

[Reidy, Ron]

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 to do ?

Hi,

i have oci installed in my system ,i am trying to connect oracle client
to 
oracle server using perl coding , since i dont have dbd-oracle in my 
system , i am trying to install it , and when i try to execute perl 
makefile .pl command , it says to check for the following files

 D:/oracle/ora92\oci\include\oratypes.h
 D:/oracle/ora92\oci\lib\MSVC\.lib

but it is not available in my system , only these are available
 
 D:/oracle/ora92\oci\include\oramts.h
 D:/oracle/ora92\oci\lib\MSVC\oramts.lib

 what to do ?

*
Regards & Thanks

B.Deepika Devi
Polaris Software Lab Limited
34 IT Highway, Navalur
Chennai-603103,  INDIA
Phone - 91-044-27435001  Extn - 6452
Mobile - 98414-57347

This e-Mail may contain proprietary and confidential information and is
sent for the intended recipient(s) only.  If by an addressing or
transmission error this mail has been misdirected to you, you are
requested to delete this mail immediately. You are also hereby notified
that any use, any form of reproduction, dissemination, copying,
disclosure, modification, distribution and/or publication of this e-mail
message, contents or its attachment other than by its intended
recipient/s is strictly prohibited.

Visit us at http://www.polaris.co.in

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Using Oracle Internet Directory (OID) instead of TNS Names

[Reidy, Ron]

Does SQL*Plus do this correctly from the same machine you are running
the Perl scripts?  It should work the same because DBD::Oracle uses the
OCI to perform it's actions.  This means it still uses the O3LOGON
functionality.

Can you write a simple Perl script that will just connect and disconnect
from the database and then perform an strace on it and a SQL*Plus
session to that same database instance?  This might tell you where
things are going wrong.

Also, what happens if you reverse the order of lookup(ldap then
tnsnames)?  Does it work then?  If so, I would post a SR with Oracle
support 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) instead of TNS Names


Hi Ron,

According to our *.ora files, everything appears to be set up correctly.
However, whenever Perl DBI attempts to connect to an INSTANCE that is
not defined in tnsnames.ora file, the Perl program is unable to
continue.

What we are hoping that Perl DBI would do for us is to perform somewhat
like sqlplus.  When we issue the following command at shell prompt, even
if the INSTANCE name is not listed in tnsnames.ora file, sqlplus would
find the instance.   

$ sqlplus [EMAIL PROTECTED]

someInstance does not exist in the tnsnames.ora file, but somehow
sqlplus still finds it.
 
Peter

-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 15, 2006 2:27 PM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names

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 Ron,

We currently have the following configuration.  I am assuming that in
order for Perl DBI to use OID, LDAP has to be the first in the list?

NAMES.DIRECTORY_PATH= (tnsnames, ldap) 
 
Peter

-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 15, 2006 1:28 PM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names

That's right.  You will need:

1.  A sqlnet.ora file which designates the search method:
names.directory_path=(LDAP)
2.  A ldap.ora file that describes the location of your OID instance:
Default_admin_context = "dc=xx,dc=yy,dc=com"
Directory_server=(server.domain.com:non-ssl_port:ssl_port)
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 Names

Hi Ron,

I meant, not using TNS files and instead using Oracle OLAP. 
 
Peter

-Original Message-----
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 10:54 AM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names

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 PROTECTED]
Sent: Tuesday, August 15, 2006 11:40 AM
To: DBI-Users
Subject: Using Oracle Internet Directory (OID) instead of TNS Names

Hi All,
 
Does the current Perl DBI support Oracle Internet Directory?  If so,
how/where would I go to find out more on how to use this functionality?
 
Thanks.
 
Peter

This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended to be for the use of the individual or entity
named above. If you are not the intended recipient, please be aware that
any disclosure, copying, distribution or use of the contents of this
information is prohibited. Please notify the sender  of the delivery
error by replying to this message, or notify us by telephone
(877-633-2436, ext. 0), and then delete it from your system.



This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.


This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disc

RE: Using Oracle Internet Directory (OID) instead of TNS Names

[Reidy, Ron]

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 Ron,

We currently have the following configuration.  I am assuming that in
order for Perl DBI to use OID, LDAP has to be the first in the list?

NAMES.DIRECTORY_PATH= (tnsnames, ldap) 
 
Peter

-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 15, 2006 1:28 PM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names

That's right.  You will need:

1.  A sqlnet.ora file which designates the search method:
names.directory_path=(LDAP)
2.  A ldap.ora file that describes the location of your OID instance:
Default_admin_context = "dc=xx,dc=yy,dc=com"
Directory_server=(server.domain.com:non-ssl_port:ssl_port)
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 Names

Hi Ron,

I meant, not using TNS files and instead using Oracle OLAP. 
 
Peter

-Original Message-----
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 10:54 AM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names

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 PROTECTED]
Sent: Tuesday, August 15, 2006 11:40 AM
To: DBI-Users
Subject: Using Oracle Internet Directory (OID) instead of TNS Names

Hi All,
 
Does the current Perl DBI support Oracle Internet Directory?  If so,
how/where would I go to find out more on how to use this functionality?
 
Thanks.
 
Peter

This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended to be for the use of the individual or entity
named above. If you are not the intended recipient, please be aware that
any disclosure, copying, distribution or use of the contents of this
information is prohibited. Please notify the sender  of the delivery
error by replying to this message, or notify us by telephone
(877-633-2436, ext. 0), and then delete it from your system.



This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.


This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.

RE: Using Oracle Internet Directory (OID) instead of TNS Names

[Reidy, Ron]

Peter,

You're welcome.  Not planning a trip to Phoenix soon, but I'll keep that
in mind.

rr

-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 15, 2006 2:32 PM
To: Reidy, Ron; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names


Thanks Ron.  You have been most helpful.  Look me up when you are in
Phoenix.  I will buy you lunch.  :D 
 
Peter

-Original Message-----
From: Reidy, Ron [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 15, 2006 1:28 PM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names

That's right.  You will need:

1.  A sqlnet.ora file which designates the search method:
names.directory_path=(LDAP)
2.  A ldap.ora file that describes the location of your OID instance:
Default_admin_context = "dc=xx,dc=yy,dc=com"
Directory_server=(server.domain.com:non-ssl_port:ssl_port)
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 Names

Hi Ron,

I meant, not using TNS files and instead using Oracle OLAP. 
 
Peter

-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 10:54 AM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names

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 PROTECTED]
Sent: Tuesday, August 15, 2006 11:40 AM
To: DBI-Users
Subject: Using Oracle Internet Directory (OID) instead of TNS Names

Hi All,
 
Does the current Perl DBI support Oracle Internet Directory?  If so,
how/where would I go to find out more on how to use this functionality?
 
Thanks.
 
Peter

This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended to be for the use of the individual or entity
named above. If you are not the intended recipient, please be aware that
any disclosure, copying, distribution or use of the contents of this
information is prohibited. Please notify the sender  of the delivery
error by replying to this message, or notify us by telephone
(877-633-2436, ext. 0), and then delete it from your system.



This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.


This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.

RE: Using Oracle Internet Directory (OID) instead of TNS Names

[Reidy, Ron]

That's right.  You will need:

1.  A sqlnet.ora file which designates the search method:
names.directory_path=(LDAP)
2.  A ldap.ora file that describes the location of your OID instance:
Default_admin_context = "dc=xx,dc=yy,dc=com"
Directory_server=(server.domain.com:non-ssl_port:ssl_port)
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 Names

Hi Ron,

I meant, not using TNS files and instead using Oracle OLAP. 
 
Peter

-Original Message-----
From: Reidy, Ron [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 15, 2006 10:54 AM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names

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 PROTECTED]
Sent: Tuesday, August 15, 2006 11:40 AM
To: DBI-Users
Subject: Using Oracle Internet Directory (OID) instead of TNS Names

Hi All,
 
Does the current Perl DBI support Oracle Internet Directory?  If so,
how/where would I go to find out more on how to use this functionality?
 
Thanks.
 
Peter

This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended to be for the use of the individual or entity
named above. If you are not the intended recipient, please be aware that
any disclosure, copying, distribution or use of the contents of this
information is prohibited. Please notify the sender  of the delivery
error by replying to this message, or notify us by telephone
(877-633-2436, ext. 0), and then delete it from your system.



This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.

RE: Using Oracle Internet Directory (OID) instead of TNS Names

[Reidy, Ron]

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 PROTECTED] 
Sent: Tuesday, August 15, 2006 11:40 AM
To: DBI-Users
Subject: Using Oracle Internet Directory (OID) instead of TNS Names

Hi All,
 
Does the current Perl DBI support Oracle Internet Directory?  If so,
how/where would I go to find out more on how to use this functionality?
 
Thanks.
 
Peter

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Oracle and DBI module file

[Reidy, Ron]

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 module file

Teammates,

How does the DBI module know which tnsnames.ora file (from Oracle) to
use ?

tanx,
Lori

Lori (Dolores) Rowe
Web Administrator
Software Engineering Tools and Environments
Boeing
(314)882-8784


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Minor gotcha with bind variables and type CHAR.

[Reidy, Ron]

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 Carville [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 10, 2006 7:48 PM
To: DBI Users
Subject: Minor gotcha with bind variables and type CHAR.

A note on bind variables:

I'm running Oracle 10gR2 and select stateens with bind variables of type

CHAR do not behave as expected.  For example, one of my DB's has the 
following table in it:

SQL> desc webuserparm;
  Name   Null?Type
  --  -
  USERCD NOT NULL CHAR(15)
  USERNAME   NOT NULL VARCHAR2(25)
  USERPWDNOT NULL CHAR(15)
  GRPID  NOT NULL NUMBER(5)
  ACTIVEFLAG NOT NULL CHAR(1)
  USERTYPECHAR(1)
  CLTID   NUMBER(8)
  EMAILID CHAR(200)
  BUSINESSPHONE   VARCHAR2(10)
  BUSINESSPHONEEXTN   CHAR(4)
  BUSINESSTITLE   VARCHAR2(50)
  DPSIMTGPROVIDERID   VARCHAR2(15)
  DPSIMTGCOMPANYIDVARCHAR2(15)
  DPSIMTGUSERID   VARCHAR2(15)
  DPSIMTGUSERPWD  VARCHAR2(15)

I run the following SQL against this table several thousand time a day 
so I have an incentive to use bind variables:

$script =
  "select count (*) from webuserparm where usercd = ? and cltid = ?";

If I run it

$sth = $dbh->prepare($script);

$usercd = "MYUSER";
$cltid = 10101;

$sth->execute($usercd,$cltid);

I get a "0" even tho MYUSER and 10101 are in the same row.

If I add just before the execute a function padding the string with
spaces:

$usercd = pack("A15",$usercd);

I get a "1" as expected.

Apparently Oracle compares a space padded copy of a CHAR to the 
submitted value.

Perl version 5.8.2 and 5.8.6
DBI version 1.51
OracleDBD version 1.17

-- 
Stephen Carville <[EMAIL PROTECTED]>
Unix and Network Admin
Nationwide Totalflood
6033 W. Century Blvd
Los Angeles, CA 90045
310-342-3602

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: FAQ? (ps: oracle.xs make failure)

[Reidy, Ron]

You don't say which version of DBD::Oracle you are building, but if you
google for this error, I believe you will find there is a specific
version of the module that works with 8.1.7.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Hugh Shedd [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 10, 2006 6:21 PM
To: dbi-users@perl.org
Subject: FAQ? (ps: oracle.xs make failure)

We are building CPAN modules on an AIX box.
I want to look at the FAQ for this
group.  Is there one?  In case anyone can key on any of this, I'll dump
our
error.  I think it some custom stuff... I don't know yet.
But I really want to poke around in the FAQ first.  But, who knows,
maybe someone has been there.   Thanks

(this is an error :-)

Make failed:
perl /opt/3d/lib/perl5/5.8.8/ExtUtils/xsubpp  -typemap
/perl/lib/perl5/5.8.8/ExtUtils/typemap -typemap typemap
  Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
cc_r -c  -I/opt/oracle/product/prodvers/rdbms/public
-I/opt/oracle/product/prodvers/rdbms/demo -I/opt/oracle/product/prodver
s/rdbms/demo -I/opt/oracle/product/prodvers/rdbms/public
-I/opt/oracle/product/prodvers/plsql/public
-I/opt/oracle/product/prodvers/
network/public
-I/perl/var/tmp/perl_bundle_bootstrap/perl/lib/perl5/site_perl/5.8.8/aix
-thread-multi/auto/DBI
 -D_ALL_SOURCE -D_
ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias
-DUSE_NATIVE_DLOPEN
-DNEED_PTHREAD_INIT -I/perl/cus/include -O-DVERSION=\"
1.18\"  -DXS_VERSION=\"1.18\" 
"-I/perl/lib/perl5/5.8.8/aix-thread-multi/CORE"  -DUTF8_SUPPORT
-DORA_OCI_VERSION=\"8.1.7.0\" Oracl
e.c
"Oracle.xs", line 269.72: 1506-045 (S) Undeclared identifier startp.
make: The error code from the last command is 1.

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Newbie - Access to SQL Server db thru Perl

[Reidy, Ron]

Chris,

Yes, you must install both modules.

When you specify your connect string (or DSN in ODBC lingo), it will
define which database specific driver you will use.

Read this http://dbi.perl.org/about/ for a description of how the DBI
works.  

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Powers.Chris [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 10, 2006 8:16 AM
To: dbi-users@perl.org
Subject: Newbie - Access to SQL Server db thru Perl

Hello,
 
I'm just trying to come up to speed on all of this and wanted to make
sure I'm following along with what I need to do:
 
In order for me to use Perl to access MS SQL Server, I need to install
both the DBI-1.52 module & the DBD-ODBC module, is this correct?  The
DBI module will install dbi.pl that the ODBC module needs, is that how
it works?
 
thanks,
Chris 
  
  
  
LEGAL DISCLAIMER 
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or other
use of or taking action in reliance upon this information by persons or
entities other than the intended recipient is prohibited. If you have
received this email in error please contact the sender and delete the
material from any computer. 
  
Seeing Beyond Money is a service mark of SunTrust Banks, Inc. 
[ST:XCL] 
 
 
 
 

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Perl DBI problem.

[Reidy, Ron]

Comments in line ...

-Original Message-
From: Gregg Allen [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 09, 2006 4:50 PM
To: dbi-users@perl.org
Subject: Perl DBI problem.

When I try to install the CPAN module DBI on Mac Tiger, it fails even  
with force. When I scroll back through the output I find the  
following error message:


"Can't locate Data/Dumper.pm in @INC" (followed by a long list of  
directories.)


But I installed Data::Dumper with no problems.

[rr] Where is it?  What is the output of 'perl -V'?

  I know what you're going to say:  "It's not installed in one of the  
directories listed."  Point well taken, but WHERE is it being  
installed, and where does this mysterious and bizarre @INC array get  
its paths in the first place, and how do I modify it? Please don't  
say "push, pop, shift, and,or unshift", because I've used those, but  
the @INC array has a non-persistence property when it comes to my  
directories, but is very stubbornly persistent about its own  
directories.  Where does this array hide when I'm not using Perl?

[rr] @INC is defined when you build Perl.  When you build and install
modules, they are written to a directory under @INC.  See
http://search.cpan.org/dist/perl/pod/perlvar.pod for information about
@INC.

If you installed Data::Dumper in a non standard directory, you will need
to use the 'lib' pragma to define where this is located.  See
http://search.cpan.org/dist/perl/pod/perlmodlib.pod#Pragmatic_Modules
for information about this.

The 'push' etc. built-in subroutines are not designed to be persistent,
so you are correct in your observation.


Gregg Allen
RippyFish Records




To err is human; effective mayhem requires the root password!


--
Ron Reidy
Lead DBA
Array BioPharma, Inc.



This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Perl DBI Installation error

[Reidy, Ron]

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: 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 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]; dbi-users@perl.org
Subject: Perl DBI Installation error

Dear All,

 

I am facing problem in installing the Perl Database Interface
(DBI-1.21).

Pls. help out.

The following log is as follows:

 

perl Makefile.PL

 

*** You are using a perl with experimental threading enabled!

*** You should be aware that using multiple threads is unstable

*** are should NOT be done in production environments.

DBI thread mutex protection is enabled

 

*** Note:

The optional PlRPC-modules (RPC::PlServer etc) are not installed.

If you want to use the DBD::Proxy driver and DBI::ProxyServer

modules, then you'll need to install the RPC::PlServer,
RPC::PlClient,

Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you.

You can install them any time after installing the DBI.

You do *not* need these modules for typical DBI usage.

 

Optional modules are available from any CPAN mirror, in particular

http://www.perl.com/CPAN/modules/by-module

http://www.perl.org/CPAN/modules/by-module

ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module

 

Writing Makefile for DBI

 

Remember to actually *read* the README file!

Use  'make' to build the software (dmake or nmake on Windows).

Then 'make test' to execute self tests.

Then 'make install' to install the DBI and then delete this working

directory before unpacking and building any DBD::* drivers.

 

 

make

cp Changes blib/lib/DBI/Changes.pm

gcc -c-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE
-fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O-DVERSION=\"1.21\"  -DXS_VERSION=\"1.21\"
-fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE"  -Wall -Wno-comment
Perl.c

sh: gcc:  not found.

*** Error exit code 127

 

Stop.

 

 

make test

cp Changes blib/lib/DBI/Changes.pm

gcc -c-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE
-fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O-DVERSION=\"1.21\"  -DXS_VERSION=\"1.21\"
-fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE"  -Wall -Wno-comment
Perl.c

sh: gcc:  not found.

*** Error exit code 127

 

Stop.

 

 

 

make install

cp Changes blib/lib/DBI/Changes.pm

gcc -c-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE
-fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O-DVERSION=\"1.21\"  -DXS_VERSION=\"1.21\"
-fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE"  -Wall -Wno-comment
Perl.c

sh: gcc:  not found.

*** Error exit code 127

 

Stop.


Disclaimer:
This electronic message and any files attached with it are intended for
the recipient(s) and may
contain confidential and privileged information. If you are not the
intended recipient, please
notify the sender immediately and destroy all copies of this message and
any attachments. Any
unauthorized usage of this email is strictly prohibited.

Visit us at: http://dwl.co.in

This electronic message transmission is a PRIVATE communication which
contains
information which may be confidential or privileged. The information is
intended 
to be for the use of the individual or entity named above. If you are
not
the 
intended recipient, please be aware that any disclosure, copying,
distribution 
or use of the contents of this information is prohibited. Please notify
the
sender  of the delivery error by replying to this message, or notify us
by
telephone (877-633-2436, ext. 0), and then delete it from your system.






Disclaimer:
This electronic message and any files attached with it are intended for
the recipient(s) and may
contain confidential and privileged information. If you are not the
intended recipient, please
notify the sender immediately and destroy all copies of this message and
any attachments. Any
unauthorized usage of this email is strictly prohibited.

Visit us at: http://dwl.co.in

RE: Perl DBI Installation error

[Reidy, Ron]

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 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 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' 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]; dbi-users@perl.org
Subject: Perl DBI Installation error

Dear All,

 

I am facing problem in installing the Perl Database Interface
(DBI-1.21).

Pls. help out.

The following log is as follows:

 

perl Makefile.PL

 

*** You are using a perl with experimental threading enabled!

*** You should be aware that using multiple threads is unstable

*** are should NOT be done in production environments.

DBI thread mutex protection is enabled

 

*** Note:

The optional PlRPC-modules (RPC::PlServer etc) are not installed.

If you want to use the DBD::Proxy driver and DBI::ProxyServer

modules, then you'll need to install the RPC::PlServer,
RPC::PlClient,

Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you.

You can install them any time after installing the DBI.

You do *not* need these modules for typical DBI usage.

 

Optional modules are available from any CPAN mirror, in particular

http://www.perl.com/CPAN/modules/by-module

http://www.perl.org/CPAN/modules/by-module

ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module

 

Writing Makefile for DBI

 

Remember to actually *read* the README file!

Use  'make' to build the software (dmake or nmake on Windows).

Then 'make test' to execute self tests.

Then 'make install' to install the DBI and then delete this working

directory before unpacking and building any DBD::* drivers.

 

 

make

cp Changes blib/lib/DBI/Changes.pm

gcc -c-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE
-fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O-DVERSION=\"1.21\"  -DXS_VERSION=\"1.21\"
-fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE"  -Wall -Wno-comment
Perl.c

sh: gcc:  not found.

*** Error exit code 127

 

Stop.

 

 

make test

cp Changes blib/lib/DBI/Changes.pm

gcc -c-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE
-fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O-DVERSION=\"1.21\"  -DXS_VERSION=\"1.21\"
-fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE"  -Wall -Wno-comment
Perl.c

sh: gcc:  not found.

*** Error exit code 127

 

Stop.

 

 

 

make install

cp Changes blib/lib/DBI/Changes.pm

gcc -c-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE
-fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O-DVERSION=\"1.21\"  -DXS_VERSION=\"1.21\"
-fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE"  -Wall -Wno-comment
Perl.c

sh: gcc:  not found.

*** Error exit code 127

 

Stop.


Disclaimer:
This electronic message and any files attached with it are intended for
the recipient(s) and may
contain confidential and privileged information. If you are not the
intended recipient, please
notify the sender immediately and destroy all copies of this message and
any attachments. Any
unauthorized usage of this email is strictly prohibited.

Visit us at: http://dwl.co.in

This electronic message transmission is a PRIVATE communication which
contains
information which may be confidential or privileged. The information is
intended 
to be for the use of the individual or entity named above. If you are
not the 
intended recipient, please be aware that any disclosure, copying,
distribution 
or use of the contents of this information is prohibited. Please notify
the
sender  of the delivery error by replying to this message, or notify us
by
telephone (877-633-2436, ext. 0), and then delete it from your system.






Disclaimer:
This electronic message and any files attached with it are intended for
the recipient(s) and may
contain confidential and privileged information. If you are not the
intende

RE: Perl DBI Installation error

[Reidy, Ron]

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' 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]; dbi-users@perl.org
Subject: Perl DBI Installation error

Dear All,

 

I am facing problem in installing the Perl Database Interface
(DBI-1.21).

Pls. help out.

The following log is as follows:

 

perl Makefile.PL

 

*** You are using a perl with experimental threading enabled!

*** You should be aware that using multiple threads is unstable

*** are should NOT be done in production environments.

DBI thread mutex protection is enabled

 

*** Note:

The optional PlRPC-modules (RPC::PlServer etc) are not installed.

If you want to use the DBD::Proxy driver and DBI::ProxyServer

modules, then you'll need to install the RPC::PlServer,
RPC::PlClient,

Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you.

You can install them any time after installing the DBI.

You do *not* need these modules for typical DBI usage.

 

Optional modules are available from any CPAN mirror, in particular

http://www.perl.com/CPAN/modules/by-module

http://www.perl.org/CPAN/modules/by-module

ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module

 

Writing Makefile for DBI

 

Remember to actually *read* the README file!

Use  'make' to build the software (dmake or nmake on Windows).

Then 'make test' to execute self tests.

Then 'make install' to install the DBI and then delete this working

directory before unpacking and building any DBD::* drivers.

 

 

make

cp Changes blib/lib/DBI/Changes.pm

gcc -c-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE
-fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O-DVERSION=\"1.21\"  -DXS_VERSION=\"1.21\"
-fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE"  -Wall -Wno-comment
Perl.c

sh: gcc:  not found.

*** Error exit code 127

 

Stop.

 

 

make test

cp Changes blib/lib/DBI/Changes.pm

gcc -c-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE
-fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O-DVERSION=\"1.21\"  -DXS_VERSION=\"1.21\"
-fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE"  -Wall -Wno-comment
Perl.c

sh: gcc:  not found.

*** Error exit code 127

 

Stop.

 

 

 

make install

cp Changes blib/lib/DBI/Changes.pm

gcc -c-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE
-fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O-DVERSION=\"1.21\"  -DXS_VERSION=\"1.21\"
-fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE"  -Wall -Wno-comment
Perl.c

sh: gcc:  not found.

*** Error exit code 127

 

Stop.


Disclaimer:
This electronic message and any files attached with it are intended for
the recipient(s) and may
contain confidential and privileged information. If you are not the
intended recipient, please
notify the sender immediately and destroy all copies of this message and
any attachments. Any
unauthorized usage of this email is strictly prohibited.

Visit us at: http://dwl.co.in

This electronic message transmission is a PRIVATE communication which
contains
information which may be confidential or privileged. The information is
intended 
to be for the use of the individual or entity named above. If you are
not the 
intended recipient, please be aware that any disclosure, copying,
distribution 
or use of the contents of this information is prohibited. Please notify
the
sender  of the delivery error by replying to this message, or notify us
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Perl DBI Installation error

[Reidy, Ron]

'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]; dbi-users@perl.org
Subject: Perl DBI Installation error

Dear All,

 

I am facing problem in installing the Perl Database Interface
(DBI-1.21).

Pls. help out.

The following log is as follows:

 

perl Makefile.PL

 

*** You are using a perl with experimental threading enabled!

*** You should be aware that using multiple threads is unstable

*** are should NOT be done in production environments.

DBI thread mutex protection is enabled

 

*** Note:

The optional PlRPC-modules (RPC::PlServer etc) are not installed.

If you want to use the DBD::Proxy driver and DBI::ProxyServer

modules, then you'll need to install the RPC::PlServer,
RPC::PlClient,

Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you.

You can install them any time after installing the DBI.

You do *not* need these modules for typical DBI usage.

 

Optional modules are available from any CPAN mirror, in particular

http://www.perl.com/CPAN/modules/by-module

http://www.perl.org/CPAN/modules/by-module

ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module

 

Writing Makefile for DBI

 

Remember to actually *read* the README file!

Use  'make' to build the software (dmake or nmake on Windows).

Then 'make test' to execute self tests.

Then 'make install' to install the DBI and then delete this working

directory before unpacking and building any DBD::* drivers.

 

 

make

cp Changes blib/lib/DBI/Changes.pm

gcc -c-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE
-fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O-DVERSION=\"1.21\"  -DXS_VERSION=\"1.21\"
-fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE"  -Wall -Wno-comment
Perl.c

sh: gcc:  not found.

*** Error exit code 127

 

Stop.

 

 

make test

cp Changes blib/lib/DBI/Changes.pm

gcc -c-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE
-fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O-DVERSION=\"1.21\"  -DXS_VERSION=\"1.21\"
-fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE"  -Wall -Wno-comment
Perl.c

sh: gcc:  not found.

*** Error exit code 127

 

Stop.

 

 

 

make install

cp Changes blib/lib/DBI/Changes.pm

gcc -c-D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE
-fPIC -mpa-risc-1-1 -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O-DVERSION=\"1.21\"  -DXS_VERSION=\"1.21\"
-fPIC
"-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE"  -Wall -Wno-comment
Perl.c

sh: gcc:  not found.

*** Error exit code 127

 

Stop.


Disclaimer:
This electronic message and any files attached with it are intended for
the recipient(s) and may
contain confidential and privileged information. If you are not the
intended recipient, please
notify the sender immediately and destroy all copies of this message and
any attachments. Any
unauthorized usage of this email is strictly prohibited.

Visit us at: http://dwl.co.in

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Invalid authorization specification (SQL-28000)

[Reidy, Ron]

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 in the database?  If so, both Unix IDs are using the same
database ids and passwords.
 
Peter Loo
Wolters Kluwer Health
(602) 381-9553

-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 31, 2006 2:34 PM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: Invalid authorization specification (SQL-28000)

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
complete the program as one user and not as another.  Logging into the
same database with the same user id and password.  This is very strange.
The .profile on both ids are also the same.  Would someone know what
might be causing this?  Has someone experienced this before?
 
DBI connect('testdb','testuser',...) failed: [unixODBC]Invalid
authorization specification (SQL-28000)(DBD: db_login/SQLConnect err=-1)
at /usr/local/apps/common/override/bin/GlobalRoutines.pm line 51
 
 
Peter Loo

This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended to be for the use of the individual or entity
named above. If you are not the intended recipient, please be aware that
any disclosure, copying, distribution or use of the contents of this
information is prohibited. Please notify the sender  of the delivery
error by replying to this message, or notify us by telephone
(877-633-2436, ext. 0), and then delete it from your system.



This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.

RE: Invalid authorization specification (SQL-28000)

[Reidy, Ron]

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
complete the program as one user and not as another.  Logging into the
same database with the same user id and password.  This is very strange.
The .profile on both ids are also the same.  Would someone know what
might be causing this?  Has someone experienced this before?
 
DBI connect('testdb','testuser',...) failed: [unixODBC]Invalid
authorization specification (SQL-28000)(DBD: db_login/SQLConnect err=-1)
at /usr/local/apps/common/override/bin/GlobalRoutines.pm line 51
 
 
Peter Loo

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Perl script

[Reidy, Ron]

This is not a DBI issue.  If you want to know about these types of
constructs, please refer to the following docs:

1.  The Perl man pages - In your case,
http://search.cpan.org/dist/perl/pod/perlop.pod and
http://search.cpan.org/dist/perl/pod/perlre.pod

2.  The camel book - http://www.oreilly.com/catalog/learnperl4/ and The
Perl Cookbook - http://www.oreilly.com/catalog/perlckbk2/



-Original Message-
From: Amar P. Singh [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 24, 2006 11:03 PM
To: dbi-users@perl.org
Subject: Perl script

Hi All,

This is my first email to the group and I hope  that I landed in the
correct place.

 

Ok now coming to the problem. Can someone explain to me that what this
script is doing. I want to know the meaning of all the lines in the
script.

 

$val = defined $val ? $val : "null";

$val =~ s/\'/$& x 2/eg; # double pad single
quote character '



Please help me out understand the meaning of the lines above.

 

With Regards,

 

Amar P Singh

desk: +91 124 4167037

mobile: +91 (0) 9810788298 
e-mail: [EMAIL PROTECTED]

 


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: (Fwd) dbd-oracle-1.16

[Reidy, Ron]

So, the O/S user running the web server cannot execute this?   I think
this has been answered before and is available via google.  I don't
remember the answer off the top of my head.

-Original Message-
From: Oscar Gomez [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 21, 2006 9:46 AM
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 the command line connects to the database and
returns correct results.

--
Open WebMail Project (http://openwebmail.org)


-- Original Message ---
From: "Reidy, Ron" <[EMAIL PROTECTED]>
To: "Oscar Gomez" <[EMAIL PROTECTED]>, 
Sent: Fri, 21 Jul 2006 09:49:48 -0600
Subject: RE: (Fwd) dbd-oracle-1.16

> Oscar,
> 
> That information is owner/group id.  I am asking about read/execute
> permissions for this file.  It might be the user who is executing the
> Perl script does not have permissions into the $OH directory tree.
> 
> -Original Message-
> From: Oscar Gomez [mailto:[EMAIL PROTECTED] 
> Sent: Friday, 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 PROTECTED]>, 
> Sent: Thu, 20 Jul 2006 05:16:06 -0600
> Subject: RE: (Fwd) dbd-oracle-1.16
> 
> > Oscar,
> > 
> > Is Oracle installed?  If so, what the permissions on
$ORACLE_HOME/lib
> > and $ORACLE_HOME/libclntsh.so.8.0?
> > 
> > -Original Message-
> > From: Tim Bunce [mailto:[EMAIL PROTECTED] 
> > Sent: Wednesday, July 19, 2006 11:45 PM
> > To: dbi-users@perl.org
> > Cc: [EMAIL PROTECTED]
> > Subject: (Fwd) dbd-oracle-1.16
> > 
> > - Forwarded message from Oscar Gomez <[EMAIL PROTECTED]> -
> > 
> > X-Pobox-Antispam: require_ptr/ returned deny: 200.13.228.34 has no 
> > PTR record, or PTR and A records do not match From: Oscar Gomez
> <[EMAIL PROTECTED]>
> > To: Tim Bunce <[EMAIL PROTECTED]>
> > Subject: dbd-oracle-1.16
> > Date: Wed, 19 Jul 2006 16:54:32 -0500
> > X-OriginatingIP: 10.0.1.50 (ogomez)
> > 
> > Tim 
> > I have the following error when execute program in apache-cgi-oracle
> > 
> > [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50]
> > install_driver(Oracle)
> > failed: Can't load
> >
>
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/
> > Oracle.so'
> > for module DBD::Oracle: libclntsh.so.8.0: cannot open shared object
> > file: No
> > such file or directory at
> > /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line
230.,
> > referer:
> > http://10.0.0.6/cgi-bin/FGI?py6110
> > 
> > [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50]  at (eval 1)
> line
> > 3,
> > referer: http://10.0.0.6/cgi-bin/FGI?py6110
> > 
> > [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] Compilation
> failed
> > in
> > require at (eval 1) line 3., referer:
> http://10.0.0.6/cgi-bin/FGI?py6110
> > 
> > [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] Perhaps a
> required
> > shared library or dll isn't installed where expected, referer:
> > http://10.0.0.6/cgi-bin/FGI?py6110
> > 
> > perl version 5.8.5
> > lunux enterprise ES 4
> > DBD-Oracle-1.16
> > DBI-1.30
> > 
> > Thanks
> > --
> > Open WebMail Project (http://openwebmail.org)
> > 
> > -- Original Message ---
> > From: Tim Bunce <[EMAIL PROTECTED]>
> > To: "Garrett, Philip (MAN-Corporate)" <[EMAIL PROTECTED]>
> > Sent: Wed, 19 Jul 2006 08:37:27 -0700
> > Subject: Re: DBI->installed_drivers() usage
> > 
> > > On Wed, Jul 19, 2006 at 09:24:53AM -0400, Garrett, Philip (MAN-
> > > Corporate) wrote:
> > > > Paul Griffin wrote:
> > > > > I'm running Win XP with Perl 5.8.8.
> > > > > 
> > > > > If I try and run the following code :
> > > > > 
> > > > > use DBI;
> > > > > my %drivers = DBI->installed_drivers();
> > > > > foreach (keys( %drivers)) {
> > > > > print "$_ uses $drivers{$_}\n";
> > >

RE: (Fwd) dbd-oracle-1.16

[Reidy, Ron]

Oscar,

That information is owner/group id.  I am asking about read/execute
permissions for this file.  It might be the user who is executing the
Perl script does not have permissions into the $OH directory tree.

-Original Message-
From: Oscar Gomez [mailto:[EMAIL PROTECTED] 
Sent: Friday, 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 PROTECTED]>, 
Sent: Thu, 20 Jul 2006 05:16:06 -0600
Subject: RE: (Fwd) dbd-oracle-1.16

> Oscar,
> 
> Is Oracle installed?  If so, what the permissions on $ORACLE_HOME/lib
> and $ORACLE_HOME/libclntsh.so.8.0?
> 
> -Original Message-
> From: Tim Bunce [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, July 19, 2006 11:45 PM
> To: dbi-users@perl.org
> Cc: [EMAIL PROTECTED]
> Subject: (Fwd) dbd-oracle-1.16
> 
> - Forwarded message from Oscar Gomez <[EMAIL PROTECTED]> -
> 
> X-Pobox-Antispam: require_ptr/ returned deny: 200.13.228.34 has no 
> PTR record, or PTR and A records do not match From: Oscar Gomez
<[EMAIL PROTECTED]>
> To: Tim Bunce <[EMAIL PROTECTED]>
> Subject: dbd-oracle-1.16
> Date: Wed, 19 Jul 2006 16:54:32 -0500
> X-OriginatingIP: 10.0.1.50 (ogomez)
> 
> Tim 
> I have the following error when execute program in apache-cgi-oracle
> 
> [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50]
> install_driver(Oracle)
> failed: Can't load
>
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/
> Oracle.so'
> for module DBD::Oracle: libclntsh.so.8.0: cannot open shared object
> file: No
> such file or directory at
> /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.,
> referer:
> http://10.0.0.6/cgi-bin/FGI?py6110
> 
> [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50]  at (eval 1)
line
> 3,
> referer: http://10.0.0.6/cgi-bin/FGI?py6110
> 
> [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] Compilation
failed
> in
> require at (eval 1) line 3., referer:
http://10.0.0.6/cgi-bin/FGI?py6110
> 
> [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] Perhaps a
required
> shared library or dll isn't installed where expected, referer:
> http://10.0.0.6/cgi-bin/FGI?py6110
> 
> perl version 5.8.5
> lunux enterprise ES 4
> DBD-Oracle-1.16
> DBI-1.30
> 
> Thanks
> --
> Open WebMail Project (http://openwebmail.org)
> 
> -- Original Message ---
> From: Tim Bunce <[EMAIL PROTECTED]>
> To: "Garrett, Philip (MAN-Corporate)" <[EMAIL PROTECTED]>
> Sent: Wed, 19 Jul 2006 08:37:27 -0700
> Subject: Re: DBI->installed_drivers() usage
> 
> > On Wed, Jul 19, 2006 at 09:24:53AM -0400, Garrett, Philip (MAN-
> > Corporate) wrote:
> > > Paul Griffin wrote:
> > > > I'm running Win XP with Perl 5.8.8.
> > > > 
> > > > If I try and run the following code :
> > > > 
> > > > use DBI;
> > > > my %drivers = DBI->installed_drivers();
> > > > foreach (keys( %drivers)) {
> > > > print "$_ uses $drivers{$_}\n";
> > > > }
> > > > 
> > > > Nothing is returned.  Yet if I use :
> > > > 
> > > > my @drivers = DBI->available_drivers();
> > > > 
> > > > I get a list of drivers that I can then access with :
> > > > 
> > > > @dataSources = DBI->data_sources($_);
> > > > 
> > > > Am I using DBI->installed_drivers() incorrectly?
> > > 
> > > DBI->installed_drivers returns only the drivers that are actually
> loaded
> > > into the current process.  Installed in this case means "installed
> into
> > > memory."
> > 
> > Ah. The docs weren't clear:
> > 
> > --- DBI.pm  (revision 6618)
> > +++ DBI.pm  (working copy)
> > @@ -2753,10 +2753,15 @@
> >  
> >%drivers = DBI->installed_drivers();
> >  
> > -Returns a list of driver name and driver handle pairs for all
> > -installed drivers. The driver name does not include the 'DBD::'
> > -prefix. Added in DBI 1.49.
> > +Returns a list of driver name and driver handle pairs for all 
> > drivers +'installed' (loaded) into the current process.  The driver 
> > name does not +include the 'DBD::' prefix.
> >  
> > +To get a list of all drivers available in your perl instalation you

> > can us

RE: (Fwd) dbd-oracle-1.16

[Reidy, Ron]

Oscar,

Is Oracle installed?  If so, what the permissions on $ORACLE_HOME/lib
and $ORACLE_HOME/libclntsh.so.8.0?

-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 19, 2006 11:45 PM
To: dbi-users@perl.org
Cc: [EMAIL PROTECTED]
Subject: (Fwd) dbd-oracle-1.16

- Forwarded message from Oscar Gomez <[EMAIL PROTECTED]> -

X-Pobox-Antispam: require_ptr/ returned deny: 200.13.228.34 has no PTR
record, or PTR and A records do not match
From: Oscar Gomez <[EMAIL PROTECTED]>
To: Tim Bunce <[EMAIL PROTECTED]>
Subject: dbd-oracle-1.16
Date: Wed, 19 Jul 2006 16:54:32 -0500
X-OriginatingIP: 10.0.1.50 (ogomez)

Tim 
I have the following error when execute program in apache-cgi-oracle

[Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50]
install_driver(Oracle)
failed: Can't load
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/
Oracle.so'
for module DBD::Oracle: libclntsh.so.8.0: cannot open shared object
file: No
such file or directory at
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.,
referer:
http://10.0.0.6/cgi-bin/FGI?py6110
[Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50]  at (eval 1) line
3,
referer: http://10.0.0.6/cgi-bin/FGI?py6110
[Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] Compilation failed
in
require at (eval 1) line 3., referer: http://10.0.0.6/cgi-bin/FGI?py6110
[Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] Perhaps a required
shared library or dll isn't installed where expected, referer:
http://10.0.0.6/cgi-bin/FGI?py6110

perl version 5.8.5
lunux enterprise ES 4
DBD-Oracle-1.16
DBI-1.30

Thanks
--
Open WebMail Project (http://openwebmail.org)


-- Original Message ---
From: Tim Bunce <[EMAIL PROTECTED]>
To: "Garrett, Philip (MAN-Corporate)" <[EMAIL PROTECTED]>
Sent: Wed, 19 Jul 2006 08:37:27 -0700
Subject: Re: DBI->installed_drivers() usage

> On Wed, Jul 19, 2006 at 09:24:53AM -0400, Garrett, Philip (MAN-
> Corporate) wrote:
> > Paul Griffin wrote:
> > > I'm running Win XP with Perl 5.8.8.
> > > 
> > > If I try and run the following code :
> > > 
> > > use DBI;
> > > my %drivers = DBI->installed_drivers();
> > > foreach (keys( %drivers)) {
> > > print "$_ uses $drivers{$_}\n";
> > > }
> > > 
> > > Nothing is returned.  Yet if I use :
> > > 
> > > my @drivers = DBI->available_drivers();
> > > 
> > > I get a list of drivers that I can then access with :
> > > 
> > > @dataSources = DBI->data_sources($_);
> > > 
> > > Am I using DBI->installed_drivers() incorrectly?
> > 
> > DBI->installed_drivers returns only the drivers that are actually
loaded
> > into the current process.  Installed in this case means "installed
into
> > memory."
> 
> Ah. The docs weren't clear:
> 
> --- DBI.pm  (revision 6618)
> +++ DBI.pm  (working copy)
> @@ -2753,10 +2753,15 @@
>  
>%drivers = DBI->installed_drivers();
>  
> -Returns a list of driver name and driver handle pairs for all
> -installed drivers. The driver name does not include the 'DBD::'
> -prefix. Added in DBI 1.49.
> +Returns a list of driver name and driver handle pairs for all 
> drivers +'installed' (loaded) into the current process.  The driver 
> name does not +include the 'DBD::' prefix.
>  
> +To get a list of all drivers available in your perl instalation you 
> can use +L. + +Added in DBI 1.49. + =item
C
>  
>DBI->installed_versions;
> 
> Tim.
--- End of Original Message ---


- End forwarded message -

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Connecting to Oracle.

[Reidy, Ron]

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 that are part of the DBD::Oracle distro have more
informations.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 07, 2006 8:51 AM
To: dbi-users@perl.org
Subject: Connecting to Oracle.

Guys,

Can anyone answer following questions please

1) Do I have to install sqlplus to connect to Oracle database from Perl

2) What , how and where can I get the modules required.

Please treat this as very urgent

Many thanks



Ripu Nanda
Systems Monitoring & Management Tools 
BTNet tel: 00 780 6534 
Tel: 01206 226534 

BTexact Technologies is a trademark of British
Telecommunications plc
Registered office: 81 Newgate Street London EC1A 7AJ
Registered in England no. 180

This electronic message contains information from British
Telecommunications plc which may be privileged or confidential. The
information is intended to be for the use of the individual(s) or entity
named above. If you are not the intended recipient be aware that any
disclosure, copying, distribution or use of the contents of this
information is prohibited. If you have received this electronic message
in error, please notify us by telephone or email (to the numbers or
address above) immediately.



This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: sth->do()

[Reidy, Ron]

Peter,

While you might find this external table does not exist (physically),
the data dictionary of your database believes it does exist.  Did you
check your data dictionary?

rr

-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] 
Sent: Friday, June 30, 2006 2:31 PM
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.

nv01()=> \d b_sdl_123456_p_dlvrb_study_att
Did not find any relation named "b_sdl_123456_p_dlvrb_study_att". 

The $sqlString is: 

CREATE EXTERNAL TABLE b_sdl_123456_p_dlvrb_study_att SAMEAS
a_sdl_123456_p_dlvrb_study_att USING ( DATAOBJECT
('/to_the_directory_path/b_sdl_123456_p_dlvrb_study_att.dat') DELIMITER
'|' DATEDELIM '-' ESCAPECHAR '\' TIMEDELIM ':' DATESTYLE 'YMD'
TRUNCSTRING ON CTRLCHARS ON FILLRECORD ON MAXERRORS 1 )

Thanks.
 
Peter

-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED] 
Sent: Friday, June 30, 2006 12:55 PM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: sth->do()

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 sth->do($sqlString), I get an
error.  I understand that using sth->do(), it goes through the process
of prepare and execute.  With that, it is expecting a returned value.
 
Can someone advise as to the best way to execute commands that does not
require return values?
 
Thanks.
 
Peter

This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended to be for the use of the individual or entity
named above. If you are not the intended recipient, please be aware that
any disclosure, copying, distribution or use of the contents of this
information is prohibited. Please notify the sender  of the delivery
error by replying to this message, or notify us by telephone
(877-633-2436, ext. 0), and then delete it from your system.



This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.

RE: sth->do()

[Reidy, Ron]

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 sth->do($sqlString), I get an
error.  I understand that using sth->do(), it goes through the process
of prepare and execute.  With that, it is expecting a returned value.
 
Can someone advise as to the best way to execute commands that does not
require return values?
 
Thanks.
 
Peter

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Errors, Connecting to Oracle

[Reidy, Ron]

>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
with
// the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is
to
// go by way of an Interchange). Start the listener on the remote
machine.

You have no listener installed or running.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: LLC [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 29, 2006 11:45 AM
To: dbi-users@perl.org
Subject: Errors, Connecting to Oracle

Hi List.

I've installed Oracle on my linux box (SuSE 10) and I've installed
DBD::Oracle.

I can run sqlplus as the oracle user however when I try and connect via
DBD::Oracle in a perl script I always get errors as follows:

connect string =
my $dbh = DBI->connect("dbi:Oracle:ORCL", 'oracle', 'oracle' );

error =
DBI connect('ORCL','oracle',...) failed: ORA-12541: TNS:no listener (DBD
ERROR: OCIServerAttach) at ora1.pl line 7
Connection Failed...

connect string =
my $dbh = DBI->connect("dbi:Oracle:HOST=linux.site;SID=ORCL;PORT=1522",
'oracle', 'oracle' );

error =
DBI connect('HOST=linux.site;SID=ORCL;PORT=1522','oracle',...) failed:
ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) at ora1.pl line
7
Connection Failed...



Maybe I have the connect string wrong?


Below is a listing of my code, and my tnsnames.ora:
Thanks in advance for your help.


 code listing  #!/usr/bin/perl

use DBI;

print "Started\n";

my $dbh = DBI->connect("dbi:Oracle:HOST=linux.site;SID=ORCL;PORT=1522",
'oracle', 'oracle' );


if ($dbh) {
print "Connected...\n";
}
else {
print "Connection Failed...\n";
exit;
}

my $qry = $dbh->prepare("select count(*) from dba_tables");
$qry->execute();

my @data = $qry->fetchrow_array();

print "[$data[0]] [$data[1]] [$data[2]]\n";


exit;




# tnsnames.ora listing #
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = linux.site)(PORT = 1522))


ORCL =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux.site)(PORT = 1522))
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = orcl)
)
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(CONNECT_DATA =
  (SID = PLSExtProc)
  (PRESENTATION = RO)
)
  )




This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: dbi-users@perl.org

[Reidy, Ron]

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 here. I just installed DBI
and Oracle DBD module. I tried a test script but got
the following errors:

install_driver(Oracle) failed: Can't load
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/
Oracle.so'
for module DBD::Oracle: libclntsh.so.9.0: cannot open
shared object file: No such file or directory at
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm
line 230. at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't
installed where expected
 at lsun.pl line 7

Does anyone know what is wrong? I could login to the
database using sqlplus username/[EMAIL PROTECTED]

Thanks,

Lihong 


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Stupid newbie question?

[Reidy, Ron]

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 stuff, so maybe this is a stupid
question. 
But after going through the DBI man page and searching the web for a 
couple hours, I can't find the answer. All I'm looking to do is to walk 
the result set from a select statement more than once. Every example I
can 
find follows the form:

prepare, execute, fetch, fetch, fetch, ..., finish

What I would *like* to be able to do is walk the entire result set, and 
then, once I get to the end, reset the statement handle to point the
fetch 
calls back to the top, and then walk them again. That seems so simple.
Is 
there really no "reset" command? Do I actually have to execute the
select 
again?

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: multiple perl installs - OT

[Reidy, Ron]

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 installs - OT

Hi List;

does anyone know how to install a new instance/version of perl on a
Linux
box (RHEL4) which already has more than one instance installed and force
scripts to not only use the new perl executable but the new perl libs,
modules, etc?

Thanks in advance...


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Creating an oracle temp table with a variable table name

[Reidy, Ron]

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 with a variable table name

Hi
Is there a way to use a bind variable to pass a tablename into an oracle
create table statement - e.g. 
CREATE TABLE ? 
(
  CASE_NUM   NUMBER,
  TLM_PROG   VARCHAR2(50 BYTE),
  TLM_REASON VARCHAR2(100 BYTE),
  TLM_CREATE_DT  DATE,
  TLM_TASK_NAME  VARCHAR2(50 BYTE),
  TLM_ACTION VARCHAR2(50 BYTE)
)
 
where ? gets replaced with a bind variable holding a temp table name
that contains the date?  I can do it by substituting the date into the
sql string or by concatenating the tablename with a couple of strings to
create the sql statement, but it seems cheesy.  If I try to do it using
a bind variable, it errors out.
 
Thanks
Mike R.
 
Michael P. Ready
Texas ACCESS Alliance
Work 512-533-3959, Mobile 512-796-7085, Fax 512-437-6532
AIM: michaelpready
[EMAIL PROTECTED]
 

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Is Perl-DBI Slow?

[Reidy, Ron]

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
deceived, Perl is fast.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: LLC [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 14, 2006 11:12 AM
To: dbi-users@perl.org
Subject: Is Perl-DBI Slow?

I've heard that perl-DBI is slow. Is this true? If so, is it because of
Perl being an interpreted language?


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Oracle schema names: sqlplus 'v' Perl

[Reidy, Ron]

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 sqlplus I can log in as system/seekrit, and can do:

SQL> select table_name, tablespace_name from user_tables where
table_name like
'%STATE%';

TABLE_NAME TABLESPACE_NAME
-- --
STATE  SYSTEM
LOGMNR_DICTSTATE$

but in Perl, if I do:

my($table_sth)  = $dbh -> table_info(undef, 'SYSTEM', '%', 'TABLE');
[rr] I have never used this method.  Why don't you just issue the same
query you would issue in SQL*Plus?

I don't get back any table data at all.

I assume the problem is the 'SYSTEM', i.e. the value of the schema
parameter.

So, any ideas as to what schema I should use in Perl?

Is TABLESPACE_NAME the same as schema?
[rr]  No, a tablespace is a logical entity, which must have one or more
datafiles assigned to it.  Tablespaces are where table and index data
live.

More info:
I used table_info() to get a list of schema names, and from that can get
tables
per schema for some of the schema, but nothing for SYSTEM:
Schema => Tables

TSMSYS => SRS$
OUTLN => OL$ OL$HINTS OL$NODES
HR => COUNTRIES LOCATIONS DEPARTMENTS JOB_HISTORY EMPLOYEES REGIONS JOBS
FLOWS_FILES => WWV_FLOW_FILE_OBJECT$
SYS => No tables
SYSTEM => No tables
XDA => ^C (Took so long)
MDSYS => ^C
FLOWS_020100 => ^C
DBSNMP => ^C
CTXSYS => ^C

--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html



This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: regular expresions

[Reidy, Ron]

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 to work with regular expressions but I want
to be able to understand and use everything and anything that can be
done with regular expressions -I guess I would say that I need an
advanced book.
Thanks for any suggestions.


Malka Cymbalista
Webmaster, Weizmann Institute of Science
[EMAIL PROTECTED]
08-934-3036

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: DBD Oracle help on Solaris 10.

[Reidy, Ron]

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 Oracle help on Solaris 10.

My make tests in CPAN are crashing hard when I "install DBD::Oracle"

Solaris 10.2. perl version 5.8.4 built for sun4-solaris-64int Oracle10g
client Admin installed.

The first error I get is:
t/01baseok
t/10general.DBI connect('','scott/tiger',...) failed:
ORA-12162:
TNS:net service name is incorrectly specified (DBD ERROR:
OCIServerAttach)
at t/10general.t line 18

and every test after that fails.

Can someone give me a hand?

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: OCI Initialize failed 1804r

[Reidy, Ron]

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 should build Perl 5.8.8 and
install the latest DBI and DBD::Oracle modules.  Be sure to read the
README* files prior to installation, so you understand exactly what is
will be happening.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: rajarathnam, devaraj [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 30, 2006 10:52 PM
To: John Scoles
Cc: dbi-users@perl.org
Subject: RE: OCI Initialize failed 1804r

 
Hi John,

I am using Oracle 10g client, so I infer that I need to compile
DBD:Oracle with Oracle 10g client. But to compile DBD:Oracle with Oracle
10g client, do I need to start to compile Perl 5.6.1 again? If so can I
use PPM to install Perl. Is PPM available for HP-UX.

Please could you suggest me HP-UX Perl 5 mailing lists?

Thanks and Regards,

Devaraj

-Original Message-
From: John Scoles [mailto:[EMAIL PROTECTED] 
Sent: 30 May 2006 7:22 PM
To: rajarathnam, devaraj
Subject: Re: OCI Initialize failed 1804r

If you are still using the old Oracle 9i client no.

If you have changed your Oracle client to 10g or instantclient then you
will have to recompile your DBD::Oracle but there is no need to
recompile DBI unless it is a very old version. If that is the case I
would use PPM to get the latest version of DBI rather than compile it
myself.


- Original Message -
From: "rajarathnam, devaraj" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, May 30, 2006 9:31 AM
Subject: OCI Initialize failed 1804r



Hi,

I have a perl 5.6.1 installation with DBI and DBD:Oracle with Oracle 9i

When I try to run a script to make a connection with Oracle 10g using
the above Perl executable, I get the error Unable to initialize OCI, OCI
Initialize failed 1804.

Do I need to compile Perl, DBI and DBD with Oracle 10g to solve this
problem.

Kindly let me know.

Thanks and Regards,
Devaraj



This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: perl- dbi

[Reidy, Ron]

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] 
Sent: Wednesday, May 31, 2006 7:46 AM
To: dbi-users@perl.org
Subject: perl- dbi

Hi ,
 
   how do i ensure that DBI is installed in my machine..
 
will it be automatically installed when perl is installed...
 
 
i am getiing error when i start using  use DBI;
 
and i need to connet to ORACLE DATABASE. 
 
 
please help me regding this issue..
 
 
 
regds
R . Rajasekar

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: how to invoke .sql file from dbi

[Reidy, Ron]

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 utility are truly "glue" type utilities that
can help keep legacy apps from being rewritten.

rr

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 24, 2006 3:15 PM
To: Job Miller
Cc: DBI-Users
Subject: Re: how to invoke .sql file from dbi

Hi Miller,

The sql statements are SELECT statements and we are expecting plain ( no

formatting required) output from these statements.
They are static and expect input values for substitution.
Yes, i thought over converting all sqls to pl/sql but it is a overkill 
for us.
Currently i sticked to sqlplus approach as it doesn't need much effort 
from our side.
But it is little surprising that dbi doesn't support executing sql files

directly.
I haven't explored 'use Expect'  or any other workarounds.

Thanks,
Ravi

Job Miller wrote On 05/24/06 05:58,:

> #2 is the no-brainer approach to this.  SQL*Plus can do a lot for 
> you.  What do the SQL statements do.  Are you expecting a printout of 
> results formatted as SQL*PLus can format them.  Are they just a bunch 
> of inserts/updates or ddl? 
>  
> SQL*Plus is really the best approach for this, since it has error 
> handling for sql scripts, formatting for output, and lots of other
things.
>  
> Is this something you are generating or just something you will be 
> periodically executing? 
>  
> If it is pure SQL dml statements (insert/update) read in the file and 
> wrap up the SQL in an anonymous pl/sql block and submit that at 
> runtime or if it is really always static, create a procedure and just 
> execute that.   I suspect its not static, otherwise you wouldn't be 
> asking about this.
>  
>  
> The anonymous PL/SQL block would be a way to avoid parsing all of it 
> and executing it as individual statements, but still executing it via 
> DBI without calling out to sql*plus (which is a perfectly valid
option).
>  
> Job
>
>
> */ravi kongara <[EMAIL PROTECTED]>/* wrote:
>
> Hello all,
>
> We have bunch of sql files ( .sql ) that we want to invoke from
dbi (
> Oracle ).
> How does it work. Dbi expects actual sql statements to be given as
> it's
> arguments whether in case of do() or prepare() methods. I wonder
is
> there any option
> to just point the dbi to a sql file and dbi taking care of it. I
do
> understand that running
> sql file is sqlplus feature and may not be applicable to dbi, as
> dbi is
> more generic. We have
> hundreds of sql files to be run like this. Each sql file has
multiple
> sql statements within it.
>
> I know these are my options..
>
> 1) Parse sql files and assign each sql statement to string
> variable and
> pass the string as an argument to do().
> File handler routines may come in handy for this.
> 2) Do not use DBI. Instead call 'sqlplus' from perl itself with
> file as
> input parameter.
>
> Did anyone come across this. Is there any simple way to do this.
>
> Thanks,
> Ravi
>
>
>

> Sneak preview the all-new Yahoo.com 
> . It's

> not radically different. Just radically better. 


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: (Fwd) Just a quick question on the DBI perl mod

[Reidy, Ron]

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 question on the DBI perl mod

- Forwarded message from Joe McTigue <[EMAIL PROTECTED]>
-

Subject: Just a quick question on the DBI perl mod
Date: Wed, 17 May 2006 14:22:38 -0400
From: Joe McTigue <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
X-Virus-Checked: Checked

   Hi Tim,



   I am currently getting the following error message and was wondering
if you could help?

   If you can, here's the scenario:  The code below is what I'm trying
to accomplish reading a file

   consisting of insert, update and delete statements. But I've been
getting the following error now

   for the past several days now and can't seem to figure it out:

   # ERROR FOLLOWS:

   starting file: DELETE.sql

   DBI connect('databasename','username',...) failed: ORA-24315: illegal
attribute type (DBD ERROR:
   OCIAttrGet OCI_ATTR_ENV_CHARSET_ID) at perlscript.pl line 463

   Can't connect to database:ORA-24315: illegal attribute type (DBD
ERROR: OCIAttrGet
   OCI_ATTR_ENV_CHARSET_ID) at perlscript.pl line 463.

   # END OF ERROR ###



   # CODE SEGMENT FOLLOWS #

   my $INPUT_SQL = FileHandle->new("cat ${working_file} |") or die
("Can not open ${working_file}:
   $!\n");



   next line is line : 463

   my $dbc = DBI->connect( "dbi:Oracle:$nameofdb", "$username",
"$password" ) || die "Can't connect to
   database:" . DBI->errstr();



   while ( my $line = $INPUT_SQL->getline() )

   {

  chomp( $line );



  my $sth = $dbc->prepare( $line ) or die "Can't prepare SQL
statement.\n";



  $sth->execute() or die "Can't execute SQL statement.\n";



   }

   $INPUT_SQL->close();



   $dbc->disconnect() or warn "Error disconnecting: \n";



   # END CODE SEGMENT ##



   Any help would be incredibly wonderful at this point.





   Regards,

   Joseph P. McTigue

   CBC Innovis, QA Department

   [EMAIL PROTECTED]

   (614) 538-6032



References

   Visible links
   1. mailto:[EMAIL PROTECTED]

- End forwarded message -

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: how to invoke .sql file from dbi

[Reidy, Ron]

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. Dbi expects actual sql statements to be given as it's
arguments whether in case of do() or prepare() methods. I wonder is 
there any option
to just point the dbi to a sql file and dbi taking care of it. I do 
understand that running
sql file is sqlplus feature and may not be applicable to dbi, as dbi is 
more generic. We have
hundreds of sql files to be run like this. Each sql file has multiple 
sql statements within it.

I know these are my options..

1) Parse sql files and assign each sql statement to string variable and 
pass the string as an argument to do().
File handler routines may come in handy for this.
2) Do not use DBI. Instead call 'sqlplus' from perl itself with file as 
input parameter.

Did anyone come across this. Is there any simple way to do this.

Thanks,
Ravi

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Identify PID for remote database handle--CLARIFICATION...

[Reidy, Ron]

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--CLARIFICATION...

You know I AM a DBA and will withdraw the post as you guys seem to not
be able to grasp the concept. 
 

-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 23, 2006 8:51 AM
To: Drozdowski, Catharine; dbi-users@perl.org
Subject: RE: Identify PID for remote database handle--CLARIFICATION...

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
database instance.  This new process opens a socket (tcp) for
communicating with the client process.  The listener then hands this
socket address back to the client program and returns to listening for
connection requests.

Now, to identify the PID of this new process, someone else has already
described the mechanism for getting that information from the DB.  If
you want DB resource usage, you will need to look at the performance
views V$PROCESS, V$SESSION (wait events), and the ASH and AWR views in
10gR2.

If you need more information on these views, see the Oracle docs and/or
talk with your DBA.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Drozdowski, Catharine [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 23, 2006 9:32 AM
To: dbi-users@perl.org
Subject: RE: Identify PID for remote database handle--CLARIFICATION...

 To the DBI/DBD list:

Let me rephrase this question a bit. 
I have a perl program running on server A which makes a remote
connection to a database running on server B using the DBI/DBD construct
of a database handle/statement handle. On server A, the perl program has
a process ID, identified by $$ or $PID. 

On server B where the actual DDL inside the statement handle is running,
resources are being consumed by the database to construct the query
return set. That resource usage is being accounted for somehow at the OS
level on server B. My assumption is that they are assigned a PID by the
OS It is this process id which I would like to capture.

I hope this clarifies what I am looking for ...

Thanks,
catharine




-Original Message-
From: Chris Sarnowski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 23, 2006 7:04 AM
To: dbi-users@perl.org
Cc: Drozdowski, Catharine
Subject: Re: Identify PID for remote database handle

I don't know of any way to do this using DBI or DBD::Oracle.
  You might get better answers on an Oracle DBA list (try
http://www.freelists.org/list/oracle-l or http://www.lazydba.com )

This seems to work in Oracle 9.2, but I just hacked it together in a
couple of minutes and it's not thoroughly tested (i.e. testcases = 1
with 100% success).  
Also, there are probably
better ways to find your own SID. This of course assumes that the user
has access to the V$ tables (which they probably shouldn't have).

select vp.spid from v$process vp, v$session vs where vs.sid = (select
sid from v$mystat where rownum = 1) and vp.addr = vs.paddr;


I've been thinking about why you might want this and now I'm not sure
it's the answer you want anyway. Running sqlplus inside of perl seems
redundant for most purposes.
And now that I think about it I'm sure DBI/DBD::Oracle can't help you
here because it is not going to know anything about the sqlplus
connection, just the DBI handle.
So it really is off-topic for this list.

-Chris

On May 22, 2006, at 6:07 PM, Drozdowski, Catharine wrote:
> How can I find the server pid for a sqlplus session which is logged on

> remotely inside a perl program... I can find the local PID using $$ or

> $PID, but how can I find the pid for the statement/database handle 
> which is actually logged onto the database doing the work...
>
> Env: Oracle, Solaris
>
>
> Catharine Drozdowski
> Mentor Graphics Corporation
> IT Systems Services
> 1 503 685 7906
>
>
>
>




This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended to be for the use of the individual or entity
named above. If you are not the intended recipient, please be aware that
any disclosure, copying, distribution or use of the contents of this
information is prohibited. Please notify the sender  of the delivery
error by replying to this message, or notify us by telephone
(877-633-2436, ext. 0), and then delete it from your system.

RE: Identify PID for remote database handle--CLARIFICATION...

[Reidy, Ron]

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
database instance.  This new process opens a socket (tcp) for
communicating with the client process.  The listener then hands this
socket address back to the client program and returns to listening for
connection requests.

Now, to identify the PID of this new process, someone else has already
described the mechanism for getting that information from the DB.  If
you want DB resource usage, you will need to look at the performance
views V$PROCESS, V$SESSION (wait events), and the ASH and AWR views in
10gR2.

If you need more information on these views, see the Oracle docs and/or
talk with your DBA.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: Drozdowski, Catharine [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 23, 2006 9:32 AM
To: dbi-users@perl.org
Subject: RE: Identify PID for remote database handle--CLARIFICATION...

 To the DBI/DBD list:

Let me rephrase this question a bit. 
I have a perl program running on server A which makes a remote
connection to a database running on server B using the DBI/DBD construct
of a database handle/statement handle. On server A, the perl program has
a process ID, identified by $$ or $PID. 

On server B where the actual DDL inside the statement handle is running,
resources are being consumed by the database to construct the query
return set. That resource usage is being accounted for somehow at the OS
level on server B. My assumption is that they are assigned a PID by the
OS It is this process id which I would like to capture.

I hope this clarifies what I am looking for ...

Thanks,
catharine




-Original Message-
From: Chris Sarnowski [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 23, 2006 7:04 AM
To: dbi-users@perl.org
Cc: Drozdowski, Catharine
Subject: Re: Identify PID for remote database handle

I don't know of any way to do this using DBI or DBD::Oracle.
  You might get better answers on an Oracle DBA list (try
http://www.freelists.org/list/oracle-l or http://www.lazydba.com )

This seems to work in Oracle 9.2, but I just hacked it together in a
couple of minutes and it's not thoroughly tested (i.e. testcases = 1
with 100% success).  
Also, there are probably
better ways to find your own SID. This of course assumes that the user
has access to the V$ tables (which they probably shouldn't have).

select vp.spid from v$process vp, v$session vs where vs.sid = (select
sid from v$mystat where rownum = 1) and vp.addr = vs.paddr;


I've been thinking about why you might want this and now I'm not sure
it's the answer you want anyway. Running sqlplus inside of perl seems
redundant for most purposes.
And now that I think about it I'm sure DBI/DBD::Oracle can't help you
here because it is not going to know anything about the sqlplus
connection, just the DBI handle.
So it really is off-topic for this list.

-Chris

On May 22, 2006, at 6:07 PM, Drozdowski, Catharine wrote:
> How can I find the server pid for a sqlplus session which is logged on

> remotely inside a perl program... I can find the local PID using $$ or

> $PID, but how can I find the pid for the statement/database handle 
> which is actually logged onto the database doing the work...
>
> Env: Oracle, Solaris
>
>
> Catharine Drozdowski
> Mentor Graphics Corporation
> IT Systems Services
> 1 503 685 7906
>
>
>
>




This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: problem with dbi module.

[Reidy, Ron]

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 Itanium.
I receive the following message :

naboo:/Upload# ./testperl
Can't locate loadable object for module DBI in @INC (@INC contains: 
/opt/perl/lib/5.8.3/IA64.ARCHREV_0-thread-multi /opt/perl/lib/5.8.3 
/opt/perl/lib/site_perl/5.8.3/IA64.ARCHREV_0-thread-multi 
/opt/perl/lib/site_perl/5.8.3 /opt/perl/lib/site_perl .) at 
/opt/perl/lib/site_perl/5.8.3/DBI.pm line 255
BEGIN failed--compilation aborted at
/opt/perl/lib/site_perl/5.8.3/DBI.pm 
line 255,  line 225.
Compilation failed in require at ./testperl line 3,  line 225.
BEGIN failed--compilation aborted at ./testperl line 3,  line 225.

I have downloaded and installed the module in directory 
/opt/perl/lib/site_perl/5.8.3.

Can you help me?

regards.

David.

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: DBD-Oracle.ppd

[Reidy, Ron]

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.

Robert

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: DBI-1.14

[Reidy, Ron]

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 recompiled PERL from source, to have it use gcc. The installation went
fine. I installed the following PERL Modules:
DBD-1.28
MIME-Lite-3.01
libnet-1.19

All of the above modules installed fine.

When attempting to install DBI-1.14, I am receiving the following error
when trying install the PERL Module DBI-1.14 while running make:

[EMAIL PROTECTED]># make
mkdir blib
mkdir blib/lib
mkdir blib/lib/DBD
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/DBD
mkdir blib/arch/auto/DBD/Oracle
mkdir blib/lib/auto
mkdir blib/lib/auto/DBD
mkdir blib/lib/auto/DBD/Oracle
mkdir blib/man1
mkdir blib/man3
cp Oraperl.pm blib/lib/Oraperl.pm
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp oraperl.ph blib/lib/oraperl.ph
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
/bin/perl -p -e "s/~DRIVER~/Oracle/g" <
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI/Driver.xst >
Oracle.xsi
/bin/perl -I/usr/local/lib/perl5/5.00503/sun4-solaris
-I/usr/local/lib/perl5/5.00503
/usr/local/lib/perl5/5.00503/ExtUtils/xsubpp  -typemap
/usr/local/lib/perl5/5.00503/ExtUtils/typemap Oracle.xs >xstmp.c && mv
xstmp.c Oracle.c
gcc -B/usr/ccs/bin/ -c -I/oracle/product/1.0.2/6iserver/rdbms/demo
-I/oracle/product/1.0.2/6iserver/rdbms/public
-I/oracle/product/1.0.2/6iserver/plsql/public
-I/oracle/product/1.0.2/6iserver/network/public
-I/oracle/product/1.0.2/6iserver/rdbms/demo
-I/oracle/product/1.0.2/6iserver/rdbms/demo
-I/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI
-I/usr/local/include -O
-DVERSION=\"1.14\"  -DXS_VERSION=\"1.14\" -fPIC
-I/usr/local/lib/perl5/5.00503/sun4-solaris/CORE  Oracle.c
gcc -B/usr/ccs/bin/ -c -I/oracle/product/1.0.2/6iserver/rdbms/demo
-I/oracle/product/1.0.2/6iserver/rdbms/public
-I/oracle/product/1.0.2/6iserver/plsql/public
-I/oracle/product/1.0.2/6iserver/network/public
-I/oracle/product/1.0.2/6iserver/rdbms/demo
-I/oracle/product/1.0.2/6iserver/rdbms/demo
-I/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI
-I/usr/local/include -O
-DVERSION=\"1.14\"  -DXS_VERSION=\"1.14\" -fPIC
-I/usr/local/lib/perl5/5.00503/sun4-solaris/CORE  dbdimp.c
dbdimp.c: In function `ora_db_destroy':
dbdimp.c:602: error: `dTHX' undeclared (first use in this function)
dbdimp.c:602: error: (Each undeclared identifier is reported only once
dbdimp.c:602: error: for each function it appears in.)
dbdimp.c: In function `ora_st_destroy':
dbdimp.c:1902: error: `dTHX' undeclared (first use in this function)
*** Error code 1
make: Fatal error: Command failed for target `dbdimp.o'

perl -V Makefile.PL output:
[EMAIL PROTECTED]># perl -V Makefile.PL
Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:
  Platform:
osname=solaris, osvers=2.8, archname=sun4-solaris
uname='sunos gmd-qa-app1 5.8 generic_108528-26 sun4u sparc
sunw,ultra-60 '
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef useperlio=undef d_sfio=undef
  Compiler:
cc='gcc -B/usr/ccs/bin/', optimize='-O', gccversion=2.95.2 19991024
(release)
cppflags='-I/usr/local/include'
ccflags ='-I/usr/local/include'
stdchar='char', d_stdstdio=define, usevfork=false
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
alignbytes=8, usemymalloc=y, prototype=define
  Linker and Libraries:
ld='gcc -B/usr/ccs/bin/', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lc -lcrypt
libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
  Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'


Characteristics of this binary (from libperl):
  Built under solaris
  Compiled at May 10 2006 09:54:50
  @INC:
/usr/local/lib/perl5/5.00503/sun4-solaris
/usr/local/lib/perl5/5.00503
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris
/usr/local/lib/perl5/site_perl/5.005
.

I am running Solaris 8 and Oracle 8.0.6.

Any help would be greatly appreciated.

Jon Baldassari
Senior System Administrator
PR Newswire LLC

Phone +1 201 369 3462 | Mobile +1 973 493 3508
[EMAIL PROTECTED] | [EMAIL PROTECTED] |
www.prnewswire.com

"We tell your story to the world."


NEWS TARGETING * REGULATORY & GLOBAL NEWS DISTRIBUTION * MULTIMEDIA *
NEWS MONITORING


Any views or opinions are solely those of the author and do not
necessarily represent those of PR Newswire. The contents are intended
only for the
addressee and may contain conf

RE: DBI->data_sources('Oracle')

[Reidy, Ron]

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, 2006 1:55 PM
To: Loo, Peter # PHX
Cc: dbi-users@perl.org
Subject: Re: DBI->data_sources('Oracle')

As far as I understand DBD::Oracle (the driver DBI uses for Oracle), it 
is "just" a translator for the Oracle Call Interface (OCI), and to my 
knowledge, OCI uses TNSNAMES.ORA. If you use a recent Oracle client 
software, the OCI may perhaps emulate a TNSNAMES.ORA based on the Oracle

Internet Directory.  *If* that works, it is documented (or should I say 
burried alive?) somewhere in the Oracle documentation. My guess is that 
you would add some special entry to TNSNAMES.ORA to make the OCI lookup 
databases in the Oracle Internet Directory.

Alexander

On 02.05.2006 21:09, Loo, Peter # PHX wrote:

>Is there anyway that I can force Perl DBI to not use TNSNAMES.ORA and
>instead use Oracle Internet Directory?
>
>-Original Message-
>From: Alexander Foken [mailto:[EMAIL PROTECTED] 
>Sent: Tuesday, May 02, 2006 11:29 AM
>To: Loo, Peter # PHX
>Cc: dbi-users@perl.org
>Subject: Re: DBI->data_sources('Oracle')
>
>First guess: $ORACLE_HOME/NETWORK/ADMIN/TNSNAMES.ORA  or
>$ORACLE_HOME/NET80/ADMIN/TNSNAMES.ORA.
>
>Alexander
>On 02.05.2006 20:15, Loo, Peter # PHX wrote:
>
>  
>
>>Hi All,
>>
>>Will someone please tell me where this module is getting the 
>>information from?  One of my severs that I am trying to connect to is 
>>NOT listed in the output of:
>>
>>@databases = $dbh->data_sources('Oracle');
>>
>>Thanks.
>>
>>Peter
>>
>>
>>
>>This E-mail message is for the sole use of the intended recipient(s)
>>
>>
>and may contain confidential and privileged information.  Any
>unauthorized review, use, disclosure or distribution is prohibited.  If
>you are not the intended recipient, please contact the sender by reply
>E-mail, and destroy all copies of the original message.
>  
>
>> 
>>
>>
>>
>
>
>--
>Alexander Foken
>mailto:[EMAIL PROTECTED]  http://www.foken.de/alexander/
>
>
>
>This E-mail message is for the sole use of the intended recipient(s)
and
>may contain confidential and privileged information.  Any unauthorized
>review, use, disclosure or distribution is prohibited.  If you are not
>the intended recipient, please contact the sender by reply E-mail, and
>destroy all copies of the original message.
>
>
>This E-mail message is for the sole use of the intended recipient(s)
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is prohibited.  If
you are not the intended recipient, please contact the sender by reply
E-mail, and destroy all copies of the original message.
>
>  
>


-- 
Alexander Foken
mailto:[EMAIL PROTECTED]  http://www.foken.de/alexander/


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Checking if a table exist

[Reidy, Ron]

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 a good way to check if a table exist disregarding
whether the table has data or not?
 
Thanks.
 
Peter


This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Oracle functions through DBI?

[Reidy, Ron]

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 nothing bout that on the web), can I use DBI
to
execute some oracle DB functions?
Here's my case: I have a (oracle) function that returns a new free ROW
ID
randomly and I have to manage that RI from a perl script. Can I use DBI
to
submit the request to oracle? for me it would be much more simple and
efficient than the same old way!!

thanks
Riccardo

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.