Hi,
Maybe this is old news to some, but the
FAQ link and support-details links (any of them) aren't working on
dbi.perl.org.
Jay
On Saturday 25 March 2006 9:48 pm, Jorge Valenzuela wrote:
Hello, I hava a bug/error in a OpenPower IBM 720 with
Power5 processor and with LINUX SUSE Enterprise Server
9.0
Can you help me?
Thank you?
Its definitely the fetzer valve. You'll need a JB-12 wrench to replace it
Jay
On Tuesday 21 March 2006 5:31 am, Ganesh Prasad A K wrote:
Can't locate loadable object for module DBI in @INC (@INC contains:
C:/Perl/lib C:/Perl/site/lib .) at C:/Perl/lib/DBI.pm line 255 .
i am getting this error while i execute the program.
please give me solutions.
did you:
PPM3
On Saturday 31 December 2005 2:18 pm, Tyler MacDonald wrote:
Hi,
I was hoping to start a discussion about this; there is currently no
place on CPAN specifically designated for a distribution that supplies a
database schema, and perl modules specifically for interacting with that
On Thursday 01 December 2005 11:24 pm, Ron Savage wrote:
Hi Folks
I see that if I have
create table history (history_timestamp timestamp not null)
I can insert into this with
insert into history (history_timestamp) values
(to_date('2005-12-02', '-MM-DD') || ' 03:39:25PM')
opps 24
On Thursday 01 December 2005 11:24 pm, Ron Savage wrote:
Hi Folks
I see that if I have
create table history (history_timestamp timestamp not null)
I can insert into this with
insert into history (history_timestamp) values
(to_date('2005-12-02', '-MM-DD') || ' 03:39:25PM')
On Friday 02 December 2005 12:58 am, you wrote:
On Fri, 2 Dec 2005 17:50:08 +1100, Steve Baldwin wrote:
Hi Steve
Thanx.
This may not answer your question, but you can incorporate the time
format mask in the call to TO_DATE. For example ...
insert
into history (history_timestamp)
On Tuesday 22 November 2005 12:25 pm, Martindale, Marty (NGIT) wrote:
Can't remove directory C:\TEMP/DBD-Oracle-1-452-1132683710: Permission
denied at C:/Documents and Settings/vaaacmartic/My
I think the above might hold the clue
Jay
Also try doing it in a directory that doesn't have spaces in the name (i.e.
start ppm in c:\dbd
Jay
On Wednesday 16 November 2005 3:01 pm, piet paaltjens wrote:
Dear Jay,
some time ago you've helped me to try and get Oracleinstantclient 10.2
to work on my machine. You even sent me your installed software. For me,
alas, it did not work. Just to let you know, recently I've found info
Hi,
How come this list doesn't have a [dbi-users] in the subject?
That would be handy for message filtering
Thanks
Jay
piet paaltjens wrote:
Dear Jay,
the result remains unchanged:
perl Makefile.PL -m
/usr/local/oracle/instantclient_10_2/demo/demo.mk
Using DBI 1.48 (for perl 5.008003 on
i386-linux-thread-multi) installed in
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/auto/DBI/
Configuring
piet paaltjens wrote:
see below
Dear Tim,
I've just downloaded and tested the Oracle 10 Instant
client software, including SQL*Plus. This appears to
work well, with ORACLE_HOME, LD_LIBRARY_PATH and PATH
settings. However when I try execute : 'install
DBD::Oracle' this is what I get:
The
Gupta, Razat wrote:
While installing a module of perl on Solaris box. I am getting some
problem.
I have downloaded DBI.1.48.tar.gz
Untar it.
I have run the command
perl Makefile.pl - OK
make - shows some error which is mentioned below:
make: gcc: Command not found
make: ***
Jay Strauss wrote:
Hi,
Does anyone have a WORKING recipe for building DBD::Oracle against
Instant client? I have followed the recipes:
...
I'm doing this on linux
thanks
Jay
Hate replying to my own message. You must edit the Makefile.pl to point
at YOUR OWN header files. In my case
Charles Seelig wrote:
- TNS_ADMIN is not set in either the registry or environment.
- Not run by web server; only from the command line.
CS
ora-12154 (tns-12154) means it can't find the service name you
requested. So that means:
1) the service name you requested doesn't exist in your
Hi,
Does anyone have a WORKING recipe for building DBD::Oracle against
Instant client? I have followed the recipes:
http://groups.google.com/group/perl.dbi.users/browse_thread/thread/c166e7d297d388fc/2770a60133842123?q=instant+clientrnum=3hl=en#2770a60133842123
I guess not
- Original Message -
From: Jay Strauss [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 07, 2002 5:06 PM
Subject: Oracle on Debian
Hate to be totally off-topic but: Has anyone ever successfully installed
oracle 9i on Debian? I've done my share of google
Hate to be totally off-topic but: Has anyone ever successfully installed
oracle 9i on Debian? I've done my share of google searches and came up
nothing (except a total kludge of making a dual boot debian/suse, boot
suse - install - oracle, boot deb, mount suse partition)
Anyone???
Thanks
Jay
Gonna read the doc now. Thanks
- Original Message -
From: Jeff Zucker [EMAIL PROTECTED]
To: Jay Strauss [EMAIL PROTECTED]
Cc: dbi-users [EMAIL PROTECTED]
Sent: Saturday, March 02, 2002 5:13 PM
Subject: Re: ANNOUNCE: SQL::Statement 1.003 on CPAN
Jay Strauss wrote:
Not to be dense
Not to be dense, I read the readme. Does this module let one make SQL
requests of flat files (excel, cvs) by itself? Do you need other modules?
Is there anymore documentation I can read (preferably with examples) of how
to use this?
Jay
- Original Message -
From: Jeff Zucker [EMAIL
Yes, yes
Download and install DBI, DBD-Oracle (from perl.com) and request the latest
version of the README.hpux
Jay
- Original Message -
From: Singh, Kiranjit [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 25, 2002 8:21 AM
Subject: Installing DBI on HP-UX
Hi,
Is it
How about
$sql = select * from v\$session;
- Original Message -
From: Ian Carney [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 05, 2002 7:42 AM
Subject: reading v$ tables using dbi
I am trying to read v$ tables as system on a networked
database, and get ora-942,
I think the ) is supposed to be on the other side of $value[3]
- Original Message -
From: Rick Windham - ISDLIS [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, February 01, 2002 10:21 AM
Subject: Still having trouble inserting date into Oracle
Hello all,
Here is the code snip
In the README.hpux doc it says:
---
In my case, LhtStrInsert was undefined. To solve this problem, I had
to looked though the Oracle libraries using nm. I found the symbol
in 3 separate libraries in $ORACLE_HOME/lib. I then proceeded to as these
libraries to the OTHERLDFLAGS makefile macro
Here is how I do it (the tricky bits are getting your LD_LIB_PATH,
SH_LIB_PATH... envs correct, and modifying the compile defaults), this is
for 64bit:
cd /opt/perl/src
gunzip -c stable.tar.gz | tar xvf -
cd perl-5.6.1
rm Policy.sh config.sh
sh Configure -Ubincompat5005 -Dprefix=/opt/perl
You can do it like this:
#!/usr/bin/perl
use DBI;
use strict;
my ($start,$end) = @ARGV;
my $dbh=DBI-connect(dbi:Oracle:,'system','manager');
my $sql = q[
select '1'
from dual
where to_char(sysdate,'HH24') = ?
and to_char(sysdate,'HH24') ?
];
my $count =
I get the feeling you're mixing apple and oranges.
OS authentication - means you don't need to supply a userid or password.
You connect to the database as the OS user (of the process trying to
connect). You need to have the
REMOTE_LOGIN_PASSWORDFILE =none in the init.ora. And you need to
Hopefully you got this working already, but:
You must be able to make a remote connection to your database OUTSIDE of
perl. For example
sqlplus system/manager@remoteName
Where remoteName is an entry in your tnsnames.ora file
After you can do that, your connect line is:
my $dsn =
Dong,
I think you're mixing apples and oranges. You can get a local connection
(avoid sqlnet and the listener) in 2 ways (that I know of):
1) $dbh = DBI-connect(dbi:Oracle:,$userid,$passwd);
2) define and entry in your tnsnames.ora like (*note my ORACLE_SID=o817):
LOCAL.world =
Unfortunately, setting up an oracle client is (sort of) confusing to the
inexperienced (and beyond the scope of DBI, but there is lots of stuff
published on the web). In short you do NOT need to install the oracle
database. But you do have to download the entire database software (when
you are
- Original Message -
From: Richard Allen [EMAIL PROTECTED]
To: Jay Strauss [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, September 27, 2001 8:54 AM
Subject: Re: DBD-Oracle-1.12 on HP-UX 11
On Wed, Sep 26, 2001 at 07:57:48AM -0500, Jay Strauss wrote:
Do a:
$ env | sort
Do a:
$ env | sort
and post the output
- Original Message -
From: Richard Allen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 25, 2001 11:28 AM
Subject: DBD-Oracle-1.12 on HP-UX 11
Im trying to install DBD-Oracle-1.12 on a HP-UX 11 host.
The box is a PA-Risc 1.1
In the past personal oracle didn't come with a listener, hence personal.
I'm not sure if that's the case anymore. If so, you can download for free
at technet.oracle.com
- Original Message -
From: M.W. Koskamp [EMAIL PROTECTED]
To: Byron Wise [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent:
Thanks, works as advertised
Jay
- Original Message -
From: Steven Baldwin [EMAIL PROTECTED]
To: Jay Strauss [EMAIL PROTECTED]; [EMAIL PROTECTED]
[EMAIL PROTECTED]
Sent: Monday, September 10, 2001 7:41 PM
Subject: RE: This connection with DBD::Oracle
Try this ...
select * from v
current session by selecting from v$session using a
combination of username, logon_time, type, program... but it seems
inelegant.
Thanks
Jay
Jay Strauss
[EMAIL PROTECTED]
_
Do You Yahoo!?
Get your free @yahoo.com address at http
Hi,
I'm trying to write a daemon that accesses my database. I thought I could
create the connection in the parent, and use it in the child. But that
doesn't seem to work. Below is the code. Any help would be appreciated
Thanks
Jay
#!/usr/bin/perl -w
use strict;
use DBI;
use POSIX
Hi,
I'm trying to write a daemon that accesses my database. I thought I could
create the connection in the parent, and use it in the child. But that
doesn't seem to work. Below is the code. Any help would be appreciated
Thanks
Jay
#!/usr/bin/perl -w
use strict;
use DBI;
use POSIX
=$ORACLE_HOME/network/admin
export SHLIB_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin
cd /opt/perl/src
gunzip -c DBD-Oracle-1.08.tar.gz | tar xvf -
cd DBD-Oracle-1.08
perl Makefile.PL
make
make test
make install
Hope this helps someone
Jay Strauss
[EMAIL PROTECTED
, { ora_session_mode = $mode });
But, this method requires the password. Does anyone know how to do it
without a password?
Jay Strauss
[EMAIL PROTECTED]
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
You mean you can't startup and shutdown oracle from DBI?
That was the whole plan
Jay
- Original Message -
From: PD Miller [EMAIL PROTECTED]
To: Jay Strauss [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, April 27, 2001 10:56 AM
Subject: Re: connecting / as sysdba when using DBI/DBD
41 matches
Mail list logo