Oracle 8.1.7 will indeed install cleanly on RH 7.1. You can make your
glibc libraries compatible. I'm not sure if you need all of these, but I
just checked my installation directory and it appears that I installed the
following RPMs:
compat-binutils-5.2-2.9.1.0.23.1.src.rpm
You don't need to install everything to use Oracle Client for Linux.
Unfortunately, unlike Windows editions, the Client installation comes as
part of the Enterprise Software package. When you launch the installer, you
are asked whether you want to perform a client or Enterprise install. Choose
From: Mike Brodbelt [mailto:[EMAIL PROTECTED]]
oci8.c: In function `oci_hdtype_name':
oci8.c:100: `OCI_HTYPE_SUBSCRIPTION' undeclared (first use this
function)
oci8.c:100: (Each undeclared identifier is reported only once
oci8.c:100: for each function it appears in.)
oci8.c:109:
Kevin,
Your error is 'table or view does not exist'.
Did you connect as the same Oracle user in SQL*Plus and perl ?
Mark
Kevin Bass wrote:
Please post your entire statement:
my $sth = $dbh-prepare(qq(SELECT fuser.us_initl, . . .
Thanks
- Original Message -
From: Michael
Hello,
I'm sorry to be slightly off topic but how can u access table of
other user? (mean, the syntax)
I made 'user1' and 'user2'. user1 is the owner of table1.
the 'system' granted 'connect' role to user2, and user1 granted
select on table1 to user2.
When user2 tries 'select * from table1',
SELECT * FROM table1
where connected as user2. That should produce exactly the same result.
Cheers,
Christian Sage
-Ursprüngliche Nachricht-
Von: M. Jang [mailto:[EMAIL PROTECTED]]
Gesendet am: Dienstag, 18. September 2001 18:16
An: [EMAIL PROTECTED]
Betreff: Re: Oracle prepare failed
are the usernames used in dbi the same as in sqlplus?
Since it is a ORA-00942 error, it is possible that
1. the user connected through dbi does not own the table
2. there is no synonym created for the dbi user so that tables have to be
qualified as
schema.table_name
3. there is no select
No, they weren't. However, the username does have select any table
privileges granted to him. I just logged into sqlplus with the same
username that is in the DBI script and it did indeed work just fine via
sqlplus. I'm at a loss.?
At 04:04 PM 09/17/2001, Dong Wang wrote:
are the
Please post your entire statement:
my $sth = $dbh-prepare(qq(SELECT fuser.us_initl, . . .
Thanks
- Original Message -
From: Michael Ragsdale [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 17, 2001 3:00 PM
Subject: Oracle prepare failed?
I have a query that works
If you are on NT, try downloading the definitive pre-built Perl for NT:
ActivePerl
http://aspn.activestate.com/ASPN/Downloads/ActivePerl/
It may or may not already have DBI. I think it does, but if not, no
problem. Just use ppm (perl package manager) for installing DBI and
DBD::Oracle. The
Try to add to apache config something like that:
SetEnv ORACLE_HOME /path/to/your/oracle/home
That way You surely have the environment variable set for Your CGI script.
It helped in my case.
Reg's
Oleg
-Original Message-
From: eddie iannuccelli [mailto:[EMAIL PROTECTED]]
Sent:
THAT' S IT
thank you very much :
Do you think the dbish pb is linked to that ?
Best regards
---
I don't understand what happen since the script work fine under apache
user session, nobody user session and root user session (httpd
Yes but in which file (httpd.conf or .cshrc or else ?)
thanks
Oleg Mechtcheriakov wrote:
Try to add to apache config something like that:
SetEnv ORACLE_HOME /path/to/your/oracle/home
That way You surely have the environment variable set for Your CGI script.
It helped in my case.
In httpd.conf
Reg's
Oleg
-Original Message-
From: eddie iannuccelli [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 06, 2001 4:28 PM
To: Oleg Mechtcheriakov
Cc: [EMAIL PROTECTED]
Subject: Re: Oracle DBI connection working in command line but not in
CGI
Yes but in which
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
On Fri, Aug 31, 2001 at 03:02:47PM -0700, Wilson, Doug wrote:
oci8.c: In function `oci_hdtype_name':
oci8.c:100: `OCI_HTYPE_SUBSCRIPTION' undeclared (first use
in this function)
oci8.c:100: (Each undeclared identifier is reported only
*** Error exit code 1
Stop.
Regards
John
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 7:26 PM
To: Penaluna, John
Cc: 'Tim Bunce'; '[EMAIL PROTECTED]'
Subject: Re: Oracle DBD Make failing on HPUX 11
On Fri, Aug 31, 2001 at 12:07:05PM +1000
Can you please start debugging it, fix the problem, and send me a patch?
Thanks for your time.
Tim.
On Fri, Aug 31, 2001 at 01:27:18PM -0400, Tim Callaghan wrote:
Tim,
Can you please let me know why DBD:Oracle will not run on an Oracle 8.1.6
client machine?
By default, 8.1.6 does not
You should use the ppm utility to install modules.
In command prompt:
ppm install DBD::Oracle
or
ppm install DBD::Oracle8
This will install precompiled binaries.
If you want to compile yourself through nmake, you must have Visual C++
compiler installed on your system as well as the Oracle
On Fri, Aug 31, 2001 at 12:07:05PM +1000, Penaluna, John wrote:
Upgraded to DBD:Oracle 1.09 but still getting the same problem.
Post the log.
Tim.
Dan,
This is exactly the solution to all our SQLLoader problems that I was
trying to force into minds of our DB people during the last 2 months
since we first discovered the bug. Unfortunately, I am only responsible
for the client part of the project and they did not agree with me. Now I
am
-Original Message-
From: Wilson, Doug [mailto:[EMAIL PROTECTED]]
Here's the output of 'perl Makefile.PL' and 'make'
(shall I see what happens if I do 'perl Makefile.PL -no8' ??):
Uhh, I meant 'perl Makefile.PL -8', and it passed the
make test that way. Just wondering if that was
Uhh, I meant 'perl Makefile.PL -8', and it passed the
make test that way. Just wondering if that was the right
thing to do...
I should read the instructions more often, but then I wouldn't
have so much fun figuring things out :)
From the README:
The new enhanced Oracle 8 OCI is now
Try DBD::Oracle 1.09.
Tim.
On Thu, Aug 30, 2001 at 11:29:55AM +1000, Penaluna, John wrote:
I'm attempting to install the Oracle DBI module on a 64 bit HPUX 11.00
machine however it all falls over when I do the 'make'. It fails due to not
finding library nbeq. I've installed Oracle 8.1.7
Upgraded to DBD:Oracle 1.09 but still getting the same problem.
John
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 11:44 PM
To: Penaluna, John
Cc: '[EMAIL PROTECTED]'
Subject: Re: Oracle DBI Make failing on HPUX 11
Try DBD::Oracle 1.09
Shouldn't be any problems. Every problem that ever showed up on this list
was easily resolved and was not due to incompatibility. What problem(s) are
you having?
Ilya
-Original Message-
From: James Wai
To: [EMAIL PROTECTED]
Sent: 08/27/2001 2:13 PM
Subject: oracle 9.0.1
Hi All,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, Aug 27, 2001 at 02:13:20PM -0600, James Wai wrote:
Anyone has any success / experience with Oracle 9.0.1
with DBI 1.19 and DBD-Oracle-1.08? Or is this going
to work at all?
Other than issues with getting Oracle to relink on [insert Linux
It seems that I am having problem with mixing of 64 bit links and 32 bit
links.
I think Oracle 9.0.1 comes only with 64 bit. So should my question be:
how do
I compile a 64 bit perl?
Thanks,
James
Sterin, Ilya wrote:
Shouldn't be any problems. Every problem that ever showed up on this
BTW: is that a typo? ORALCE_HOME vs ORACLE_HOME
-Original Message-
From: Kawai,Takanori [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 24, 2001 6:57 PM
To: Maruti Chavan; [EMAIL PROTECTED]
Subject: Re: Oracle Perl and DBI , dbd problem while inserting report in
Japanese
Hi.
#If you
Hi.
#If you can read Japanese, I can send you in Japanese :-)
#It is not easy for me to write mail in my poor English.
- Original Message -
From: "Maruti Chavan" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 23, 2001 7:59 PM
Subject: Oracle Perl and DBI , dbd problem
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, Aug 17, 2001 at 03:00:27PM -0400, Jeff Besecker wrote:
I have installed Oracle 9i on a RH 7.1 server. I have done a database
install to make sure I got all of the required files. I can connect to a
remote database using sqlplus. I
:-) And it is really
the Oracle instance on the remote host as can be seen from version
numbers...
Reg's
Oleg
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 5:40 PM
To: Oleg Mechtcheriakov
Cc: [EMAIL PROTECTED]
Subject: Re: Oracle 8.1.5 + Solaris
on the remote host as can be seen from version
numbers...
Reg's
Oleg
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 5:40 PM
To: Oleg Mechtcheriakov
Cc: [EMAIL PROTECTED]
Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD
Nop,
same picture... :-(
Oleg
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 12:50 PM
To: Oleg Mechtcheriakov
Cc: 'Tim Bunce'; [EMAIL PROTECTED]
Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
Given what someone
numbers...
Reg's
Oleg
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 5:40 PM
To: Oleg Mechtcheriakov
Cc: [EMAIL PROTECTED]
Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
On Thu, Aug 16, 2001 at 03:41
PROTECTED]
Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
You'll have to try building one of the oci demo programs in
$ORACLE_HOME/rdbms/demo and see if that connects okay.
Tim.
On Fri, Aug 17, 2001 at 09:25:19AM +0200, Oleg Mechtcheriakov wrote:
Hi,
thanks
it.
Tim.
Reg's
Oleg
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 1:26 PM
To: Oleg Mechtcheriakov
Cc: 'Tim Bunce'; [EMAIL PROTECTED]
Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
You'll have to try building
On Thu, Aug 16, 2001 at 03:41:06PM +0200, Oleg Mechtcheriakov wrote:
The point is that connection from perl script failes whereas the connection
with SQLPLUS works OK.
With what command line, exactly?
P.S. Forgot to say that to get to that point we had to recompile Perl and
DBI/DBD
'col' is a SQL*Plus command to format SQL columns and headers,
you will probably get a syntax error when you execute it with DBD::Oracle.
I would probably simplify the SQL statement to use it with Perl/DBI.
I sort of detest those long ugly SQL statments that just format data
(ok for SQL*Plus,
I *don't* have experience with this on Windows, but I assume
you can still use sqlplus - can you connect to the database
using sqlplus? If you can connect to the database using sqlplus
then that proves that the Oracle networking files are set up
correctly - if not, then attend to that(setting up
On Tue, Jul 24, 2001 at 01:44:12AM -0500, Stevenson, Jonathan wrote:
There is a problem with DBD::Oracle 1.07 coneecting to Oracle 7. I
sorted this issue with reference to an old post, but then just got
another one, about missing symbols on the make perl step of a static
build, so you might
On Mon, Aug 06, 2001 at 10:10:02PM +0100, Tim Bunce wrote:
On Tue, Jul 24, 2001 at 01:44:12AM -0500, Stevenson, Jonathan wrote:
There is a problem with DBD::Oracle 1.07 coneecting to Oracle 7. I
sorted this issue with reference to an old post, but then just got
another one, about missing
Am 6 Aug 2001, um 22:10 hat Tim Bunce geschrieben:
On Tue, Jul 24, 2001 at 01:44:12AM -0500, Stevenson, Jonathan wrote:
There is a problem with DBD::Oracle 1.07 coneecting to Oracle 7. I
sorted this issue with reference to an old post, but then just got
another one, about missing symbols
And what role does DBI play in this? Please refer your question to the
appropriate list where this would be on topic.
Ilya
-Original Message-
From: Antonio Martinez Rodriguez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 8:48 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL
Correct me if I am wrong, but I don't believe you can. I believe that's an
Oracle (not DBD::Oracle) limitation.
You will probably have to do an insert and an update.
Ilya
-Original Message-
From: Christian Gruber [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 7:50 AM
Guess it wasn't the limitation. I believe I read about it somewhere, but
then I might be mistaken.
Ilya
-Original Message-
From: Christian Gruber [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 8:21 AM
To: Sterin, Ilya
Subject: RE: Oracle BLOB problem
Sterin, Ilya
On Wed, Jul 11, 2001 at 01:49:35PM +0200, Christian Gruber wrote:
Here the problem: I can't perform an insert statement that has more
than one BLOB. I use bind_param(, {ora_type=ORA_BLOB}) to bind
the parameters, which works fine for one single BLOB. But when the
insert statement
Why not do something like this?
my $sql =E_SQL_E;
INSERT INTO Table
(target_id, blob1,blob2)
VALUES
(target_id_seq.nextval, ?,?)
E_SQL_E
my $sth = $dbh-prepare($sql) or confess $DBI::errstr;;
$sth-bind_param(1, $blob1, { ora_type = ORA_BLOB, ora_field='blob1'});
I dont know much about Oracle Discoverer but if you can access these
reports via standard OCI calls you could use Tim B's DBD::Oracle and submit
the OCI calls directly.
- j
-
James Diggans
Bioinformatics Programmer
Gene Logic, Inc.
Phone:
To: dbi-users
Subject: Re: Oracle, perl DBI under debian
Thanks Ilya but to put it simpler:
Where can I find those Oracle client libs?
Ciao
Vittorio
Sterin, Ilya [02/07/01 09:34 -0600]:
-Original Message-
From: Vittorio
To: [EMAIL PROTECTED
- Original Message -
From: Victor [EMAIL PROTECTED]
To: Sterin, Ilya [EMAIL PROTECTED]
Cc: dbi-users [EMAIL PROTECTED]
Sent: Sunday, July 08, 2001 2:25 PM
Subject: Re: Oracle, perl DBI under debian
(...)
Knowing that at office I have Oracle 8 servers under win NT, a
database I'd
Oops i forgot that you have debian.
So discard the remarks about Windows and Visual Studio..
-
From: Vittorio De Martino [mailto:[EMAIL PROTECTED]]On Behalf Of Victor
Sent: Wednesday, July 04, 2001 6:36 AM
To: dbi-users
Subject: Re: Oracle, perl DBI under debian
Thanks Michael!
No, I'm running perl and DBI under a debian linux laptop but I think
that I'll need the SQL*Net all
to the appropriate mail list. **
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
- Original Message -
From: Victor [EMAIL PROTECTED]
To: dbi-users [EMAIL PROTECTED]
Sent: Thursday, July 05, 2001 04:15
Subject: Re: Oracle, perl DBI under debian
What's
:15 AM
To: dbi-users
Subject: Re: Oracle, perl DBI under debian
Thanks Ilya, but
What's ActiveState and whatis it for?
Vittorio
Sterin, Ilya [dbi-users] 04/07/01 13:28 -0400:
Right and you will have to install the Oracle client to to be able to
compile DBD::Oracle, unless you
Subject: Re: Oracle, perl DBI under debian
Thanks Michael!
No, I'm running perl and DBI under a debian linux laptop but I think
that I'll need the SQL*Net all the same.
Ciao
Vittorio
Michael A. Chase [dbi-users] 03/07/01 08:05 -0700:
If you plan to run under WinNT, you should
private questions to the appropriate mail list. **
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
- Original Message -
From: Vittorio [EMAIL PROTECTED]
To: dbi-users [EMAIL PROTECTED]
Sent: Monday, July 02, 2001 16:53
Subject: Re: Oracle, perl
Thanks Ilya but to put it simpler:
Where can I find those Oracle client libs?
Ciao
Vittorio
Sterin, Ilya [02/07/01 09:34 -0600]:
-Original Message-
From: Vittorio
To: [EMAIL PROTECTED]
Sent: 07/02/2001 11:28 AM
Subject: Re: Oracle, perl DBI under debian
Victor [02/07
Chris,
I usually get this when my database is not running. Or if the listener is
down. Check your host and sid, make sure the listener is up.
Regards,
Drew
-Original Message-
From: Chris Saunders [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 11:50 AM
To: [EMAIL PROTECTED]
, Andrew Mr RAYTHEON 5 SIG CMD [EMAIL PROTECTED] on
25/06/2001 12:10 ZE2
To: Chris Saunders/DMGIT/DMG UK/DeuBa@DMG UK; [EMAIL PROTECTED]
cc:
Subject: RE: Oracle
Chris,
I usually get this when my database is not running. Or if the listener is
down. Check your host and sid, make sure
It needs at least the Oracle SQL*Net software to connect to remote hosts.
To build, it also needs either Oracle's Pro*C or OCI.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll
Say you have an Oracle DB installed and running on Machine A.
To use DBI with the database you need the DBD::Oracle module installed on a
machine where you also have the Oracle client libraries, etc. installed,
either Machine A itself, or another machine, Machine B.
If you want to run the Perl
DBD::Oracle inserts null if the value of the bind parameter is undef.
Therefore if you have a scalar which is undef it will insert as null, other
time when it has a value it will insert the actual value. You must use
placeholders though. See docs.
Ilya
-Original Message-
From: Edd
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
Hi
Check the TNSNAMES.ORA file on each machine.
They shoud only differ on the IP address
From: Jones Robert Contr 81 CS/SCK [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Oracle DBI on Windows NT
Date: Wed, 23 May 2001 16:04:05 -0500
We have Oracle version 8 loaded on Windows NT boxes.
Figured it out ... It has to do with the registry ...
It wants ORACLE_HOME defined in HKLM\SOFTWARE\ORACLE, which it currently was
not on one machine but was on another.
For those offering other suggestions, thank you for your time.
-Original Message-
On Wed, 23 May 2001, Jones
Downgrade to DBI 1.14 and recompile DBD::Oracle. It's a know bug.
Ilya Sterin
-Original Message-
From: Tim Scott [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 7:59 AM
To: DBI Users
Subject: DBD::Oracle on Solaris8 / Oracle 8.1.6
Hi,
I'm having troubles with the plsql.t
Hi,
you need an account for the other system/user.
Darrell
On Wed, 23 May 2001, Jones 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
Date sent: Mon, 14 May 2001 23:54:49 +0200
To: [EMAIL PROTECTED]
From: Nico van Leeuwen [EMAIL PROTECTED]
Subject:Oracle SELECTS (again)
Nico,
I have no experience with Oracle, but
...
#!/usr/bin/perl -w
use strict;
use
Nico,
try the select w/o the where clause. Purpose: ruling out problems with
trailing blanks (what was the datatype of login?).
If that does not return a row then you might try a fetchrow_arrayref()
or fetchrow_hashref(). Sometimes the fetchrow_array() doesn't work for
me.
Frank.
Nico van
At 11:54 PM +0200 5/14/01, Nico van Leeuwen wrote:
Good evening,
I have been struggeling with oracle selects all day am getting some strange
results.
I can't seem to find out what is wrong with the following script:
#!/usr/bin/perl -w
use strict;
use DBI;
# Connect to the database
my $dbh =
You really need error checking. I suggest you add { RaiseError = 1 } after
the password in the connect() call.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an
Looks like your query is returning zero rows. Have you tested it with
the same username and password from sqlplus?
Chip
Nico van Leeuwen [EMAIL PROTECTED] writes:
new script different style
#!/usr/bin/perl -w
use strict;
use DBI;
my $dbh = DBI-connect(
derardo,
This might be the same issue we ran into just this week.
According to Oracle Support, this is Bug 1397603, which is supposed to be
fixed in 8.1.7.2, which isn't out yet, of course.
Try the following workaround:
correct me if i'm wrong here, but won't this only affect things on
Subject:Oracle CLOBs through DBI through CGI.pm don't work?
To: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Date sent: Wed, 9 May 2001 18:36:12 -0400
jc,
your environment is far beyond my experience, but
DBI v1.14,
I had the same problem running the following version.
# perl -v
This is perl, version 5.005_03 built for sun4-solaris
Solaris 2.6
Thu Jan 13 17:22:49 2000: Module the DBI manpage
o
have done this before and have no problems. I will
send you the snippet tomorrow if you want.
you have to do:
use DBD:Oracle(:ora_types);
and then say which column is the CLOB.
I don't have the syntax in front of me. But will send
it off list tomorrow if someone else doesn't answer.
Job
---
'?' placeholders get converted into ':1' style placeholders inside
DBD::Oracle, so there should be no reason that they wouldn't work. The
examples in DBD-Oracle-1.06/Oracle.ex/ use named placeholders like ':value'
because they are easier to keep straight, but they are not required.
The
for an age.
- Original Message -
From: Sterin, Ilya [EMAIL PROTECTED]
To: 'Fox, Michael ' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, May 01, 2001 6:40 AM
Subject: RE: Oracle behaviour when inserting strings containing only blanks
I wonder if because of it binding as as string
, embedded \0 okay
Ilya Sterin
-Original Message-
From: Michael A. Chase
To: Sterin, Ilya; 'Fox, Michael '; [EMAIL PROTECTED]
Sent: 05/01/2001 8:38 AM
Subject: Re: Oracle behaviour when inserting strings containing only blanks
What's needed is a documentation patch. Attribute ora_ph_type
PROTECTED]
Sent: Tuesday, May 01, 2001 8:16 AM
Subject: RE: Oracle behaviour when inserting strings containing only blanks
Right, but shouldn't
ora_ph_type = 5 which Michael used too, should behave same as
ora_ph_type = 96 and not strip the trailing spaces, at leaset that is
what
is mentioned
In Michaels case he used ora_ph_type=5 and it seemed as if it trimmed the
space??? Any other experience with STRING type?
Thanks.
Ilya Sterin
-Original Message-
From: Michael A. Chase
To: Sterin, Ilya; ''Fox, Michael ' '; [EMAIL PROTECTED]
Sent: 05/01/2001 10:06 AM
Subject: Re: Oracle
]]
Sent: Wednesday, May 02, 2001 10:38 AM
To: ''Fox, Michael ' '; [EMAIL PROTECTED]
Subject: RE: Oracle behaviour when inserting strings containing only
blanks
Guess you gotta use ' \0' if you use ora_ph_type = 5
Try it, let us know.
Ilya Sterin
-Original Message-
From: Michael A. Chase
A.
With sufficient flattery (see Notebooks of Lazarus Long) Tim or some one
else would probably be glad to add them.
You might also look at Oracle-OCI for more direct access to OCI from Perl.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a
Perl is so good at dealing with text that there's no need for a
separate loader utility. You parse the text via standard Perl or
a package for specific formats (e.g., Text::CSV_XS is a good one
for CSV files). Once parsed, you use DBI to insert or update
database rows.
Steve Sapovits
Hi,
Does the DIRECT load option activate triggers during insert?
Simon
-Original Message-
From: Lars Eskildsen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 9:56 AM
To: 'Randy Norwood'; 'DBI Users'
Subject: RE: Oracle sqlload alternatives?
Hi'
SQLLOAD is an Oracle
At 10:07 -0400 26/4/01, Simon Fan wrote:
Does the DIRECT load option activate triggers during insert?
No. And it only checks integrity constraints after the load.
Regards
Paul Miller
--
-
Carib Data Limited
mailto:[EMAIL PROTECTED]
http://www.caribdata.co.uk
Hi there,
I've tried the various suggestions that people have made and so far no good
(thanks a lot for the help though). Seting NLS_LANG in $ENV makes no
difference whatsoever.
One thing I've noticed is that character 0x9C ( the Windows 1252 oe
ligature ) is mapped to a pound sterling
Andy,
I'm not familiar with Code Page 1252, but if it's a standard Latin-1 encoding,
you should set your NLS_LANG environment variable to 'WE8ISO8859P1' before
connecting to Oracle. Everything should work fine then.
Hope this helps,
Mark
Andy Brick wrote:
Hi all,
I'm using DBD:Oracle and
WE8ISO8859P1 is wrong. It is UNIX coding standard ISO-8859-1.
You must use MS Windows Code Page 1252 8-bit West European WE8MSWIN1252
instead.
MaT
-Original Message-
From: Andy Brick [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 11:16 AM
To: [EMAIL PROTECTED]
Subject: Oracle
Setting NLS_LANG to WE8ISO8859P1 or WE8MSWIN1252 stops me establishing a
connection - DBI reports a login failure.
Setting NLS_LANG to ENGLISH.WE8MSWIN1252 allows a login but does not solve
the character set issue.
Help !!
Regards
Andy Brick
[EMAIL PROTECTED]
Andy,
Let's first check if our assumptions are correct. Can you do a
SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER='NLS_CHARACTERSET';
This will give us the characterset used to create the database.
Please let me know the version and platform of your database, also.
Then try with
- Original Message -
From: Andy Brick [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 24, 2001 12:13 PM
Subject: Re: Oracle Character Set problem
Setting NLS_LANG to WE8ISO8859P1 or WE8MSWIN1252 stops me establishing a
connection - DBI reports a login failure.
Setting
Thanks for the response.
I have reinstalled Oracle Client Libraries(8.1.7) and reinstalled perl
and it appears to be working. Probably I was missing some
header/includes w/ my old client libraries(8.1.5).
I will let you know if i found anything new.
Sterin, Ilya wrote:
Also this message
Also this message does not belong on dbi-dev. Please make sure you post to
correct group for each question. This pertains to dbi lists and any other
lists out there.
Ilya Sterin
-Original Message-
From: Raj Srinivasan [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 7:14 PM
To:
What's the error. It's hard to tell without an error message. Use trace()
at level 2 if you haven't yet.
Ilya Sterin
-Original Message-
From: Raj Srinivasan [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 7:14 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: DBD:Oracle -
On Mon, Apr 16, 2001 at 07:44:57PM -0400, Sterin, Ilya wrote:
I am afraid that's wrong, the arrow - is resolved in the string context
since it's the same as dereferencing the object in the string context. The
problem is that the user which is executing the script does not have the
For one thing, your ORACLE_HOME path isn't what you think.
'\' is the escape character. To use it in a string as a
literal, you need to use two:
$ENV{ORACLE_HOME}="c:\\orant";
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001
Still need to connect to Oracle via web to get raw sql select
output into browser. All ideas welcome !
Thanks Sapovits. I changed to c:\\ (for correctness sake) but
this fixes nothing it doesn't seem to address the problem
(but is appreciated). I continue to get correct output ( with c:\
PROTECTED]
Subject: Re: Oracle-DBI-Win2k-Apache-want raw sql select output to
browser
Still need to connect to Oracle via web to get raw sql select
output into browser. All ideas welcome !
Thanks Sapovits. I changed to c:\\ (for correctness sake) but
this fixes nothing it doesn't seem
)~0x1b670ec)
dbd_st_fetch 1 fields, rpc 217 (cache: 11/206/309)
dbd_st_fetch 1 fields, rpc 217 (cache: 62/155/309)
- fetchrow= ( '100219' ) [1 items] at oracle-perl5.pl line 45.
- fetchrow for DBD::Oracle::st (DBI::st=HASH(0x1ec2104)~0x1b670ec)
***
Subj: RE: Oracle-DBI
601 - 700 of 723 matches
Mail list logo