We had this problem before. This is related to a change Oracle did in
their Oracle_Home definition in the registry values. One way to fix this is
to either tinker with the registery, or do a ppm install DBD:Oracle8.
-Original Message-
From: READY, MIKE P [mailto:[EMAIL PROTECTE
$sth1=$dbh1->prepare("SELECT * from where rownum < 2") || die
$dbh->errstr; $sth1->execute;
$tfields1 = $sth1->{NUM_OF_FIELDS}; $tfields1--;
for ($tt=0; $tt <= $tfields1; $tt++)
{
$name1[$tt] =
$sth1->{NAME}->[$tt]; $type1[$tt]
= $sth1->
Yes.
Run a connect to each DB you want to work with. You can then run queries
with a where clause of 'rownum <= 20' to get a sampling of a table from each
DB. I'm not sure about a page count myself, but you can check the number of
records in each DB in each table with a 'select count(*)' query
Look at installing DBD::Oracle8 and see if this clears the problem up.
Oracle changed some standards recently that regular DBD::Oracle got lost in.
-Original Message-
From: Philip Daggett [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 12:38 PM
To: [EMAIL PROTECTED]
Cc: [EMA
Trying to get output from a procedure call. Definitely being a pain. Yes,
yes, I've looked at perldoc DBD::Oracle and that didn't seem to work. I've
even read up on perldoc.com about DBI, and various other websites. Running
out of options.
stats: Windows NT client/server with Oracle 8.1.5 i
What error message did you get ??
Where is your coding at ??
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 7:39 AM
To: [EMAIL PROTECTED]
Subject: DBI use with DBD:Oracle module
Hi.
I'm trying to use DBI with the DBD::Oracle
THE NEW CODE:
#!/usr/bin/perl -w
use DBI;
use DBD::Oracle qw(:ora_types);
print "connecting to database... ";
$dbh = DBI->connect('DBI:Oracle:blah', 'blah', 'blah') || die
$dbh->errstr;
$dbh->{RaiseError} = 1;
print "done!\n";
print "preparing the statement... ";
$sth = $dbh
Thank you ... I knew I had to be overlooking something ...
-Original Message-
From: Oleg Mechtcheriakov [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 9:55 AM
To: 'Jones Robert Contr 81 CS/SCK'; [EMAIL PROTECTED]
Subject: RE: Looping Scenario
Hi,
the expl
This is an interesting scenario that had me going for hours to figure
out. I've cut-n-pasted the relevent sections below in a brief edited format
for simplicity.
$sth=$rbh->prepare("SELECT * from table where field='$value[1]'")
$sth->execute;
while (@tvalue=$sth->fetchrow_array)
{ $
If your DB has the name, link stored in it then just select both columns and
then output them to your HTML formatted output. Small example:
$sth=$dbh->do("select player, link from hockeylist");
print qq!$player!;
-Original Message-
From: Simon K. Chan [mailto:[EMAIL PROTECTED]]
Sent
Alter session set nls_date_format='mmddhh24:mi:ss' ???
It probably doesn't like the dd being concatenated against the hh24 section
without a space either
-Original Message-
From: Jeff Thies [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 3:02 PM
To: [EMAIL PROTECTED]
Su
Of course ... With a good mailing list engine it could automatically
remove the duplicate footer lines. And with Perl that should be easy to do
=:)
-Original Message-
From: Ronald J Kimball [mailto:[EMAIL PROTECTED]]
On Wed, Jun 06, 2001 at 02:04:51PM -0600, Sterin, Ilya wrote:
>
If your system is set up and configured correctly then you should never have
to set the environment variable ORACLE_HOME or ORACLE_SID in any Perl
program using DBI. The ORACLE_HOME should be read in from the registry
location. The ORACLE_SID will be defined in the connect string association
to
Robert Contr 81 CS/SCK wrote:
>
>
> We have Oracle version 8 loaded on Windows NT boxes. We also have
> ActiveState Perl build 522 installed with DBI 1.14 and DBD-Oracle 1.03.
>
> The problem we are having is that on one NT server everything runs
> fine. The
No we don't ... Both have account on their systems with the same accounts
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 4:58 PM
To: Jones Robert Contr 81 CS/SCK
Cc: [EMAIL PROTECTED]
Subject: Re: Oracle DBI on Windows NT
We have Oracle version 8 loaded on Windows NT boxes. We also have
ActiveState Perl build 522 installed with DBI 1.14 and DBD-Oracle 1.03.
The problem we are having is that on one NT server everything runs
fine. The Perl program does its thing and connects to the Oracle database
an
Wouldn't you want to use a variable here instead of a placeholder ??
my $sth = $dbh->prepare(q{
BEGIN select vtr_id into $cursor from t_vertraege
where vtr_nr='$vbb_ver_nr';
END;
});
-Original Message-
From: Bart Lateur [mailto:[EMAIL PROTECTED]]
Sent: Wednesday
How about coding so we can see what you are doing. We're not all omnipotent
.. yet ..
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 8:25 AM
To: [EMAIL PROTECTED]
Subject: db-connections and child processes
Hello,
I am having a prob
Try this approach instead
my $sqlcmd = "select * from street";
my $tbh = $dbh->prepare($sqlcmd);
$tbh->execute;
while(@dbres = $tbh->fetchrow_array)
{
.
.
.
}
-Original Message-
From: Sei Heng Ang [mailto:[EMAIL PR
The address of the remote server should be associated with your server name.
This will be stored in the tnsnames.ora file in your Oracle directory with
the IP address, port information, and database name.
-Original Message-
From: Julio Santiago [mailto:[EMAIL PROTECTED]]
Sent: Monday,
We've noticed this here ... You can fix this temporarily by typing or
setting
'set ORACLE_HOME=' or in the system environment.
-Original Message-
From: Julio Santiago [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 10:38 AM
To: [EMAIL PROTECTED]
Subject: DB Connection
Hello All
Try ...
$dbh->{AutoCommit} = 0;
-Original Message-
From: Curt Russell Crandall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 1:57 PM
To: [EMAIL PROTECTED]
Subject: dbish questions
There's a couple of things I'm having a proble with when trying to use
dbish. First, I wan
22 matches
Mail list logo