That's an Oracle error and a quick search on Metalink indicates that
this tends to happen with tools like Pro*C and if DBD::Oracle uses the
OCI like Pro*C then this bug will apply also. It is reproducable in
8.1.x 9.0.x and 9.2.0.1 ... Apparently the solution is (guess what?)
upgrading to Oracle
Jeff Zucker mailto:[EMAIL PROTECTED] wrote:
Your quote marks were messing you up and the easiest way to
avoid that
and other problems is to use placeholders (the ? in the $sql_dmd).
Or use the Perl qq() construction which avoids the problem alltogether.
--
Mark Galbraith
CERT UNIX
Hi,
We have tried this way of connecting as well. This again seem to be not
working.
We are using the DBI version 1.06. From your mail, we find that it is
working for DBI vesion 1.35.
Does this mean that we have to upgrade the DBI ? If so, to which version?
Regards
Jayashree
Ability is
I would go with the latest and greatest.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Friday, March 12, 2004 12:50 AM
To: Gold, Samuel (Contractor); [EMAIL PROTECTED]
Subject: RE: DBI with ORACLE encryption
Hi,
We have tried this way of connecting as
Hi all
I have this script that keeps bugging me with an Oracle error ORA-00942
that should not be there. All the tables in the script are owned by
'DBREPORTER' who is running the script. I have executed the same SQL
commands directly with SQLPlus and they work fine. Even more, the same SQL
Notice too that in Jeff's example he used the q() construct which is
fine too when using placeholders since no variables need to be
interpolated.
Mark Galbraith [EMAIL PROTECTED] 03/11/04 06:00PM
Jeff Zucker mailto:[EMAIL PROTECTED] wrote:
Your quote marks were messing you up and the easiest
Hey Marc,
Try putting a $sth1-finish(); before you do the next do statement. See
your code below, I marked it with *** Try that and see if it helps.
Thanks,
Sam Gold
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, March 12, 2004 7:10 AM
To: [EMAIL
I did that but it did not help. The same error still pops up. Any ideas
anybody?
Regards,
Marc Torres Alvarez
Hey Marc,
Try putting a $sth1-finish(); before you do the next do statement. See
your code below, I marked it with *** Try that and see if it helps.
Thanks,
Sam Gold
I have this script that keeps bugging me with an Oracle error ORA-00942 that
should not be there. All the tables in the script are owned by 'DBREPORTER'
who is running the script. I have executed the same SQL commands directly
with SQLPlus and they work fine. Even more, the same SQL commands
Problem solved. :-)
Samuel pointed out the cause of the error - it was connecting to one
database when it should have been connecting to the other one.
Thanks everybody and especially to Sam.
Marc Torres Alvarez
Hi,
I am facing some problem related to a
Oracle Tool called "oracletool" available @ www.oracletool.com
Below are the details:
I am using: Windows 2000
ProfessionalActiveState Perl
5.6.1Apache 1.3.22DBI 1.34 DBD-Oracle 1.12 Oracle Enterprise
Edition 9.2
All are successfully
Good Morning,
Please forgive if this is considered off topic, I thought it would be the best place
to start.
I think I have a very simple question, I have a perl hash in which all the keys are my
tables field names and the values are the values that I wish to insert into my table.
Is there is
From the Message below and reading the Changes in DBD::Oracle, you will find
that ora_session_mode was added in DBD::Oracle 1.13. You need a newer
version.
Regards,
Jeff
-Original Message-
From: Harsh Agrawal [mailto:[EMAIL PROTECTED]
Sent: Friday, March 12, 2004 8:41 AM
To:
Title: Message
I installed DBD-Oracle from http://ppm.activestate.com/PPMPackages/
Any idea from where I can get 1.13 version containing PPD file.
From: Jeff Urlwin
[mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 4:44
PMTo: Harsh Agrawal; [EMAIL PROTECTED]Subject: RE:
Problem
I'm only familiar with the build the SQL method, but if there's an
alternate method it would be described in the excellent DBI perldocs,
which you can access by doing
perldoc DBI
at a command prompt.
HTH.
Hardy Merrill
Chris Faust [EMAIL PROTECTED] 03/12/04 09:33AM
Good Morning,
Please
Hello dbi-users,
I am a very happy user of DBI and DBD::Oracle.
And some days I am using the new Handling of LOBs in DBD::Oracle.
IMHO there is a mistake in the documentation.
I am using Oracle 8i. Not shure about 9 or 10g.
I am running on Windows, but should be the same on Unix.
In
Hai Friends,
I would like to write a test script for testcases. I got some information thru google
that about Test::Harness module. But i did'nt get complete information to write
testscript for project module. If anybody known or experienced people. Please guide
me...
Thanks
Mahi G
Hai Friends,
I would like to write a test script for testcases. I got some information thru google
that's about Test::Harness module. But, i did'nt get complete information to write
testscript for my project module. If anybody can please guide me...
Thanks
Mahi G
No, but if you upgrade your perl to the latest, you can get them from my
site ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DBI.ppd and DBD-Oracle.ppd
Jeff
-Original Message-
From: Harsh Agrawal [mailto:[EMAIL PROTECTED]
Sent: Friday, March 12, 2004 9:54 AM
To: Jeff Urlwin; [EMAIL
Hi,
I'm trying to get DBD::Oracle to compile using
AIX 5.1
Oracle 8.1.7.4
gcc 2.9-aix51-020209
perl v5.8.3
DBI 1.41
I compiled this perl and DBI with gcc just fine. Other CPAN modules
compile OK with gcc. We don't have xlc or cc compilers; is this even
possible?
I've tried setting the
Hi,
We installed perl 5.8 DBI DBD using the same platform u mentioned.
AIX 5.2
Oracle 9.2.0.2
perl v5.8.3
DBI 1.41
DBD-Oracle 1.15
But we never succeeded using gcc.
Try to install everything (perl DBI DBD ) using xlc_r. You can find
xlc_r trial versions...then u can buy the original if
21 matches
Mail list logo