-
From: David Dooling [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 12, 2007 2:01 PM
To: dbi-users@perl.org
Subject: Re: ORA-12154: TNS:could not resolve the connect identifier specified
On Wed, Dec 12, 2007 at 01:28:37PM -0700, Loo, Peter # PHX wrote:
I tried setting both variables
To: dbi-users@perl.org
Subject: Re: ORA-12154: TNS:could not resolve the connect identifier specified
Loo, Peter # PHX wrote:
Hello All,
I am confused as to why I am getting this error message. I am trying
to connect to two different Oracle instances within one program run.
The two
corresponding
tnsnames.ora file, create two tns entries each pointing to one instance. Then
the connection calls can pass in different connection strings to connect to
different instances.
Alan
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 12
]
Sent: Wednesday, December 12, 2007 3:21 PM
To: Loo, Peter # PHX
Cc: dbi-users@perl.org
Subject: RE: ORA-12154: TNS:could not resolve the connect identifier
specified
Hello!
On Wed, 12 Dec 2007, Loo, Peter # PHX wrote:
Hi Martin,
I tried setting both variables
Hello All,
I am confused as to why I am getting this error message. I am trying to
connect to two different Oracle instances within one program run. The
two Oracle instances are different in versions. inst1 is 9.2 while
inst2 is 10.2. I am able to connect to the first instance without
Hiroshi,
What names are you looking for? Column names?
Peter
-Original Message-
From: 田口 浩 [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 06, 2007 7:19 PM
To: dbi-users@perl.org
Subject: Getting all names in mdb
Hello,
I'm using .mdb file with DBI/DBD::ODBC.
my $dbh =
Hello All,
While I am able to logon to one Oracle database, I am getting core dump
on another. I turned on the DBI-trace and here is what I have. Will
anyone help me with this? In debug mode, the last line before core dump
is:
Thanks. I don't know what I did wrong the first time, but now it is
working. Thanks again.
Peter
-Original Message-
From: Garrett, Philip (MAN-Corporate)
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 14, 2007 5:25 PM
To: Loo, Peter # PHX; dbi-users@perl.org
Subject: RE: Multiple
Hi,
I am trying to execute two SQL statements within one call to $dbh-do()
and Perl DBI is not happy.
Here is a sample call:
$sql = qq{delete from some_table
where condition_one
andcondition_two;
insert into some_table (col_1, col_2, col_3)
Hey Robert,
Are you going from Oracle to Oracle?
Peter
-Original Message-
From: Robert Hicks [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 07, 2007 7:52 AM
To: dbi-users@perl.org
Subject: Load Testing Script
Does anyone have such a beast for Oracle? I am trying to eliminate the
From a flat file?
Peter
-Original Message-
From: Robert Hicks [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 07, 2007 9:47 AM
To: dbi-users@perl.org
Subject: Re: Load Testing Script
Loo, Peter # PHX wrote:
Hey Robert,
Are you going from Oracle to Oracle?
Peter
Yup...I am
Hello Everyone,
I have a large program that loops through approximately 150 rows of data
from an Oracle database using Perl DBI. Within each row of data the
program performs further actions like logging on to a different database
(Netezza using ODBC driver) to gather further information then
Hi,
The same program that ran successfully yesterday is failing with the
following error today. Can someone please shed some light what this
error means?
ERROR: Connection failed to x for user x.
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.8.7/s
To: Loo, Peter # PHX; dbi-users@perl.org
Subject: Re: Oracle.so
You most likly are not pointing to the correct Oracle path.
You are pointing to most-likely the 64 bit so lisb file rather than the
32 bit so libs that DBD::Oracle requires.
here are some links to similar problems
http://www.issociate.de
Hi,
I am trying to execute multi SQL statements within the $dbh-do() and it
appears to work fine except it does not give me an error when part of
the SQL fails. For example:
BEGIN WORK;
CREATE TEMP TABLE p_temp AS
SELECT col1
, col2
, col3
FROM table1
, table2
WHERE
, NEVER put values inside the SQL statements, this begs for
trouble and usually performs suboptimal.
Hope that helps,
Alexander
Loo, Peter # PHX wrote:
Hi,
I am trying to execute multi SQL statements within the $dbh-do() and
it appears to work fine except it does not give me an error when
Hello,
I am simply testing a DBI-connect, $dbh-prepare and $sth-execute for
the following bundled SQL statement. I am not receiving any errors at
all. I should have received the following error:
Error: ERROR: Relation 'tmp_ppv_store_panel_seq' already exists
(State:HY000, Native Code: 6C)
All,
Never mind, I have just been informed that in Netezza the temp tables
only exist during the session.
Thanks.
Peter
From: Loo, Peter # PHX
Sent: Tuesday, November 28, 2006 7:56 AM
To: DBI-Users
Subject: Not receiving any errors back from DBD::ODBC
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, FH line 53.
Thanks.
Peter
:[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
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, FH line 53.
Peter
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL
much other than to clarify that this driver
is not fully ODBC complaint in its error reporting.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 05, 2006 12:15 PM
To: Loo
Hi Martin,
Here it is. I have removed the host names.
$ cat /usr/local/etc/odbc.ini
[ODBC]
DebugFile = /tmp/oplhsodbc.log
TraceFile = /tmp/ihsodbc.log
Trace = 1
[ODBC Data Sources]
[AB01]
Driver= /usr/local/nz/lib/libnzsqlodbc.so
Description = NetezzaSQL ODBC
Servername
Hi,
Can someone please tell me what the size is when I set it to 1000? Is
it one meg?
Thanks.
Peter
Hi All,
What would you recommend I set this option to if I am sending all the
SELECTed rows to a named pipe?
Peter
-Original Message-
From: Ronald J Kimball [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 31, 2006 2:23 PM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: $dbh
Hi Ron,
Here are the results of sqlplus and Perl DBI connections:
SQLPLUS CONNECTION:
===
$ sqlplus [EMAIL PROTECTED]
SQL*Plus: Release 9.2.0.4.0 - Production on Wed Aug 16 10:26:54 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
Oops! Sorry folks. I replied to the wrong thread. I will resend.
Peter
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 16, 2006 10:39 AM
To: Reidy, Ron; [EMAIL PROTECTED]; dbi-users@perl.org
Subject: RE: what to do ?
Hi Ron,
Here
THE PROGRAM JUST HANGS HERE, BUT IF I RUN IT WITHOUT DEBUG, I GET THE
FOLLOWING ERROR MESSAGE:
$ ./testCon.pl
Segmentation Fault(coredump)
Peter
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 5:34 PM
To: Loo, Peter # PHX; DBI-Users
: Wednesday, August 16, 2006 12:39 PM
To: Loo, Peter # PHX
Cc: DBI-Users
Subject: Re: Using Oracle Internet Directory (OID) instead of TNS Names
In message
[EMAIL PROTECTED]
m, Loo, Peter # PHX writes:
$ ./testCon.pl
Segmentation Fault(coredump)
Lets see the output of pstack(1) for that core.
You
PROTECTED]
Sent: Wednesday, August 16, 2006 12:57 PM
To: Loo, Peter # PHX
Cc: DBI-Users
Subject: Re: Using Oracle Internet Directory (OID) instead of TNS Names
In message
[EMAIL PROTECTED]
m, Loo, Peter # PHX writes:
$ pstack core
core 'core' of 13643: /usr/bin/perl ./testCon.pl
fe6fbd6c gslufpFLog
=32768)(CONNECT_D
ATA=(SID=INSTANCE_NOT_IN_TNSNAMES_FILE)))
OK (10 msec)
Peter
-Original Message-
From: John D Groenveld [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 16, 2006 12:57 PM
To: Loo, Peter # PHX
Cc: DBI-Users
Subject: Re: Using Oracle Internet Directory (OID) instead
Jeffrey,
The problem is that I need to know the version of the INSTANCE before
logging on to it.
Peter
-Original Message-
From: Jeffrey Seger [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 16, 2006 3:19 PM
To: Loo, Peter # PHX
Cc: John D Groenveld; DBI-Users
Subject: Re: Using
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
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
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
, 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
-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
.
Peter Loo
-Original Message-
From: Rob Biedenharn [mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 4:13 PM
To: Loo, Peter # PHX
Cc: DBI-Users
Subject: Re: Invalid authorization specification (SQL-28000)
Peter,
Try changing that to:
$dbh = DBI-connect(dbi:ODBC:testdb, testid
completes.
Thanks everyone.
Peter Loo
-Original Message-
From: Loo, Peter # PHX
Sent: Monday, July 31, 2006 3:24 PM
To: 'Rob Biedenharn'
Cc: DBI-Users
Subject: RE: Invalid authorization specification (SQL-28000)
Hi Rob,
Thanks for the input. What I did was I hard coded the database
-Users
Subject: Re: Invalid authorization specification (SQL-28000)
Loo, Peter # PHX wrote:
Hi Martin,
The only way that I know that unixODBC is involved is by the
indication within the error message. As soon as I create a .odbc.ini
file in my home directory, the program spits out
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
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
-
From: Rob Biedenharn [mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 2:56 PM
To: Loo, Peter # PHX
Cc: DBI-Users
Subject: Re: Invalid authorization specification (SQL-28000)
Depending on how the ODBC provider is configured, the 'testuser' may not
be used (nor the supplied password
;
}
if ($@) {
.
.
.
}
Thanks for all your input.
Peter
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 05, 2006 3:18 AM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: sth-do()
Peter,
While you might find this external table does not exist
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
()
Loo, Peter # PHX wrote:
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
'\' 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
Hi All,
I am getting the following error when I try INSERTing selected rows from
one database to another.
ORA-01843: not a valid month
Do I have to use to_date() and if so, has anyone done this with bind
variables?
I am using bind variables to INSERT the selected rows. Below is the
code
Hi All,
I have an interesting requirement and am hoping that I can obtain a
solution here.
I have the need to get several billion rows from multiple Oracle tables
to tables on a Netezza database. I have tried several ways to get the
data over to Netezza using Perl DBI by opening two database
Philip,
This is an excellent idea. I created a sub-routine to parse out the sql
file in to a string like Ravi had suggested like the following. It is
ugly, but has been working for awhile.
sub sub_readSQLFile($) {
print STDERR \n* sub_readSQLFile() *\n\n;
my ($sqlFile) = @_;
Thanks Mark and Steve B. for your comments. I will make the changes to
the program. Excellent advise.
Peter Loo
Wolters Kluwer Health
(602) 381-9553
-Original Message-
From: markd [mailto:[EMAIL PROTECTED]
Sent: Monday, May 22, 2006 6:24 PM
To: Loo, Peter # PHX
Cc: dbi-users
Hi,
I was wondering if someone can tell me how, where and what Perl DBI
stores the data returned from fetchall_arrayref. For example: if I
issues a SELECT statement such as select a.col1, b.col2, c.col3 from
someTable1 a, someTable2 b, someTable3 c where someCondition. From
this I get an
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
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
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,
Thanks Jonathan. I was thinking about doing something like this:
@tables = $dbh-tables();
if ((grep/$tableName/, @tables) = 0) {
...
From: Jonathan Leffler [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 27, 2006 5:17 PM
To: Loo, Peter # PHX
Cc: DBI
Hi Ron,
Do you mean plug in the work undef before doing the INSERT?
Thanks.
Peter Loo
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 19, 2006 9:39 PM
To: List - DBI users
Subject: Re: Bad int8 external representation (SQL-HY000)(DBD:
Apr 2006 11:44:50 -0700, Loo, Peter # PHX wrote:
Hi Peter
[unixODBC]ERROR: copy: line 1, Bad int8 external representation
(SQL-HY000)(DBD: st_execute/SQLExecute err=-1)
Line 1, eh? First attempt to insert data? Did you try chomp-ing the
line?
--
Cheers
Ron Savage, [EMAIL
-0700, Loo, Peter # PHX wrote:
Hi Peter
Do you mean plug in the work undef before doing the INSERT?
Yes. Off the top of my head (add error checks!):
$sql = 'insert into table_x (column_y, column_z) values (?, 99)'; $sth =
$dbh - prepare($sql); $sth - execute(undef);
--
Cheers
Ron Savage, [EMAIL
Hi All,
Has anyone seen this error before and if so would you know the solution
to fixing it?
DBD::ODBC::st execute failed: [unixODBC]Prepared statement not a cursor
specification (SQL-07005)(DBD: describe/SQLDescribeCol err=-1)
I am trying to loop through the returned values of a select
Hello All,
I am attempting to INSERT into a table while reading in from a piped
delimited file and am getting the following error:
[unixODBC]ERROR: copy: line 1, Bad int8 external representation
(SQL-HY000)(DBD: st_execute/SQLExecute err=-1)
The destination table (Netezza) layout is (38
Hi,
I am passing the correct arguments to dump_results, but it appears that
the records are not getting separated with new line.
$maxlen = 500;
$lsep = '\n';
$fsep = '|';
$fh = \*FH;
$rows = $sth-dump_results($maxlen, $lsep, $fsep, $fh);
The records are getting output with the line feed and
Thanks Ronald.
Peter Loo
Wolters Kluwer Health
(602) 381-9553
-Original Message-
From: Ronald J Kimball [mailto:[EMAIL PROTECTED]
Sent: Friday, April 14, 2006 6:51 AM
To: Loo, Peter # PHX; dbi-users@perl.org
Subject: RE: dump_results
Loo, Peter # PHX [mailto:[EMAIL PROTECTED]:
I am
Michael,
Thanks for all your advise. I will give them a try now.
Peter
-Original Message-
From: Michael A. Chase [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 5:23 AM
To: Peter Loo; Loo, Peter # PHX; [EMAIL PROTECTED]
Subject: Re: Stored Procedure (arguments)
Comments
('sl:ctdm');
Thanks.
Peter
-Original Message-
From: Michael A. Chase [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 8:02 AM
To: Peter Loo; Loo, Peter # PHX; [EMAIL PROTECTED]
Subject: Re: Stored Procedure (arguments)
I forgot to mention. You are not checking for errors after the
if ($@) {
DB10 p $sth
DBI::st=HASH(0x3aae84)
DB11 q
runAgg_TAlgnRxTerrSpcltDrugPlan.pl[2]: /export/home/ip00622: cannot execute
-----Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 10:18 AM
To: 'Michael A. Chase'; Peter Loo; Loo, Peter #
2001 1:39 PM
To: Loo, Peter # PHX; [EMAIL PROTECTED]
Subject: Re: Unix export
Any value you add to %ENV is added to the environment of the current process
and any called subprocesses. They won't return to the program that called
the Perl script though.
--
Mac :})
** I normally forward privat
script and test it to see what the results are on your platform :)
cheers,
Aaron
-Original Message-
From: Brett W. McCoy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 2:32 PM
To: Loo, Peter # PHX
Cc: [EMAIL PROTECTED]
Subject: RE: Unix export
On Tue, 13 Mar 2001, Loo, Peter
Hi All,
Can someone please tell me what this is all about?
DBD::Oracle::st execute failed: ORA-01036: illegal variable name/number (DBD
ERROR: OCIBindByName) at sma_run_aggs.pl line 172.
Here is my syntax:
foreach $tableName (@tableList) {
print STDERR "\n\nDropping indexes
Mark,
I tried it with commas also and it gave me the same error message. I tried
using the bind also and not successful.
Peter
-Original Message-
From: Mark Vandenbroeck [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 4:40 PM
To: Loo, Peter # PHX
Cc: '[EMAIL PROTECTED
How do you check for a correct version? I am seeing all sort of information
with different values.
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 5:14 PM
To: Loo, Peter # PHX; 'Mark Vandenbroeck'
Cc: [EMAIL PROTECTED]
Subject: RE: Stored
Hi Ilya,
No it is not working with '?' either. Nothing is print out for:
#!/usr/bin/perl
use DBI;
print "$DBD::Oracle::VERSION\n";
exit;
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 5:38 PM
To: Loo, Peter # PHX; 'Mark Va
: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 5:38 PM
To: Loo, Peter # PHX; 'Mark Vandenbroeck'
Cc: [EMAIL PROTECTED]
Subject: RE: Stored Procedure (arguments)
Forgot how to do the easy way, but just print out the
$DBD::Oracle::VERSION
Did it work with '?' instead of ':1
Hi
All,
I want to
set this environment on so that anything that the store procedure spits out will
show during the debug process within Perl DBI connection. Can someone
please show me how I can set this?
$dbh-do("SET SERVEROUTPUT ON");
Not
working. Please help.
Peter
$sth-finish;
foreach ($dbh-func('dbms_output_get')) {
print "$_\n"; }
$dbh-disconnect();
exit;
-Original Message-From: Loo, Peter # PHX
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 20, 2001 1:02
PMTo: [EMAIL PROTECTED]Subject: SET SERVEROUTPUT
ON
Hi
All,
I want to
set
75 matches
Mail list logo
