Running DBI 1.58 and DBD::Oracle 1.19 with Oracle 10g (10.2) on Fedora 7
64 bit OS:
Copying a table from one tablespace to another tablespace (two $dbh
handles). The table has 56 fields. I've simplified the process to:
fetch row from first dbh
execute row to second dbh
commit every 100 rows
I have NLS_LANG=AMERICAN_AMERICA.AL32UTF8 as recommended in DBD::Oracle
when using utf8 and I need to as my data is utf8 in Perl.
Grossly simplified my code does:
o select integer_primary_key_field from table
o prepare(select from another_table where field = ?)
o execute($inter_primary_key_valu
When I did a tnsping today, I noticed that the connect method used was
EZCONNECT,
not TNSNAMES. Both are specified in my sqlnet.ora file.
If I remove EZCONNECT, my connect attempt just hangs.
If I remove the sqlnet.ora file, my program core dumps.
Interestingly enough, on another set of machin
