Clob length 4000. I was calling from a Java app so I simply concatenated .

Clob length 4000. Original table data must not be modified. GETLENGTH(v_clob)); END; In this example, we declare two variables: v_text, which is a VARCHAR2 variable that holds the Jan 13, 2014 · In SQL, you limited to 4000 bytes of character text (until 12c, at which time it will be 32k). The max size of my XML would be 5kb. '; v_clob := TO_CLOB(v_text); DBMS_OUTPUT. SUBSTR function in Oracle is a part of the DBMS_LOB package, is specifically used to extract a substring from a LOB (Large Object) value, which can be either a BLOB (Binary Large Object), CLOB (Character Large Object), NCLOB (National Character Large Object), or BFILE. e i want to fetch more than 4000 byte characters. PUT_LINE('CLOB Length: ' || DBMS_LOB. any workaround? i am going to return this substr result as part of a ref cursor, this is just a simulation. TO_CHAR converts the CLOB column to a VARCHAR2 data type so it can be used in the LENGTHB() function. However, I have the following procedure. I need help i. Jan 7, 2025 · How to Perform Search and Replace in a CLOB using DBMS_LOB package (Doc ID 122745. But really, under the hood, it’s just a CLOB. A quick fix for you would be to change 32000 into 4000 - you'll get the first bit of the clob. Apr 23, 2012 · Home » SQL » LISTAGG with CLOB? String aggregation exceeding 4000 characters with XMLAGG. Set the max_string_size parameter to extended 2. SET_BODY_CHARSET (r => vHTTPRequest, charset => 'UTF-8'); which is the industry standard http character set for http request content now. Inserting CLOB data which is more than 4000 characters into Oracle Table I was trying to insert 4000+ characters data into an Oracle table having CLOB as data type, but could not do that. the following is the sample data. Should I switch to Perl or Python or the like? Is there is a way to find out the number of bytes used by a particular field value (which may or may not be longer than 4000 characters) in an Oracle SQL query? dbms_lob. See the documentation for more Nov 25, 2023 · In Oracle the listagg function is limited to 4000 characters. Dec 6, 2023 · Convert your clob to blob and get byte length as you are doing (specify AL32UTF8 as charset id) Send your request data via the blob in 32k chunks using DBMS_LOB. GETLENGTH(lob_loc IN LOB) lob_loc: This is a LOB locator that points to the LOB whose length you want to retrieve Oct 28, 2015 · I've used this tool for a wide variety of other parsing projects. The simplest solution, however, would be to set up an RESTful service using ORDS. How do I calculate specific CLOB length when it size is greater than 4000 characters ? At the beginning this task seemed to me quite trivial but I'm having realy hard time figuring this one out TES Feb 1, 2011 · Actually I used the following function in my database query DBMS_LOB. Aug 23, 2013 · Oracle is the worst database I've ever worked on, often it has the ability to make complex a very simple task! The maximum for one time insertion is 4000 characters (the maximum string literal in Oracle). Please advice! Nov 30, 2007 · The above snipper works till 4000 chars but not above that. I tried to use this SELECT REGEXP_SUBSTR (file_cont, ' [^'||chr (10)||']+', 1, LEVEL) AS substr from data_tab where Dec 11, 2017 · The application code does a 'SELECT SUBSTR (<clob_column>,1,4000) STUFF' and when it finds a multi-byte character in the first 4000 it returns more than 4000 bytes and raises the above ORA-64203 error. CREATE OR REPLACE PROCEDURE CLOB_TAB_TEST IS NUM CLOB_TEST. Characters can repeat. Bookmark the permalink. 1) Last updated on JANUARY 07, 2025 Applies to: PL/SQL - Version 9. The basic syntax is as follows: DBMS_LOB. If the text exceeds 8000, you could in theory keep going I think - although I have never run into a situation where I have had to exceed that amount. text order by t. using simple insert statement The one problem still remains (when the result CLOB is getting big: about 1000000 bytes in my case): ORA-22926: specified trim length is greater than current LOB value's length. The length is returned as a number indicating the number of characters or bytes in the LOB, depending on its type (CLOB/NCLOB or BLOB/BFILE, respectively). If I change the length of the filter something below 2000 the query would run without errors. Nov 22, 2024 · This code utilizes three functions: SUBSTR(,1,4000) returns the first 4000 characters of the CLOB column. 0. SUBSTR provides a way to fetch 4000 characters at once. The maximum value of varchar2 is 4000 bytes, and what data type is used to store the data above this? I created a column using clob and ma Apr 23, 2002 · Reading Data in Clobs that are > 32767 K Hello Tom,I am faced with the challenge of dealing with CLOB values that aregreater than 32767 characters in length. Longer values may only be entered using bind variables. LENGTHB() returns the length in bytes of the converted CLOB column. For these cases, you should use clob. May 23, 2016 · The answer marked correct will not work if "reason1||reason2||reason3" exceeds 4000 chars. Field value length: 32767 bytes. Is there a way to deal with such big file size? or how do I modify my clob to read this file? Dec 12, 2017 · You have a couple of options: 1. Sep 6, 2016 · Hello Experts,Can anyone share me some inputs on loading CLOB type data into oracle database. Thanks to explicit type conversion! This entry was posted in SQL, Tipps & Tricks and tagged CLOB, SQL by Peter Raganitsch. I am from MS SQL background and not aware of Oracle queries. expression2 An expression that returns a value of built-in SMALLINT or INTEGER data type. What you should retrieving is the LOB locator itself, the client can dereference it at will and see as much or as little as it wants. In SQL Server, you can use VARCHAR (max) or NVARCHAR (max) to store stores variable-length character data up to 2 GB. What size of CLOB column should I define while creating the table? I have a table with a CLOB that stores a big JSON payload. substr(column,4000,1) part1, dbms_lob. How is CLOB different from VARCHAR2? CLOB can store much larger text data than VARCHAR2. When applied to a BLOB (Binary LOB), dbms_lob. substr to copy data from a clob to a varchar2 (4000 char), but I am getting "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" Mar 4, 2015 · It's certainly faster than the XML solution, here is the throughput difference from 100 iterations of each. getlength return the number of characters when applied to a CLOB (Character LOB). The most painful limit in Oracle is the 4000-byte maximum length of a VARCHAR. May 23, 2004 · one clob or two varchar2 (4000) tom:This is my last question today. CLOB A character large object (CLOB) is a varying-length string with a maximum length of 2,147,483,647 bytes (2 gigabytes minus 1 byte). Example 13-5 illustrates this. getLength() returns the nu Jun 15, 2020 · HiI need to replace a text string in clob column of a table. Then an inline view can remove any values where the length is greater than 4000. Oct 14, 2024 · Explore in-depth methods and examples to query CLOB columns in Oracle using various approaches, including the DBMS_LOB package and SUBSTR function. g. 1, you can increase the maximum length of varchar2 in SQL to 32,767. Dec 25, 2007 · I guess its beacuse of the size limit for clob (4000 characters)/ datatype varchar2 limit (32767). . It's not quite as straightforward as running an alter system. substr(column,4000,1) so for my HughClob which was larger, I had to use two calls in select: select dbms_lob. Nov 22, 2024 · The CLOB data type can store up to 4GB of character data, but it has a restriction of inserting only up to 4000 characters at a time. substr(column,4000,4001) part2 from . Nov 15, 2020 · Plsql CLOB ChunkSize: 4000 Plsql BLOB ChunkSize: 4000 Java CLOB ChunkSize: 4000, BufferSize: 32000 Java BLOB ChunkSize: 4000, BufferSize: 32000 ----------**** CLOB length: 32767 We can see that Plsql and Java ChunkSize are the same as SQL for 8k, 16k, and 32k, and their BufferSize are always 32528. If the resulting string exceeds 4000 characters then an error is raised. I have this CLOB column and I need to display it using a select statement. Oct 14, 2021 · I am making a table in which I am storing XML. These columns are useful for storing large documents or significant text-based data. May 30, 2002 · length limitation of CLOB in pl/sql Hi Tom,I understand there is a length limitation (max 32000) for all the plsql variable. create table foobar ( mykey integer, moby expression1 An expression that returns a value of built-in character string or binary string data type. VALUE_COL%TYPE; -- CLOBBEGIN NUM := 2; Sep 7, 2012 · Hi , I have to retrive the CLOB data into varchar2 and spilt those comma seperated values into rows but i am getting following error " ORA-06502: PL/SQL: numeric or Apr 13, 2012 · Up to 4000 bytes can be stored in-line in the tablespace. *Action: Use a string literal of at most 4000 characters. For instructions on how to do this, read: https://oracle-base. The dbms_lob. However you can use the lob function dbms_lob. A node that has more than 1024 children is ignored by a data guide. Instead of REGEXP_REPLACE(, ',$')) you can use RTRIM(, ','), which should be faster, but will remove all separators from the end of the result (including those that can appear in name at the end, or previous ones if last name s are empty). net core. Example: with data as ( -- Generates: -- - Numbers each 20 digits in length -- - Alph Mar 15, 2001 · Even with 4K length, when I try to convert clob to varchar2 using DBMS_LOB. I have a varchar2 variable defined that is over 4000 characters long and I want to use Jul 19, 2015 · The problem isn't really the substr function. Jan 12, 2019 · I have a CLOB text similar to: A:123, A:983, A:122, B:232, B:392, C:921, D:221, D:121, D:838 I want to have my result like A:123, 983, 122, B:232, 392, C:921, D:221, 121, 838 Please note, It's huge data and definitely more than 4000 characters. For data objects that are larger than 32 KB, you can use the corresponding large object (LOB) data types to store these objects. All of this is transparent to the user. Nov 16, 2020 · Some people might argue that this limit has changed in more recent versions of Oracle. However, in the staging and production databases, data lengths for dev-equivalent CLOB columns are odd numbers like 86. In a real query you may need to add a partition by to the analytic functions, to only count per some group. SUBSTR(T1. If your query might return more than this, you must either specify a larger length, e. Oct 11, 2019 · Yes this is correct-- confirming it worked for me. Feb 20, 2017 · How to fetch up to 5MB of text/string/data from a larger a clob in oracle Hi Oracle, CREATE TABLE XMLISSUE ( xmltablecolumn clob );</code>Created a tableAs shown below code I have inserted some data to clobDECLARE XMLCLOB clob;BEGIN SELECT XMLTYPE ( Aug 27, 2011 · Now, about these CLOB columns: When using desc and/or querying the all_tab_columns view for the dev database, CLOBs show a data length of 4,000. If a JSON field has a value longer than 32767 bytes then the data guide reports the length as 32767. When I create a table with a CLOB in it, the CLOB column is reported to have a DATA_LENGTH of 4000: How can I interpret that? Is that some backwards-compatible tweak, considering that the limit for VARCHAR2 is also 4000? Nov 25, 2012 · I have searched the internet and cannot find a sample of loading a > 4000 character clob into an Oracle database using ODP. I have to read that clob data as Varchar. GETLENGTH function is used to retrieve the length of a LOB value. 0 - 64bit ProductionPL/SQL Release 12. 8 and later Information in this document applies to any platform. Varchar2 variables… Jan 9, 2014 · Hi All, Do you know how to replace a text in a clob with a clob? Thanks, Majid Unless otherwise specified, they return a VARCHAR2 with a maximum of 4000 bytes. SUBBSTR (field,4000,1) but i got data up to 4000char. Jan 10, 2018 · how to read clob data as varchar which has length morethan 4000 I have an XML data in Oracle with ClOB as Datatype. line) as string_array_t ), p_delimiter => chr(10)) as text VARCHAR2's limit is 4000 CHAR, so you have to use a CLOB for columns of length 4000 or more. I think it may improve performance, what do you think? I did run into another condition with HugeClob in my Oracle database. For a VARCHAR the maximum length is 4000 bytes and for a CLOB or a binary string the maximum length is 1 048 576 bytes. ALL concatenated columns need to be TO_CLOB ()'d at least the first column needs to be TO_CLOB'd [~edited~ thanks @rp0428] Mar 20, 2001 · Inserting a CLOB data Hi Tom, This is in continuation of my question on how can I insert streams of characters coming from HTML form into a oracle database table CLOB column. Dec 3, 2020 · 0 I have a store procedure in oracle which takes string input through a varchar2 type input parameter,I believe that 4000 bytes is the max length we can pass through the parameter, i need to have more characters in my input, what would be a viable solution? Oct 23, 2015 · Hi, I need to return a variable of length more than 4000. So, in this post, let’s look at the available options t… CLOB, NCLOB, and BLOB values up to approximately 4000 bytes are stored inline if you enable storage in row at the time the LOB column is created. May 20, 2004 · Spent alot of time trying to find some sample code to replace all occurrences of some text with new text for CLOB variables in PLSQL. As you pointed out the number of LONG columns per table is 1, but you can have as many as 1000 CLOBs per table (1000 is the maximum number of columns for any table). I have text, which contains 100 000 character, how can I run query like this: UPDATE Aug 2, 2011 · Even if I specify a sort order to the data coming in (there is an internal sequence number), the 30 rows are scattered throughout the CLOB. Dec 12, 2017 · max_string_size Starting in 12. But all Oracle did was use CLOB data types to store variables larger than 4000 characters under the hood. String h 142 length and dbms_lob. i had the datatype as string but it is not returning the complete string. e. I have an text file which has some columns of about length 4000. com/articles/12c/extended-data-types-12cR1 Extract as clob When you need to store longer strings, such as large documents or text blobs, you have to use a different data type, namely CLOB (Character Large Object). This table documents the limits for datatypes, and includes comments about the datatypes. For most Web applications, this turns out to be long enough to hold 97% of user-entered data. 'This string literal has a 4000 byte limit. There is a (historic) limitation of 4000 bytes in a CHAR / VARCHAR2 data types and this includes string literals. if any have buddy have solution th… How does Oracle store clob data over 4000 length, do you know, Programmer Sought, the best programmer technical posts sharing site. It can also go till 11 digits. Number of children under a parent node: 1024, maximum. DBMC_LOB. I know that in oracle PL varchcar2 can be around 32000. A CLOB is designed to store large SBCS data or mixed data, such as lengthy documents. LISTAGG with CLOB? String aggregation exceeding 4000 characters with XMLAGG. The result should not be Jun 9, 2017 · @Daoud where are you getting the "default size of 4000" from? If it's from dba/all/user_tab_columns, then ignore it. 4w次，点赞15次，收藏98次。本文详细介绍Oracle数据库中CLOB字段的三种存储方法，包括使用存储过程、to_clob函数和MyBatis实现超过4000字符的长字符串存储，解决ORA-01704错误。 In Oracle, CLOB data type stores variable-length character data (character large object) in the database character set that can be single-byte or multibyte (supports more than 4 GB). Note that this solution only works for CLOBs that are 4000 bytes or Jun 8, 2020 · Could you please let me know what is the Data length for the 2nd column_id of "CLOB" data type in the Employee table? I see some blogs where it says maximum data length is : (4GB -1)* (database block size). It is rather the maximum length of a varchar2 in SQL: 4000 bytes! That means than even this statement will fail: select x, dbms_lob. Additionally, no you don't need returning clob on the inner json_object unless you do :) (if you go over default varchar2(4000)), but I also wonder what happens if you try to cast a clob to a clob? Feb 3, 2015 · from products; 11. Didnt find any, but noticed a few other posts looking for similiar code so i broke down and wrote one. It can hold up to 4 GB of character data, such as documents, XML files, and large text strings. Nov 22, 2024 · Table of Contents Converting CLOB to VARCHAR2 in Oracle PL/SQL: A Quick Guide Converting CLOB to VARCHAR2 in Oracle PL/SQL: A Q&A Guide Summary: In Oracle PL/SQL, it is possible to convert a CLOB (Character Large Object) to VARCHAR2 (Variable Character) using the CAST function. substr only allowed a value of 4000 in the function, ex: dbms_lob. Mar 27, 2009 · Hi I have a report which would display a CLOB field having text of length around 32000 characters. Using PHP as front end. SUBSTR, its throwing ORA-06502: PL/SQL: numeric or value error: character string buffer too small. A table is created with two rows of data. To store XML I am using CLOB data type. It is possible to split the clob directly using the DBMS_LOB package or through the overloaded SQL functions; but clobs are expensive objects. substr(y,2001,1) from t where x = 2 That is true since 2001 characters of two bytes is 4002 bytes, which is more than the data type can handle. The table contains 8M+ rows. I was calling from a Java app so I simply concatenated May 30, 2016 · Just declaring a variable of type clob, is equivalent to varchar2 (32767) in plsql. CLOB_COL,4000,1) CLOB_COL from T1 My problem Jul 6, 2004 · Tom, Why use inline CLOBs over a varchar2 (4000)? An inline LOB is for data under 4000 bytes in length. I am working on a datbase and one of the table may exceed 4000 bytes, but it doesn't happen a lot. 0 - Product Feb 4, 2015 · Discusses how to insert column values exceeding 4000 characters in SQL & PL/SQL without using CLOB or BLOB data types. 2 to 12. For example, take a json like this: { "foo&quo May 15, 2017 · I want to convert all data in CLOB to string. ' This has nothing to do with a CLOB data type or the TO_CLOB function. 1. RETURNING CLOB. Can someone help me with A large object (LOB) is a string data type with a size ranging from 0 bytes to 2 GB (GB equals 1 073 741 824 bytes). JSON data guide Path length: 4000 bytes, maximum. One of the interesting tuning techniques I used was to pull the clob apart into 32K varchar2 chunks. getlength will return the number of bytes, which may differ from the number of characters in a multi-byte character set. I've searched for every possible solution as to how this could have come about. Sep 7, 2011 · I know that in sql varchar2 can only be around 4000. The result of the function is: Jul 31, 2019 · So you check your clob data and all of them has 4000 bytes length unfortunately all of those data are in the lob segment not in the table! why? because of the large object overhead! every large object has some header information and this is the part of that magical number “4000”. For example, I have to read a record's CLOB value which has a length = 946056k. For example, you can store information such as an employee resume, the script of a play, or the text of novel in a CLOB. 1. 2. But Temporary Lob is special. without having to store the CLOB in memory outside of the table and then adding a pointer to the memory area in the table row). Zero-length field name: A zero According to documentation CLOB and NCLOB datatype columns, can store up to 8 terabytes of character data. append() to append chunks of (maximum) 4000 characters to the clob: l_clob clob; FOR i IN 1. The VARCHAR, VARGRAPHIC, and VARBINARY data types have a storage limit of 32 KB. Sep 7, 2017 · I need to load a CSV file into table using sql loader but the lenth of a column is exceeding the Max length of varchar2 data type. A path longer than 4000 bytes is ignored by a data guide. If you want a "real" clob, you either create one explicitly, or get one back from a table and use that. In this guide, we will explore how to efficiently insert and retrieve strings longer than 4000 characters in an Oracle database using Java and JDBC. Jan 19, 2018 · Acording to older questions on similar topic on SO and reference on Oracle documentation a string-length of 4000 should be fine for DBMS_LOB. Syntax The DBMS_LOB. SUBSTR (). What is a CLOB in Oracle? A CLOB (Character Large Object) is a data type in Oracle used to store large text-based data. Create table statement : CREATE TABLE TEST_PIPE_SEP (FILE_NM VA Nov 23, 2015 · Bind a CLOB instance or a string to an INSERT, UPDATE, or DELETE statement, and use the XMLType constructor inside SQL to construct the XML instance. To do this, you need to set max_string_size = extended. EQTN_SQL_TEXT) ,4001,8000) to catch the second half of your field. The database uses Oracle. This guide answers common questions regarding the conversion process, provides a step-by-step explanation of the code May 29, 2018 · Dear experts, I am trying to insert more than 4000 characters by using clob,it is not allowing to insert i am getting below errror while inserting SQL Error: ORA-01704: string litera Sep 2, 2020 · I am developing using . Jun 16, 2025 · Unfortunately, you will likely lose some valuable information if there is text larger than 4,000 so you could create another field that is SUBSTR ( TO_CHAR (I. I am thinking instead of using one clob, probably i can use two varchar2 (4000) column. I used DBMS_LOB. I tried to use DBMS_LOB. Oct 14, 2024 · A CLOB column in Oracle stores large amounts of character data, capable of holding up to 4GB of text. 10. This function is particularly useful when you need to manipulate or display parts of a LOB without needing to Nov 27, 2009 · The winner is:LENGTHB (TO_CHAR (SUBSTR (<clob-column>,1,4000))) this one really returns the size in bytes the string would consume when stored in a VARCHAR2 column. The remaining 3% are sufficiently important that you might be unable to use VARCHAR. Meaning it looks like you can have longer varchar2 values. name, string_array2clob(cast(collect(t. SUBSTR(<field_name>,32000,1) on the query so that it shows the text a Please help me to convert a string of length more than 4000 (around 8200) to cloborNeed to insert charters of 8000 bytes to a clob column. The number 4000 means the number of characters for CLOB (according to Oracle refrence). Both rows it will return CLOB that has no size limit, handles correctly XML entity escapes and separators. I cannot however select certain attributes whose value is greater than 4000 bytes. Sep 15, 2017 · Generating large json in 12. Long string coming from PHP. READ and UTL_HTTP. Apr 29, 2025 · In DB2, CLOB (Character Large Object) is a data type used to store large amounts of character - based data, such as long text documents, XML data, or any other data that consists of a large number of characters. 1 An analytic function can generate a running total length of the string aggregation. If the length of the CLOB exceeds 4000 bytes it must be stored in/readed from LOB storage area via special functions. Purpose This sample illustrates how to do search and replace in a CLOB column or a CLOB variable using the DBMS_LOB package. Oracle8 includes a Character Large Objects (CLOB) data type, which can be up to 4 GB in size. ID_COL%TYPE; -- INT V_VALUE CLOB_TEST. 2. Oracle Database 12c Enterprise Edition Release 12. Jun 18, 2022 · Aggregate query as usual but using cast and collect instead of listagg and at the end convert it to clob with function from step above: select t. 2 using json_object and json_arrayagg Is it possible to get a result from the following query?select JSON_OBJECT ( KEY 'objects' VALUE (SELECT JSON_ARRAYAGG ( JSON_OBJECT ( KEY 'object_type' VALUE object_type, KEY Nov 19, 2021 · 1 There is a limitation to insert more than 4K characters into clob No, there is not. Example Here is an example of how to use the TO_CLOB function in a PL/SQL block: DECLARE v_text VARCHAR2(4000); v_clob CLOB; BEGIN v_text := 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Numbers are always unique. The DBMS_LOB. '<POSLog> <Transaction> <UnitID>1101</UnitID> <WorkstationID>1</WorkstationID> <TransSequenceNumber>22142</TransSequenceNumber> <Transactio May 22, 2024 · In my previous posts, while explaining JSON Relational Duality Views, I mentioned that I encountered ORA-40478: output value too large. If I use the same function in its initial form (VARCHAR2) on a rowset less than 4000 characters, it works correctly. WRITE_RAW, after specifying UTL_HTTP. SUBSTR to convert it to varchar2: select DBMS_LOB. I would assume that the data_length for LOB columns refers to the maximum amount of data that can be stored inline (i. Avoid the implicit conversion to a varchar2 by extracting the data as clob max_string_size Starting in 12. PL/SQL has a 32k limit. Another workaround involves a CASE statement. Mar 15, 2001 · I am trying to use dbms_lob. While VARCHAR2 is limited to 4000 bytes (in most cases), CLOB can store data up to 4 While updating a field that will have more than 4000 chars, I was given a error : ORA-01704: string literal too long So, going through few blogs, I got this: declare May 11, 2020 · I am trying to insert approximately 15000 rows, the problem is that there is a column of type CLOB that can have more than 4000 characters giving the error ORA-0 Jan 28, 2018 · Oracle - TO_CLOB doesn't work on SELECT to convert a 4000 CHARs long String Asked 7 years, 9 months ago Modified 7 years, 9 months ago Viewed 16k times May 6, 2021 · I am trying to split a huge CLOB which contains lines with more than 32K characters. Although, there are ways to insert more than 4000 characters into a CLOB column, and we will explore them in this Q&A Session. what should be the datatype of the column if i need to return a readable string with length more than 4000? Thanks in advance, Prashanthi. ( size of the file is 900MB,)when i am reve Aug 27, 2018 · select count(*) from my_table where my_field = substr('',4000,1) When I run the query, I get an error: 00000 - "string literal too long" *Cause: The string literal is longer than 4000 characters. Aug 15, 2025 · 文章浏览阅读4. However, applications often need to store large text documents or additional data types such as audio, video, drawings, images, and a combination of text and graphics. RETURNING VARCHAR2(32767), or request a CLOB, e. For instructions on Nov 26, 2024 · Hi, We are encountering an error when concatenating two columns in the report(OAC), as the combined number of characters exceeds the 4000-character limit. Why have inline LOBs when we can use varchar2? Wouldn't you rather just create a varchar2 (4000)? It seems like less maintenance and more user-friendly to just use varchar2 (4000). LOBs greater than 4000 bytes are always stored externally. mjusy bnt rbimt q5b ximcv0 7hk fpy3j ng an ylemu

Any unauthorized reproduction of articles, photographs, charts, etc. published on MANTANWEB is prohibited. Copyright belongs to MANTAN or its information providers.