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
d I wonder 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
o 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 doin
your select):
>>
>> CREATE VIEW v_combined_months AS
>> SELECT 'January' AS "Month",sales FROM jan_sales
>> UNION ALL
>> SELECT 'February' AS "Month",sales FROM feb_sales
>> UNION ALL
>> SELECT 'March' AS "Month",sales FROM march_sales
>> [...]
>>
>>
>
--
--
Johannes Gritsch
Oracle DBA and Perl afficionado
Vienna, Austria
ggestions?
D. Scruggs
Lockhkeed Martin, Sunnyvale Ca.
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 Orac
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 norm
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 /usr/