RE: LongReadLen issue

Application Developer's Guide - Large Objects (LOBs)

-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.


-----Original Message-----
From: Tantalo, Christopher G [mailto:ctantalo@xxxxxxxxxxx]
Sent: Thursday, May 26, 2005 8:57 AM
To: Jared Still
Cc: DBI List
Subject: RE: LongReadLen issue


Which manual did you FR this from?

-----------------------------------------------
Just Your Friendly Neighborhood
_SPIDEY_


> -----Original Message-----
> From: Jared Still [mailto:jkstill@xxxxxxxxxx]
> Sent: Thursday, May 26, 2005 10:48 AM
> To: Tantalo, Christopher G
> Cc: Chuck Fox; DBI List
> Subject: RE: LongReadLen issue
>
> A little RTFM is in order.
>
> Try max(dbms_lob.getlength(mc.mc_long_description))
>
> Jared
>
> On Thu, 2005-05-26 at 07:27, Tantalo, Christopher G wrote:
> > I am not totally sure that is the issue. Using sqlplus and TOAD to
> > just do the simple select
> >
> > SELECT MAX(mc.MC_LONG_DESCRIPTION)
> >
> > FROM dmg.MAINT_CODES mc
> >
> > comes back with inconsistent datatypes.
> >
> > BTW, the I pulled the dbh statement from perldoc DBI under the
> > LongReadLen section.
> >
> >
> > -----------------------------------------------
> > Just Your Friendly Neighborhood
> > _SPIDEY_
> >
> >
> >
> > ________________________________
> >
> > From: Chuck Fox [mailto:ChuckFox2@xxxxxxx]
> > Sent: Thursday, May 26, 2005 10:12 AM
> > To: Tantalo, Christopher G; dbi-users@xxxxxxxx
> > Subject: Re: LongReadLen issue
> >
> >
> > Chris,
> >
> > The methods you are using are attempting to store an
> array into an
> > int.
> >
> > You need to get the value out of the first element of
> the array and
> > back into an int.
> >
> > Something like $dbh->{LongReadLen} = @{
> $dbh->selectrow_array( .....
> > ) }[0];
> >
> > Untested code, YMMV.
> >
> > Tantalo, Christopher G wrote on 5/26/2005, 9:58 AM:
> >
> >
> >
> > 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
> > });
> >
> > 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
> > });
> > 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_
> >
> >
> > --
> > Your Friendly Neighborhood DBA,
> >
> > Chuck
> >
> >
> >
> >
> > -----------------------------------------
> > 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.
>
>

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

.

Relevant Pages

  • RE: Selecting a record froma table where a column might be null
    ... Senior DBA ... > responsible for delivering this message to the intended recipient, ... > of this communication is strictly prohibited. ... please notify us immediately by replying ...
    (perl.dbi.users)
  • Re: Selecting a record froma table where a column might be null
    ... create table foo(i int, c char(10) null) ... >>responsible for delivering this message to the intended recipient, ... >>of this communication is strictly prohibited. ... please notify us immediately by replying ...
    (perl.dbi.users)
  • RE: LongReadLen issue
    ... > Array BioPharma, Inc. ... >>> of this communication is strictly prohibited. ... please notify us immediately ... > intended recipient, please be aware that any disclosure, copying, distribution ...
    (perl.dbi.users)
  • Re: [Full-Disclosure] Robert S Johnson is out of the office.
    ... > responsible for delivering this message to the intended recipient, ... > communication is strictly prohibited. ... I really dig the "please notify the sender immediately by replying to the ...
    (Full-Disclosure)
  • RE: [PHP] From form to an array
    ... > Each form is passed to an array already. ... ***The information contained in this communication is confidential. ... intended recipient, you are hereby notified that any dissemination, ... original message, and any copy of it, from your computer system. ...
    (php.general)