| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Longs and LOBs with DBI
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFCF32.8B722010
Content-Type: text/plain;
charset="iso-8859-1"
The consequence of changing the data type to clob is as follows : You will not be able to use indexes on the column, the column will have to e
-----Original Message-----
From: Alex Hillman [mailto:alex_hillman_at_physia.com]
Sent: Monday, June 05, 2000 5:58 PM
To: Multiple recipients of list ORACLE-L
Subject: Longs and LOBs with DBI
Is there any difference in working with LONG datatypes versus LOB datatypes in PERL DBI? I could not find any. In a sence I need an answer if I change type of column from LONG to CLOB or BLOB, will I have to do any changes in PERL code.
Alex Hillman
------_=_NextPart_001_01BFCF32.8B722010
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Longs and LOBs with DBI</TITLE>
<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=252131121-05062000>The
consequence of changing the data type to clob is as follows
:</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=252131121-05062000>You
will not be able to use indexes on the column, the column will have to
e</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Alex Hillman
[mailto:alex_hillman_at_physia.com]<BR><B>Sent:</B> Monday, June 05, 2000 5:58
PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Longs
and LOBs with DBI<BR><BR></DIV></FONT>
<P><FONT face=Arial size=2>Is there any difference in working with LONG
datatypes versus LOB datatypes in PERL DBI? I could not find any. In a sence I
need an answer if I change type of column from LONG to CLOB or BLOB, will I
have to do any changes in PERL code.</FONT></P>
<P><FONT face=Arial size=2>Alex Hillman</FONT> </P></BLOCKQUOTE></BODY></HTML>
Received on Mon Jun 05 2000 - 16:10:58 CDT
 |
 |