I want explanation for CLOB datafield
1.I created clobtable with the query
create table clobexample(id number,text CLOB);
2.I tried to insert very large text by the following query
insert into clobexample(1,'here i added very large text');
3.the error is
SP2-0232: Input too long. Must be less than 241 characters
why i am unable to insert very large text in CLOB field.
7 3346 -
SQL> create table clobexample(id number,text CLOB);
-
-
Table created.
-
-
SQL> insert into clobexample values(1,'here i added very large text')
-
SQL> /
-
-
1 row created.
-
-
SQL> select * from clobexample;
-
-
ID
-
----------
-
TEXT
-
--------------------------------------------------------------------------------
-
1
-
here i added very large text
-
-
-
SQL>
-
Your insert statement is of incorrect syntax!!
use this - create table clobexample(id number,text CLOB);
-
-
insert into clobexample values(1,'here i added very large text');
-
use this - create table clobexample(id number,text CLOB);
-
-
insert into clobexample values(1,'here i added very large text');
-
if i give below 241 characters insert query is accepting .But,if more than 241 charcters are inserted i am getting error
SP2-0232: Input too long. Must be less than 241 characters
I have executed this successfully without any errors. -
INSERT INTO clobexample VALUES(1,'here i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large text');
-
What is the version oracle that you are using ?
I have executed this successfully without any errors. -
INSERT INTO clobexample VALUES(1,'here i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large text');
-
What is the version oracle that you are using ?
the version i am using is oracle10g.
the version i am using is oracle10g.
I have also executed on 10.2.0.1.0 and it is working fine for me without any error.
Hello,
U have skipped the VALUES clause in the insert statement.
The correct sysntax is
insert into table_name(col1, col2) values ( val1, val2);
Thanks,
BMantri
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: rabbit |
last post by:
Hi all,
I want to know, how can i insert the xml data using createXML() with
CLOB in the xmltype column?
I store the xml data at first in the clob column und want to import
these data in the...
|
by: Pablo |
last post by:
I have observed a significant discrepancy between the amount of space
used in a long tablespace when using import as compared to load.
Can anyone explain the following?
In an attempt to move...
|
by: Dark |
last post by:
Im trying to insert a clob into the database and I get the following
error.
DBD::DB2::st execute failed: SQL0804N The
application program input parameters for the current request are not...
|
by: Nina via DBMonster.com |
last post by:
Hi,
I'm trying to insert a clob / blob from the local file system into a basic
table. This can be quite easily accomplished in Oracle but I have not found
any wquivalent way on how to do this in...
|
by: gimme_this_gimme_that |
last post by:
Is there a command line trick that inserta ascii text into a CLOB
column?
Thanks.
| |
by: annecarterfredi |
last post by:
I need some help....
I have XML files residing on the database server harddisk. I want to
load those files as CLOB into a table column. The table is defined like
this:
Table_0 (
ID ...
|
by: settyv |
last post by:
Hi,
I need to generate PDF stream when i click on Linkbutton in datagrid
..At present i hardcoded the
DMS Id and now it is working.But i need to pass DMS ID when click
linkbutton.How can i do...
|
by: *Davide* |
last post by:
Hello,
This query (PHP+Oracle) works:
global $user,$pass,$sid;
$db_charset = 'UTF8';
$db = OCILogon($user, $pass, $sid, $db_charset);
$clob = OCINewDescriptor($db, OCI_D_LOB);
$txt_clob =...
|
by: troydixon |
last post by:
Hello,
I am new at this, and have been trying to insert data into a table by using the footer of a gridview (which I dont like) or by using a detials view on the same page that is doing the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |