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  3380  -
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 xmltype column in another table. But i get always
the error message:
java.sql.SQLException:
ORA-00600: internal error code, arguments: , , , , , , ,
ORA-06512: in "SYS.XMLTYPE", line 0
|
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 data from one table/tablepace to another observed
the following:
Exported lobfile = 291 MB (average 60K / CLOB object)
|
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
valid. Reason code "103". If a host variable or S
QLVAR in the SQLDA is invalid then: host variable/SQLVAR number = "5",
SQLTYPE = "393", SQLLEN = "33", host variable/SQLVAR type = "INPUT".
SQLSTATE=07002
|
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 DB2. I have the following table:
create table docs(
doc_id integer,
docs clob(),
constraint pk PRIMARY KEY (doc_id))
|
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 INT
FILE_DATA CLOB
)
|
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 that?
Here is the ASPX code:
<asp:datagrid id="grdTentativeResults" Width="800" Runat="server"
|
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 = $arguments;
|
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 following:
1) gets query string from url and filters records (works great) via a Details View
2) shows notes that have been added to the record shown in the details view using a grid view, and it filters the data by looking at the ID that is selected in...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
