==
====
Please help,
Daniel
--
Daniel Chmielewski
--
Daniel Chmielewski
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
Mobile: +46 (0)730-808025
From: Fennell, Brian mailto:fenne...@radial.com>>
Sent: Friday, May 28, 2021 03:11
To: Bruce Johnson
mailto:john...@pharmacy.arizona.edu>>; dbi users
mailto:dbi-users@perl.org>>
Subject: RE: Strange issu
or can easily be converted to and from (losslessly)
7-bit-ascii (such as EBCIDIC with some creativity).
And there is always good old hexadecimal.
It all depends on your use-cases, how much control you have over your
environment and how much time you can spend being clever.
--
Bruce Johnson
Uni
ported by oracle in
the error doesn’t match any of the values that I see in perl. I’m not sure this
is a DBI issue or not.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
_ADMIN Environment
variables and appropriate config file for the latter, then build DBD::Oracle in
CPAN. I've never had an issue doing it that way.
If you’re using JDBC I think all you need is the base client install.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology
process on a server still using the 18c client and the
> core dump does not happen. Our DBA is creating
> ticket with Oracle, but I wanted to see if anyone else has had the same issue.
I am not seeing this issue with the 19C instant client ( 19.6 ) running on
CentOS8, DBD::Oracle 1.80
:-)
On Jun 3, 2020, at 10:37 AM, Bruce Johnson
mailto:john...@pharmacy.arizona.edu>> wrote:
On Jun 2, 2020, at 12:30 PM, Andreas Mock
mailto:andreas.m...@web.de>> wrote:
Hi Bruce,
only some hints. It sounds to me like a shared object mess which may be
possible after upgrading.
It may
son that running it under
mod_perl would cause a problem with DBI, it doesn’t happen with any other
systems I’m running it on. I”m going to take this off to the mod_perl list, I
guess.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
To clarify the DBD::mysql module is present, is reachable via @INC and has a
‘driver’ method present.
On Jun 2, 2020, at 10:55 AM, Bruce Johnson
mailto:john...@pharmacy.arizona.edu>> wrote:
I’ve copied a working script from one server to another (upgrading a web
application serve
uot; or die
$DBI::errstr;
my $dbh = DBI->connect($dsn, $dbuser, $dbpass,{'RaiseError' => 1});
Pretty standard stuff. I'm not sure why this is happening. It is NOT the error
being reported...
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Insti
> On Feb 18, 2020, at 9:58 AM, Bruce Johnson
> wrote:
>
> Just a heads up for those of you on the close-to-the-bleeding-edge. libnsl is
> no longer included with the standard glibc libs with CentOS (and I'm guessing
> also in RHEL 8, and whatever the cu
yum install libnsl fixes it.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
minutes) without becoming unresponsive, even if they do return tens or hundreds
of thousands of rows.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
ONLY opened in the child process doing the
work and get closed properly.
With DBI in use you can use the variable DBI_TRACE to get extensive log. Google
for that in combination with mod_perl.
Just some hints.
Best regards
Andreas
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information
fic.
And clues as to where I should start to look?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
it, but all of the
perl modules I’ve installed from cpan are in the macports directory tree.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On 1/15/19, 2:59 PM, "Rajeev Jain"
mailto:jainr...
I’ve always just used the Bundle package and not had any problem:
https://metacpan.org/pod/Bundle::DBD::mysql
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On 1/15/19, 3:34 PM, "Daniël van
m,
We develop Perl applications connecting and working with Oracle database
(DBD:Oracle). So far it was
Oracle version 11. Now the database will be migrated to 12.2.0.1. How should
we deal with that? Any
answer would be appreciated.
Here is the canonical client compatibility guide for Oracle Databa
a symlink to it in
the expected directory and everything worked just fine.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
stant Client you have to install the Basic and the SDK packages. The
latter gets the developer header files and libs that DBD::Oracle uses to
compile the c code.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
ps TNS_ADMIN , ORACLE_BASE and
ORACLE_SID.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
other needed environment
vars to just $ORACLE_HOME.
The first step before trying to get DBI working is getting SQLPlus to work. Bet
the LD_LIBRARY_PATH fix above fixes that as well.
Don’t forget you also need to get the additional *Instant Client Package -
SDK", since that has the header files
> 10.2.0.3-1 installed
>
You know it’s vaguely coming back to me that I had to install several _devel
packages as well as the lib packages when I last set up a linux server.
You may need the libstdc++-devel.x86_64 package...
er.
Oracle won’t even let you install it as root as of 11.2 (at least, probably
much earlier but I went from 8.1.2 to 11.2 in one swell foop) .
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
> export LD_RUN_PATH=$ORACLE_HOME/lib
> export PATH=$PATH:$ORACLE_HOME/bin
I know I’ve gotten this error with Instant Client when the SDK component wasn’t
installed. I haven’t used the full client in years so I don’t know if the SDK
is automatica
default NLS_LANG thing, but I don’t think so.
A quick test would be to connect to the DB with hardcoded credentials in a test
perl script? This will determine whether it’s perl/DBI or encoding issues from
the config file.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
:/usr/bin:/root/bin:/usr/lib/oracle/12.1/client64/bin
TNS_ADMIN=/usr/lib/oracle/12.1/client64/admin
It worked, eventually, just wondering if others have run into the issue...
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions
The server is working fine though, I was just a bit puzzled. I”ll have to go
look back and see if I did install SQLPlus on the other systems. The problem is
I set up a new server just once in a blue moon, not all the time, and forget
all the bits and bobs I need.
--
Bruce Johnson
University of Ari
char == 30 bytes.
<http://www.dba-oracle.com/t_nls_lang.htm>
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
tried 'DESC', DESC and `DESC`. The last two fail at run-time. The
first one doesn't fail but it returns something like
PT_ID,DESC
PT_1,DESC
PT_2,DESC
...
PT_N,DESC.
I'm using the DBI module in Perl, would this be better with the other
modules mentioned?
--
Bruce
you get away with murder in naming
things...
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
environment issues?
Any reason you’re not installing DBD::Pg via cpan (as root) as well? I’ve found
that minimizes these kinds of things...
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
(‘select column from table where column = ?’); you’ll
get that error.
That’s the only way the ? would get past DBI, I’d think, which is what your
oracle error seems to be indicating.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do
On Jun 3, 2015, at 7:19 AM, William Bulley w...@umich.edu wrote:
According to Bruce Johnson john...@pharmacy.arizona.edu on Wed, 06/03/15
at 10:10:
Make sure your original $query is delimited by double quotes, not single.
I've tried _everything_!!
Single quotes. Double quotes
}
exit;
This is what it produces:
dbdev2:~ johnson$ perl test
? is ascii 63
' is ascii 39
is ascii 34
? is ascii 210
? is ascii 211
? is ascii 212
? is ascii 213
Note the displayed ‘?’’s….this is in my standard OSX terminal, which is a
VT-100 emulator using UTF-8 as the text encoding.
--
Bruce
about DB2, and less about Strawberry perl :-/ but I do know
a very common issue with is bitness mismatch in the database vendor drivers;
32-bit database driver vs 64-bit perl and vice versa, although there are
usually install time errors that will signal this.
--
Bruce Johnson
University
and Linux/x86_64),
changing LD_LIBRARY_PATH while a process is running has no effect. So
this:
On Feb 19, 2014 9:23 AM, Bruce Johnson john...@pharmacy.arizona.edu
wrote:
$ENV{ORACLE_HOME}=/usr/lib/oracle/11.2/client64;
$ENV{ORACLE_SID}=phmweb;
$ENV{LD_LIBRARY_PATH}=/usr/lib/oracle/11.2/client64
at /home/allwebfiles/perl/kfs/test.pl line 18
DB test: sysdate = Done testing connection
It appears that DBI is NOT inheriting the environment when it’s called via ‘use
DBI’ even though it’s called after I explicitly set them within the perl script.
--
Bruce Johnson
University of Arizona
On Feb 18, 2014, at 4:02 AM, Peter J. Holzer h...@wsr.ac.at wrote:
On 2014-02-17 22:43:58 +, Bruce Johnson wrote:
On Feb 17, 2014, at 2:48 PM, John D Groenveld jdg...@elvis.arl.psu.edu
wrote:
The OP shouldn't need to set a LD_LIBRARY_PATH so long as
he built DBD::Oracle
make sense, since the error refers to the line making
my db connection in the main script, and doesn’t correspond to an existing line
in the perl module, but I’ve run into oddball misdirections in perl error
statements in the past.
--
Bruce Johnson
University of Arizona
College of Pharmacy
= /root
SHELL = /bin/sh
SHLVL = 1
USER = root
_ = /home/allwebfiles/perl/kfs/showenvcron.pl
These are the correct values.
So what am I missing?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
to work through checking stuff since I only have about two
hours a day when I can actually run it :-)
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
install them in different
directories and ensure that the environmental variables are properly set prior
to running the perl code.
I never install the full Oracle client on anything any more.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do
On Jan 27, 2014, at 12:25 PM, Bruce Johnson john...@pharmacy.arizona.edu
wrote:
On Jan 27, 2014, at 12:04 PM, Alexander Foken alexan...@foken.de wrote:
I'm running 64 bit Windows and 64 bit Perl. Is it possible the DBD loader
is failing because it is trying to load a 32 bit version
revisit the issue.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
set up other Oracle related environment variables
require DBD::Oracle; # loads the XS part AFTER setting up the environment
Alexander
On 21.10.2013 23:36, Bruce Johnson wrote:
Nope, built and run with the same path, same install. I installed the
Instant Client Basic and Development
was right all along!
On Oct 20, 2013, at 5:53 AM, lesleyb lesl...@herlug.org.uk wrote:
Hi Bruce
On Fri, Oct 18, 2013 at 07:56:52PM +, Bruce Johnson wrote:
First thing I checked, and they're set correctly;
From %ENV on the broken system:
ORACLE_HOME -- /usr/lib/oracle/12.1/client64
On Oct 20, 2013, at 1:03 PM, Bruce Johnson john...@pharmacy.arizona.edu wrote:
Oh it turned out to be even simpler than that, and for once it wasn't MY fat
fingers that fat fingered it this time :-)
Cue the sad trombone, because I was wrong, again.
It turns out the issue seems to have
with that LD_LIBRARY_PATH?
And against that install?
Maybe Oracle.so is using LD_LIBRARY_PATH set at build time instead of
runtime?
Carl Furst
On 10/21/13 4:03 PM, Bruce Johnson john...@pharmacy.arizona.edu wrote:
On Oct 20, 2013, at 1:03 PM, Bruce Johnson john...@pharmacy.arizona.edu
-bit oracle db installed on the
system, but use the 64-bit Oracle Instant Client to compile DBD::Oracle. You
can run a 32-bit Oracle DB and use a 64-Bit oracle client on the same system,
you just need to know which set of libraries and ORACLE_HOME to look at.
--
Bruce Johnson
University
On Sep 23, 2013, at 2:02 PM, Bruce Johnson john...@pharmacy.arizona.edu wrote:
This can happen if you have 32-bit oracle db installed on the system, but use
the 64-bit Oracle Instant Client to compile DBD::Oracle.
Or Vice-versa, of course, which might be what your problem is.
--
Bruce
system is:
This is perl, v5.10.1 (*) built for x86_64-linux-thread-multi
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
the various files and such are where
they're expected to be.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
the lazy way out and created a Developer directory and symlinked /usr
into it. Worked fine, but going forward this is probably something to consider
in the installer.
--
Bruce Johnson
Wherever you go, there you are B. Banzai, PhD
on how to change this.
http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
-entry($n)-get_value('employeeTotalAnnualRate'));
All the columns allow null entries, and these are all single-valued entries in
the LDAP schema.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
in the execute(). It'd be more readable
that way anyway. Or if you must put them all one one line like this, add the
scalar() function on each argument.
On Wed, May 8, 2013 at 9:18 AM, Bruce Johnson john...@pharmacy.arizona.edu
wrote:
Getting the error:
DBD::Oracle::st execute failed: called
.
Mystery now solved.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
version of Apple'd development
tools that you have.
Or
Go to en entirely /opt/ centered setup using MacPorts (you'll likely need to
install the MacPorts perl as well.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely
line 204.
# at (eval 9) line 3
Is this because my perl is 64-bit and I'm using the 32-bit Oracle drivers?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
compiler and it worked also
had a full 64 bit client for Oracle as well.
Yeah, I had this working just fine in 10.6 with the 64-bit Instant Client.
Grrr. Wish oracle'd get off their butts and fix this. :-(
Thanks.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology
is:
host=oracle.host.dns.name;sid=SID
As I dimly recall we had to make that change at some point in the past to get
dbi working, if you're not using the standard port, you need to put that in
there too.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
On Jun 30, 2012, at 9:20 PM, Bruce Johnson wrote:
This code fragment:
After struggling with it for a bit (which included copying the offending code
from the non-working script, and pasting it into a test script with just that
bit...which worked)...I ended up pasting in the working code
parameter. DO I have to do $csr-close(); ?
or can I just do $csr-execute($param);
again?
--
Bruce Johnson
Wherever you go, there you are B. Banzai, PhD
with the param values plugged into the right
place...this is driving me mad...I'm supposed to be on vacation., [Belushi/]But
No![/Belushi] I have to debug code)
--
Bruce Johnson
Wherever you go, there you are B. Banzai, PhD
in the logged error. resource_id is created
via an 'on insert' trigger.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
D'OH!
Thanks!
On Jun 4, 2012, at 11:12 AM, Jeffrey Seger wrote:
$dbh-do() executes your sql. You are binding the parameter after this.
Use $dbh-prepare instead.
On Mon, Jun 4, 2012 at 2:01 PM, Bruce Johnson
john...@pharmacy.arizona.eduwrote:
I'm getting the following error:
[Mon
in the past when I've referenced
the wrong cursor)
--
Bruce Johnson
Wherever you go, there you are B. Banzai, PhD
=?' style.
Also, the line number in the error is from Oracle.pm, how do I find out what
line in my program caused this?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On Mar 29, 2012, at 1:46 PM, Bruce Johnson wrote:
Can't mix placeholder styles (:foo/?) at /usr/local/lib64/perl5/DBD/Oracle.pm
line 329., referer:
https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
Commenting out this section code gets rid of the error, so I know
;
$csr_res_pend-bind_param(':E',$res_affil) or die $DBI::errstr;
$csr_res_pend-bind_param_inout(:NEWID,\$new_res_id, 25) or die $DBI::errstr;
$csr_res_pend-execute();
Got right through.
Is this a bug or a rule I'm not aware of?
--
Bruce Johnson
University of Arizona
College of Pharmacy
){
$csr_allapp-execute($i) or die $DBI::errstr;
while (($k, $j) = $csr_prefapp-fetchrow()){$approvers{$k}=$j;}
}
}
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On Mar 29, 2012, at 2:45 PM, Bruce Johnson wrote:
another odd error:
Accidentally clipped off the actual error:
DBD::Oracle::st fetchrow failed: ERROR no statement executing (perhaps you need
to call execute first)
[for Statement select distinct a.cn, a.email from admins
?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
this helps.
It does. Thank you.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On Dec 30, 2011, at 6:55 PM, Bruce Johnson wrote:
I would say yes, here's mine (from MacPorts):
Well, I found this:
http://probably.co.uk/problems-installing-dbdmysql-on-os-x-snow-leopard.html
that was supposed to fix the issue.
It didn't, so I took the brute-force kludge
93405392 Nov 23 08:04 libmysqld-debug.a
-rw-r--r-- 1 root wheel 85193728 Nov 23 08:07 libmysqld.a
-rw-r--r-- 1 root wheel 8488 Nov 23 08:07 libmysqlservices.a
drwxr-xr-x 14 root wheel 476 Nov 23 08:09 plugin
Any ideas?
--
Bruce Johnson
Wherever you go, there you are B. Banzai
On Dec 29, 2011, at 3:36 PM, Bruce Johnson wrote:
I tried installing Bundle::DBD::mysql via cpan, but got errors about how it
couldn't find mysql_config, so I downloaded the DBD::mysql package manually
and used perl Makefile.pl --mysql_config=/usr/local/mysql/bin/mysql_config
which
and be disconnected,
then you shouldn't be running into timing issues.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
doing DB programming for years but every now and again I waste 10-15
minutes on mysteriously disappearing data because I forgot to commit.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
and see
if it works now)
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
elsewhere for speed improvements
Quit making Perl do the work of Mysql, in other words.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On Feb 18, 2011, at 1:55 PM, Bruce Johnson wrote:
Figured it out.
The second ldap query did not return all the attributes I was looking for,
and when it returned no value for that attribute, the bind variable wasn't
populated, leading to the mismatch between expected and actual
On Feb 21, 2011, at 11:11 AM, Bruce Johnson wrote:
On Feb 18, 2011, at 1:55 PM, Bruce Johnson wrote:
Figured it out.
The second ldap query did not return all the attributes I was looking for,
and when it returned no value for that attribute, the bind variable wasn't
populated, leading
On Feb 21, 2011, at 11:20 AM, Bruce Johnson wrote:
On Feb 21, 2011, at 11:11 AM, Bruce Johnson wrote:
On Feb 18, 2011, at 1:55 PM, Bruce Johnson wrote:
Figured it out.
The second ldap query did not return all the attributes I was looking for,
and when it returned no value
, and 19 param
values being passed, why am I getting this error?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
No, this is done as:
$csr=$dbh-prepare($sql)
then as $csr-execute(@parms) inside of a loop.
On Feb 18, 2011, at 12:33 PM, Bill Ward wrote:
You're probably calling do($sql, @args) when you should call do($sql, undef,
@args)
On Fri, Feb 18, 2011 at 11:31 AM, Bruce Johnson
john
a difference a byte makes... o/~
-Original Message-
From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu]
Sent: Friday, February 18, 2011 3:07 PM
Cc: DBI Users List (dbi-users@perl.org)
Subject: Re: One of us can't count
No, this is done as:
$csr=$dbh-prepare($sql
Tried it that way, same error.
On Feb 18, 2011, at 12:33 PM, Bill Ward wrote:
You're probably calling do($sql, @args) when you should call do($sql, undef,
@args)
On Fri, Feb 18, 2011 at 11:31 AM, Bruce Johnson
john...@pharmacy.arizona.edu wrote:
I'm getting the following error: (some
of that name, fixed it, and the script
runs without errors.
On Feb 18, 2011, at 1:20 PM, Bruce Johnson wrote:
This is a quickie version of what I'm doing:
$sql =insert into foo (bar, baz, buz) values(?,?,?);
$csr = $dbh-prepare($sql);
while (ldap query runs){
@parms =($val1,$val2,$val3
10.02.0400 dB.
make sure the query works in SQLPlus.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
,$cms_gateway_name,$cms_gateway_ip_address,
$cms_subnet_mask,$cms_subnet_notation,$cms_subnet_name,$cms_vlan_no) =
$sth-fetchrow()){...}
I know that works, I do it all the time.
Silly question, have you tested the query in SQLPlus or some other tool to
confirm that you're getting any rows?
--
Bruce
If $dbh is my database handle, to roll back the current transaction I
do: $dbh-rollback(); right?
The DBD::Oracle docs don't explicitly say
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On May 6, 2010, at 11:34 AM, John Scoles wrote:
Bruce Johnson wrote:
Depends if you have |AutoCommit| on or not and if you DB and DBD
friver can do a rollback.
I've explicitly turned autocommit off, so I can roll back transactions
if an error occurs.
In the old Oraperl syntax it's
work, and goes to
the next statement.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
, you're SOL. You can try
doing what you need with sqlplus scripts and procedures.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
WHERE msgid = 1892362 instead.
It's not much, but you're saving cycles and memory inside of a loop.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
is.
The simplest way to get MySQL working properly with the local perl, in
my experience, is to use MacPorts
http://www.macports.org/ (used to be DarwinPorts), and make sure
the /opt/... paths are in your ENV.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
))
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On Mar 26, 2010, at 11:01 AM, Bruce Johnson wrote:
Does the DBD enclose all parameters in ''s?
Am I actually trying to execute:
select reserved_id, reserver, purpose, to_char(starttime, 'HH:MI'),
to_char(stoptime, 'HH:MI') from reservedroomtest where roomid in
('105, 106, 110
1 - 100 of 128 matches
Mail list logo
