I am trying to set the
LongReadLen value of $dbh dynamically to select a CLOB,
using:
$dbh->{LongReadLen}
= $dbh->selectrow_array(qq{
SELECT MAX(mc.mc_long_description)
FROM dmg.maint_codes mc
});
SELECT MAX(mc.mc_long_description)
FROM dmg.maint_codes mc
});
but get this error
DBD::Oracle::db selectrow_array failed: ORA-00932: inconsistent
datatypes (DBD ERROR: OCIStmtExecute/Describe) at eleadtest.pl line
27.
Then, I noticed a different version of the
above:
$dbh->{LongReadLen} =
$dbh->selectrow_array(qq{
SELECT MAX(OCTET_LENGTH(mc.mc_long_description))
FROM dmg.maint_codes mc
});
SELECT MAX(OCTET_LENGTH(mc.mc_long_description))
FROM dmg.maint_codes mc
});
but get this
error
DBD::Oracle::db selectrow_array failed: ORA-00904: invalid column
name (DBD ERROR: OCIStmtExecute/Describe) at eleadtest.pl line
27.
(Yes the spellings are
correct)
If I set $dbh->{LongReadLen} =
70000;
that works fine, but I would like this to be dynamic so the
memory is not too small, or too big.
Thanks in
advance,
Chris
-----------------------------------------------
Just Your Friendly
Neighborhood
_SPIDEY_
The information contained in this message may be privileged,
confidential, and protected from disclosure. If the reader of this
message is not the intended recipient, or any employee or agent
responsible for delivering this message to the intended recipient, you
are hereby notified that any dissemination, distribution, or copying of
this communication is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer.
Thank you. Paychex, Inc.
<<tech.gif>>
