Does the latest version of DBI/DBD::Oracle support it? I didn't see a
support version table anywhere.
Robert
Andy Hassall wrote:
Robert Hicks wrote:
Does the latest version of DBI/DBD::Oracle support it? I didn't see a
support version table anywhere.
I posted something on this to the dev list, see link below, basically it
works but there's a couple of minor issues:
http://www.mail-archive.com
Dean Arnold wrote:
(Those who abhor javadocs should discard this message immediately...)
I've been building some tools for fancier Perl project documentation.
One piece is a javadoc-ish formatter using special POD tags.
In order to exersize it thoroughly, I've hacked a version of DBI
to move
Tim Bunce wrote:
On Tue, Aug 14, 2007 at 07:01:23PM -0400, Robert Hicks wrote:
Tim Bunce wrote:
Setting ShowErrorStatement is unrelated to or die... so the question
seems flawed.
ShowErrorStatement just adds information to the message produced by
RaiseError and PrintError.
I recommend
Tim Bunce wrote:
On Tue, Aug 14, 2007 at 11:17:26AM +1000, Stuart Cooper wrote:
First off, I had no idea it existed until I started going through a dbi
tutorial. The idea is you don't have to litter your code with or
die... statements.
I recommend that everyone who doesn't carefully read the
Tim Bunce wrote:
On Tue, Aug 14, 2007 at 09:16:15AM -0400, Robert Hicks wrote:
Tim Bunce wrote:
On Tue, Aug 14, 2007 at 11:17:26AM +1000, Stuart Cooper wrote:
First off, I had no idea it existed until I started going through a dbi
tutorial. The idea is you don't have to litter your code
Tim Bunce wrote:
On Tue, Aug 14, 2007 at 09:16:15AM -0400, Robert Hicks wrote:
Tim Bunce wrote:
On Tue, Aug 14, 2007 at 11:17:26AM +1000, Stuart Cooper wrote:
First off, I had no idea it existed until I started going through a dbi
tutorial. The idea is you don't have to litter your code
First off, I had no idea it existed until I started going through a dbi
tutorial. The idea is you don't have to litter your code with or
die... statements.
Is it good practice to use this or is an explicit or die... better
because you can see there is error trapping?
Robert
Does anyone have such a beast for Oracle? I am trying to eliminate the
Perl/DBD::Oracle side of the equation for some problems in our app. I
did a looping select 20,000 times and the same for an insert.
I thought that someone might have a better script...
Robert
Loo, Peter # PHX wrote:
Hey Robert,
Are you going from Oracle to Oracle?
Peter
Yup...I am basically wanting to test against 1 particular Oracle db.
Robert
It probably doesn't matter. Right now I just have a script that does
inserts and selects. I control the database so I can do pretty much what
I need to do.
Loo, Peter # PHX wrote:
From a flat file?
Peter
-Original Message-
From: Robert Hicks [mailto:[EMAIL PROTECTED]
Sent
Garrett, Philip (MAN-Corporate) wrote:
Robert Hicks wrote:
Does anyone have such a beast for Oracle? I am trying to eliminate the
Perl/DBD::Oracle side of the equation for some problems in our app. I
did a looping select 20,000 times and the same for an insert.
I thought that someone might
We have a mixed C/Perl/XS application that we are moving to the Itanium.
After we compile everything and start it up after every SELECT statment
we are getting:
***glibc detected *** free(): invalid next size(fast): memory hex
given ***
Aborted
We are using:
HP rx2620 with Itanium
John Scoles wrote:
Itanium could be a 32/64 bit problem did you compiled all your code
useing 32 bit libs?
I believe so...I know the c code is.
Perl:
Summary of my perl5 (revision 5.0 version 6 subversion 2) configuration:
Platform:
osname=linux, osvers=2.6.9-55.el,
Paul DuBois wrote:
snip
Tim, thanks for clarifying.
I was wondering because it wasn't clear to me, in writing about DBI, how to
characterize what version of Perl a reader should have. I'll write that
5.6.0 is required but 5.6.1 is preferred.
What are you writing about DBI? ; )
Robert
Does DBD::Oracle have any problems with spatial tables and the like? We
are looking at using spatial for some nav computational stuff.
Robert
Once again:
I compiled Perl 5.6.2 using HP aC++/ANSI C:
cd perl-5.6.2
sh ./Configure -A prepend:libswanted='cl pthread ' -des
: No problems there
Then I export some Oracle stuff:
export SHLIB_PATH=$ORACLE_HOME/lib32
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
I run (as sudo):
perl
/usr/lib/hpux32/dld.so: Cannot dlopen load module
'/usr/lib/hpux32/libpthread.so.1' because it contains thread specific data.
Failed to load Oracle extension and/or shared libraries:
install_driver(Oracle) failed: Can't load
'/users/user/DBD-Oracle-1.17/blib/arch/auto/DBD/Oracle/Oracle.so' for
I am trying to install DBD::Oracle (yes I did read the README) on HP/UX
11.23 (itanium). I have DBI installed properly and I tested using
DBD::SQLite.
When I go to install the Oracle stuff I get this during a make test:
./usr/lib/hpux32/dld.so: Cannot dlopen load module
[EMAIL PROTECTED] wrote:
Note the libraries. perl is 64 bit whereas you are trying to load 32 bit
libraries.
I have built Oracle DBI on Itanium if you want further info
P
I would be much ablidged if you could share. : )
Robert
John Scoles wrote:
Looks like you are pointing to the 64 bit binarys.
You will have to use a 32 bit oracle client.
You best bet is to use the 32 bit instantclient for HP.
Set your ORACLE_HOME to the dir you install the 32 bit instant cleint
and the LD_LIBRARY_PATH to
[EMAIL PROTECTED] wrote:
The basic rule about building perl, DBD Oracle DBI on HP-UX (let alone
Itanium) using gcc is don't. Life is far far too short for it since you
will hit problem after problem. It is possible using HP's native C
compiler (in fact it is straight forwards) but if you are
[EMAIL PROTECTED] wrote:
Can you get hold of an HP ANSI C compiler?
p
Yes I can.
R
Samant Kumar wrote:
Hello,
I am trying to install DBD Oracle from a very long time now. I cannot use
PPM as the systems in my company are behind a proxy. I am a novice in both
Perl and Oracle so do not know a lot bout them. Many things which I searched
on the net went right over my head,
Chris Drake wrote:
Hi Philip Robert,
Thanks for those excellent references help offers. Do you (or
anyone) know whether or not I should even be *using* a shared server,
and have you any idea about how many dedicated connections is too
many on a dual-3.8ghz Xeon Linux PC with 8gigs or RAM
I have a couple forms for an in-house application. The user fills out
the fields and then submits which update a back end Oracle database.
I have looked for examples but can't really find anything.
How is it best to catch errors when doing DBI stuff in web applications?
Wrap the insert code
Message-
From: Robert Hicks [mailto:[EMAIL PROTECTED]
Sent: Friday, November 10, 2006 1:40 PM
To: dbi-users@perl.org
Subject: DBI in a web context
I have a couple forms for an in-house application. The user fills out
the fields and then submits which update a back end Oracle database.
I have
Peter J. Holzer wrote:
On 2006-10-18 10:19:24 -0400, Hardy Merrill wrote:
I think I get it yes. So here is what I am doing. Access has a date
field that I am pulling out and when I print the $start_date variable
it looks like this:
2006-09-15 00:00:00
That is a string now to Perl...correct?
Garrett, Philip (MAN-Corporate) wrote:
Robert Hicks wrote:
Hardy Merrill wrote:
Sorry for the top-post - Groupwise :-(
Notice how Philip suggested using to_char - *not* to_date.
You probably already know this, but on the chance you don't,
you use to_date if you have a string that contains
Any gotchas there? I am opening an Access db via ODBC and binding those
columns (including a date field) and passing that to the Oracle handle
to do inserts (i.e. Access - Oracle migration).
Robert
Garrett, Philip (MAN-Corporate) wrote:
Robert Hicks wrote:
Any gotchas there? I am opening an Access db via ODBC and binding
those columns (including a date field) and passing that to the Oracle
handle to do inserts (i.e. Access - Oracle migration).
Only gotcha is with formatting -- you'll
DBD::Oracle::db prepare failed: ORA-00980: synonym translation is no
longer valid (DBD ERROR: error
possibly near * indicator at char 129 in 'SELECT msf810.SURNAME,
msf810.FIRST_NAME, msf829.EMPLOYE
E_ID, msf829.PHYSICAL_LOC, NGXREFPHYL.DISTRICT_CODE FROM msf810, msf829,
*NGXREFPHYL WHERE
Michael Garfield Sørensen, CeDeT wrote:
The manual (Oracle9i Database Error Messages) says:
ORA-00980 synonym translation is no longer valid
Cause: The synonym used is based on a table, view, or synonym that no
longer exists.
Action: Replace the synonym with the name of the object it
Matthew Persico wrote:
http://www.cpan.org/modules/by-authors/id/TIMB/DBI_WhatsNewTalk_200607.pdf
Very nit picky, but is there a version of this that I can print
without killing all the black ink in my printer?
I always think that too but I just keep the PDF for reading. Save a tree
and all
Reidy, Ron wrote:
Not according to this:
http://ppm.activestate.com/BuildStatus/5.8.html
-Original Message-
From: Robert Hicks [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 11, 2006 1:04 PM
To: dbi-users@perl.org
Subject: Re: DBD-Oracle.ppd
If you are running ActiveState Perl DBD
John Scoles wrote:
Funny I do not get that. When I use PPM
Can you run the settings , Target and repository commands and show the
results to?
ppm settings
case-sensitivity: 0
download-chunksize: 16384
fields: name version abstract
follow-install: 1
force-install: 0
John Scoles wrote:
There is the difference I do not have the rep
[1] theoryx
can you do a rep describe on it for me?
That may be but I removed that rep before I did the search and it still
comes up. Plus the describe says it is coming from ActiveState but here
is the describe for it:
If you are running ActiveState Perl DBD::Oracle is in PPM now.
Robert
Peter J. Holzer wrote:
On 2006-05-01 14:07:02 -0400, Robert Hicks wrote:
It tried to connect with the scott/tiger thing on a lot of tests...and they
fail (of course).
You can tell the testsuite to use a different user by setting the
ORACLE_USERID environment variable. E.g.,
export
Alexander Foken wrote:
login as oracle user
execute - env | grep ORACLE_HOME
remember value
logout
login as root
execute - ORACLE_HOME=/whatever/you/saw/a/few/seconds/ago
execute - export ORACLE_HOME
execute - perl -MCPAN -e install 'DBD::Oracle'
Alexander
/10general.t 255 6528033 66
I just inherited a couple of HP servers that I now have to admin. My
'root' account does not have have ORACLE HOME set since we have an
ORACLE user that has that env variable set. The error is after my sig.
I tried it as ORACLE but it cannot write to the .cpan repository so it
errors out.
Alexander Foken wrote:
login as oracle user
execute - env | grep ORACLE_HOME
remember value
logout
login as root
execute - ORACLE_HOME=/whatever/you/saw/a/few/seconds/ago
execute - export ORACLE_HOME
execute - perl -MCPAN -e install 'DBD::Oracle'
Alexander
Thank you very much!
Robert
If I create a test script to connect to a Microsoft Access database that
is on a network (UNC) drive I can connect to it fine.
If I try to do the same thing from a web application running under
Apache I get the following error:
Error executing run mode 'display_task_page': Can't connect to
Tim Bunce wrote:
On Fri, Feb 10, 2006 at 02:50:11PM -0800, Bill Moseley wrote:
I'd like to see all of the prepared_cached() and execute() statements
when tracing. Currently that output is truncated.
How do I change where it truncates?
From memory it's $DBI::max_neatlen - but it is in the
Alexander Foken wrote:
snip
You could slowly migrate your system, a first step would be to make sure
all table and column names match /^[A-Za-z][A-Za-z0-9_]+$/. Next, move
the tables and the business logic to a real database. Then finally,
get rid of ODBC drivers and Access on the clients and
I am using the ODBC module to talk to an Access database. In that
database some of the column names have spaces in them (something like
EMPLOYEE NAME).
I have tried a bunch of stuff (backticking, brackets, braces, variables)
but I cannot seem to do a select on that table.
my $sth =
Alexander Foken wrote:
You need to pass the quotes to the SQL engine. And by the way, you
should either use parameters or the quote function for values:
my $sth=$dbh-prepare('select * from taskhours_per_date where employee
name=?');
$sth-execute('NAME HERE');
Maybe MS Acesss has other ways
Matthew Persico wrote:
On 1/27/06, Darren Duncan [EMAIL PROTECTED] wrote:
[snip]
Even if you can't move, its not like 5.8 is becoming a hard
dependency, rather just a soft dependency, as I recall.
The minute Tim writes a piece of code with a construct that is new to
5.8 because
a) its cool
Steven Lembark wrote:
-- Robert Hicks [EMAIL PROTECTED]
I have been handed a couple of requests to change some data. One is an
update on 3.6 million records and the other is two different deletions of
over 16 million rows of data. I need to be able to do these in batches as
I am told
mark d wrote:
On 1/18/06, Robert Hicks [EMAIL PROTECTED] wrote:
mark d wrote:
On 1/18/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
mark d [EMAIL PROTECTED] wrote:
This optimization might have made some sense decades over a serial line, but
not today. It is saving 320 single-packet
Andy Hassall wrote:
I have been handed a couple of requests to change some data. One is an
update on 3.6 million records and the other is two different
deletions of
over 16 million rows of data. I need to be able to do these
in batches as I
am told that Oracle will blow up if I do them in one
mark d wrote:
On 1/18/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
mark d [EMAIL PROTECTED] wrote:
This optimization might have made some sense decades over a serial line, but
not today. It is saving 320 single-packet round trips, which is an
infintesimal amount of traffic.
Well,
I have been handed a couple of requests to change some data. One is an
update on 3.6 million records and the other is two different deletions of
over 16 million rows of data. I need to be able to do these in batches as I
am told that Oracle will blow up if I do them in one shot.
I would like to
Owen [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Can any Windows user advise me if the module DBD::SQLite is available as
part of the windows packaging system with Perl for Windows.
If you mean something like ActiveStates PPM, then it is out there. I install
it whenever I install
Robert [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
When I use your version, everything is kosher. When I use the AS version,
I
get:
DBI connect('ellprd','ellipse',...) failed: ERROR
OCINlsEnvironmentVariableGet(OCI_NLS_CHARSET_ID) Check ORACLE_HOME and NLS
settings etc. at
55 matches
Mail list logo