Thank you, this is exactly what I was looking for.
best wishes
hannes
On 06/02/2010 02:31 PM, John Scoles wrote:
Johannes Gritsch wrote:
DBI does support bulk operations and what you are asking about is the
array interface.
It does it though the 'execute_array'
http://search.cpan.org/~timb
that this topic
did not come up again in recent years - or I just missed it ...
cu
hannes
--
Johannes Gritsch
Unix consultant and Oracle trainer
Vienna, Austria
I'd like to perform an EXPLAIN PLAN on a query that has question mark
placeholders.
I've seen perl scripts which perform EXPLAIN PLAN commands, but the
queries they operate on don't have placeholders.
Any pointers on how I would go about doing this?
Thanks,
ER
--
--
Johannes Gritsch
[...]
--
--
Johannes Gritsch
Oracle DBA and Perl afficionado
Vienna, Austria
.
The command SET is a builtin command of sqlplus, not a valid SQL
command. Thus the database does not understand it. You eiher could use
the SQL-function NVL to circumvent NULLs or check within Perl with
'defined'.
HTH
Hannes
--
Johannes Gritsch
www.linuxification.at
tom r schrieb:
Installing DBD::Oracle on Gentoo Linux fails with the following error:
x86_64-pc-linux-gnu-gcc: unrecognized option '-wchar-stdc++'
x86_64-pc-linux-gnu-gcc: unrecognized option '-cxxlib-gcc'
cc1: error: /ee/dev/bastring.h: No such file or directory
I tracked this down to the
Obviously root user gets another PATH variable than a normal user. From
your output I would assume the correct perl version to use is somewhere
under /usr/local (most probably /usr/local/bin). Rearrange PATH for root
before calling perl should do the trick.
If in doubt, do
echo $PATH
as
Looks as if gcc gets some parameters it does not understand. Is +b a parameter
for the native C-Compiler
for HPUX? This would mean that somewhere the system still tries to use
HPUX cc and not gcc. Maybe your path variable leads to this (wrong)
conclusion. It still contains /opt/ansic/bin and