RE: LongReadLen issue
- From: jkstill@xxxxxxxxxx (Jared Still)
- Date: Sat, 28 May 2005 23:08:21 -0700
Also in the 'Supplied PL/SQL Packages' manual.
But I didn't actually use the manual.
I just did a 'desc dbms_lob'.
;)
Jared
On Thu, 2005-05-26 at 08:18, Reidy, Ron wrote:
> 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.
>
.
- References:
- RE: LongReadLen issue
- From: Ron Reidy
- RE: LongReadLen issue
- Prev by Date: Re: SQL -25507 error trying to build DBD::Informix on linux
- Next by Date: RE: problem with DBD::Oracle
- Previous by thread: RE: LongReadLen issue
- Next by thread: SQL Problems : No suitable driver
- Index(es):
Relevant Pages
|
|
